Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: dswillia on April 16, 2001, 04:51:12 AM

Title: Mysql Problems
Post by: dswillia on April 16, 2001, 04:51:12 AM

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

Title: Re: Mysql Problems
Post by: greg martin on April 16, 2001, 05:08:09 AM

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!

Title: Re: Mysql Problems
Post by: Dan Brown on April 16, 2001, 05:10:01 AM

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.