Re: [cobalt-users] MySQL Trouble

[Kris Dahl <krislists@xxxxxxxxxxxxx>]

on 8/8/00 9:02 AM, Brian Price at bprice@xxxxxxxxxxxxxxxxxx wrote:

> I'm a new user to MySQL.
> Running a Qube2 and also a Linux Box with Red Hat 6.2 where MySQL databases
> are. From a script on the Qube trying to connect to my database. I get a
> error message saying 'DBI->connect failed: Host '.....' is not allowed to
> connect to this MySQL server at xxxxxx.cgi line 7'. Can anyone steer me in
> the right direction or maybe I'm missing something real simple.

You need to grant permissions to have the Qube access the MySQL database.

Essentially (and this is from memory so may be off a bit, check your docs)

GRANT ALL on *.whateverdatabase TO user@host IDENTIFIED BY 'password'

Where host is the the qube2's ip or hostname and user is the user that you
provide when connecting to mysql.

Right now the statement that you are currently using is somethign like
GRANT ALL on *.whateverdatabase TO user@localhost IDENTIFIED BY 'password'
which means only connections coming from localhost are allowed to access the
MySQL db.

-k