View Single Post
  #2 (permalink)  
Old 09-18-2008, 06:32 AM
david_g17 david_g17 is offline
Registered User
 
Join Date: Sep 2008
Posts: 1
Code:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/jaygewxz/public_html/includes/DbConnector.php on line 26
This error means that you are trying to connect to MySQL with a user name of "nobody" and without a password.

In order to successfully do that, you'll need to create a user with access privileges to the database you wish to connect to.

For instance, if I wanted user "nobody" to connect to a database named "my_database", and I wanted this user to be able to select, update, delete, etc. I would execute the following MySQL command
Code:
GRANT ALL ON my_database.* to 'nobody'@'localhost' ;
at the MySQL prompt (you can probably do this through a graphical user interface if your host is using PHPMyAdmin or something similar).

If I wanted the user to use the password "s3cr3t", I would issue the following command:
Code:
GRANT ALL ON my_database.* to 'nobody'@'localhost'  identified by 's3cr3t';
More details can be found here:

http://dev.mysql.com/doc/refman/5.0/en/adding-users.
Reply With Quote