Using this.
http://dev.mysql.com/doc/refman/4.1/en/grant.html
On 9/29/06, Paolo Supino [EMAIL PROTECTED] wrote:
Hi Ruslan
And how to fix that?
TIA
Paolo
Ruslan Zakirov wrote:
You must connect as dba, see --with-db-dba option of the configure
script. I see you're using root and this
Hi Tim
I noticed that option after I wrote the email. I tried it and it
indeed created the database but it fails further down the line when it
tries to grant access. It's probably more an issue of mysql than RT.
Please take a look at the log below and see if you can help solve the
problem.
You must connect as dba, see --with-db-dba option of the configure
script. I see you're using root and this user has rights to create
databases. In the error below mysql says that user 'root' who is
connecting from 'rt.idssite.com' has no access to database 'rt3'
which means that rt3 DB is there
Hi Ruslan
And how to fix that?
TIA
Paolo
Ruslan Zakirov wrote:
You must connect as dba, see --with-db-dba option of the configure
script. I see you're using root and this user has rights to create
databases. In the error below mysql says that user 'root' who is
connecting from
On Tue, Sep 26, 2006 at 6:26 PM, in message
[EMAIL PROTECTED],
Paolo Supino [EMAIL PROTECTED] wrote:
I have a mysql database server already running on my lan and I want
to
use it for my RT system too. From whay I saw thus far the
installation
process assumes the database is local and I
Hi
I have a mysql database server already running on my lan and I want to
use it for my RT system too. From whay I saw thus far the installation
process assumes the database is local and I didn't see any documentation
on setting up the RT database on a remote installation of mysql.
Can
After make install step you must change RT_SiteConfig.pm and only then
run make initdb.
You're looking for next options:
$DatabaseHost - mysql server
$DatabasePort - mysql's port
$DatabaseUser - user RT uses to connect to mysql in normal conditions
$DatabasePassword - password of the above user