Re: [cobalt-users] MySQL Trouble

["Steven Werby" <steven-lists@xxxxxxxxxxxx>]

Brian Price <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.

In the MySQL server, open the "mysql" database (location of the grant tables)
and make sure that the host in question is allowed to access that database.
Easiest way is to make sure the MySQL user for that script has a host that
matches your calling script's hostname in the "user" table.  You could always
add or change the host to "%" which opens it up to the world if you don't want
to put in specific hosts, but that could be a security problem.

And don't forget to type "flush privileges" after editing the grant tables to
put the changes into effect.

Steven Werby {steven-lists@xxxxxxxxxxxx}