Re: MySQL Connection

This is message (not generated by or associated with PHP at all) that is telling you that your users (probably supposed to be root) doesn't have the right to perform the action you're trying to do. If you're trying to administer MySQL from the console try typing this: mysql --user=root mysql This will start the mysql admin program for the root user (which shouldn't have a password yet) and select the mysql database. The mysql database contains all of your user information. You should then be able to perform your grants. Check out http://www.mysql.com/doc/en/Adding_users.html for more information on adding new users to MySQL. HTH, Anthony Saffer, Founder & Owner www.safferconsulting.com Authorized MySQL Partner! P: (918) 542-8251 E: anthony@safferconsulting.com ICQ: 96698595 Yahoo: scs_anthonysaffer ----- Original Message ----- From: moses.johnson@btopenworld.com To: php-windows@lists.php.net Cc: php-db@lists.php.net Sent: Tuesday, June 17, 2003 7:16 PM Subject: [PHP-WIN] MySQL Connection Hello, Would be grateful if someone couldkindly point me in the right direction. Whenever I try to connect to mysql server, I get these messsage back 1. mysql> GRANT ALL PRIVILEGES ON *.* TO moses@"%" IDENTIFIED BY "cludiana"; ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO) mysql> 2. mysql> GRANT ALL PRIVILEGES ON *.* TO moses@"%" IDENTIFIED BY "cludiana"; ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO) mysql> what could be wrong. Help please . Regards Moses -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php