Issues With Mysql Database

[natefischer]

I have created a database and trying to use a perl script on it via a phpshell and get the following error message

 

++ HLstats 1.20 starting...

 

-- Opening UDP listen socket on www.pulpdod.com:27500 ... opened OK

-- Connecting to MySQL database 'pulpdod_hlstats' on 'www.pulpdod.com:3306' as user 'pulpdod_aedri' ... DBI connect('pulpdod_hlstats:www.pulpdod.com:3306','pulpdod_aedri',...) failed: Access denied for user: 'pulpdod_aedri@server48.totalchoicehosting.com' (Using password: YES) at hlstats.pl line 971

 

Can't connect to MySQL database 'pulpdod_hlstats' on 'www.pulpdod.com:3306'

Server error: Access denied for user: 'pulpdod_aedri@server48.totalchoicehosting.com' (Using password: YES)

 

 

There is a user on that database, it does have a password, Im pulling out my hair help???

[steven]

Did you add localhost (or % for anyone) to the access list? This should only be neccessary if the web server accessing the database is off the server, however you might check to make sure "localhost" is there either way, and also, trouble shoot it by adding the percent sign (% , used by MySQL as a wildard)

 

You have to allow external web servers to access your MySQL databases by adding their domain name to the list of hosts that are able to access databases on your web site. localhost stands for your own web server.

 

To add host access:

 

Click on the MySQL databases button on the home page.

 

Enter the domain name or IP number of the host that you wish to add in the Host field.

 

Click on the Add Host button.

[natefischer]

Well your % worked, but instead of giving me the error, the Phpshell hangs.

 

If I cancel it out, then it opens the port, but I cant tell if it access the database or not. Grrr I hate php, hehe.

[steven]

Well beyond the basics with MySQL I'm not sure, you'll have to debug some to find the cause though...

[natefischer]

Thanks Steven