Hello Everybody,

I really need help with installing a mysql database on one of my servers.

I uploaded the pkg file to the server through my Cobalt Raq 4i server.

Then, I set up the user the way the instructions on pkg.nl.cobalt.com said for me to do. The problem is, one of my clients is trying to log into the mysql account via a php script over the web, and he gets this error:

Warning: Access denied for user: 'w3dsn@server2.rnwebdesignandhosting.com' (Using password: YES) in /home/sites/site9/web/easysql.php on line 169

Can someone tell me what I must do to give this person the access to get into his mysql account?

Thank you all very much!

Jim

Usually it's "user@localhost" when you're trying to log into the local machine. But I guess it all depends on how you have setup the permissions.

Here are 2 links that could give you more info about this:

http://www.devshed.com/Server_Side/MySQL/Grant_Tables/
http://www.devshed.com/Server_Side/MySQL/Administration/

Goodluck.

try changing the host from localhost to 127.0.0.1. It worked for me.

Juan, localhost is 127.0.0.1

yeah ? I know, but..... it solved a lot of problems with one of my servers...

Thanks for all your help.

Does anyone know the actual line of commands that you have to put into the Telnet Prompt?

Jim

To do what?

The script can be found here: www.w3dsn.com/easysql.php

The script needs to connect to the database.

We receive this error message when we use the

Warning: Access denied for user: 'w3dsn@server2.rnwebdesignandhosting.com' (Using password: YES) in /home/sites/site9/web/easysql.php on line 169


The log in information is:

username: w3dsn
password: mysql

You can see that the problem occurs when the user tries to enter into the mysql database.

Does anyone know how to fix this?

Jim

Make sure your grant is correct:

mysql> GRANT ALL ON [database] TO w3dsn@localhost IDENTIFIED BY '[password]';

if you didn't identify the user as w3dsn@localhost and just as w3dsn it won't work.;)

if you need more help drop me a mail...

One last thing, don't use anything other than "@localhost", big security hole. If you use @yourdomain.com your allowing anyone the ability to access that database from anyserver, or any local machine if they were to find out or were given the user id and or password.