Topic: Mysql Problems

[dswillia]

I am having some mysql problems and would like to see if any of you know what I am doing wrong.  I have tried to install PHP Nuke and Projekt (at seperate times), and I keep getting a reoccuring problem.  Whenever the software tries to access the mysql database I get the following errors:

MySQL Connection Failed: Host 'localhost.henryetta.net' is not allowed to connect to this MySQL server

Any ideas?

Regards,
dswillia

[greg martin]

try just putting  'localhost'
worked for me on my nuke install.

here is what I have in config.php on PHP nuke

$dbhost = "localhost";
$dbuname = "root";
$dbpass = "*******";   (of course this is your password)
$dbname = "nuke";
$system = 0;

good luck, nuke is great!

[Dan Brown]

Yep, I've got an idea--and I'm pretty sure it's right, too.  Make sure the database host is specified (in whatever config files are used by the respective applications) as simply "localhost".  If that's set correctly and you still see the error, you'll also need to make sure that MySQL expects that.  The simplest way to do this is to start mysql and type 'grant all on nuke.* to nuke@localhost identified by 'nukepassword';'  In this example, nuke.* identifies the database, and nuke@localhost is the user.