[PHP-DB] Re: [PHP] mysl_connect question
Thanks for you help! First I tried flush privileges and I have tried to reboot mysql. I am running into a problem if I use user @localhost or @mysite.com. I have tried setting up the user with both those domains inside both mysql.User and mysql.db. I have used [EMAIL PROTECTED] or [EMAIL PROTECTED] both with success. I can still connect on the command line but not using mysql connect, I get the following error: Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in 3rdpage.php on line 123 I'm at a loss... /T PS: sorry about the cross posting, it won't happen again... on 4/5/03 3:04 PM, Jim Lucas at [EMAIL PROTECTED] wrote: did you reload mysql so it will have the new user? Jim - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: php mailing list list [EMAIL PROTECTED] Sent: Saturday, April 05, 2003 10:40 AM Subject: [PHP] mysl_connect question When I use myssql to connect to a db with anything besides root I get an error that I cannot connect. I created a user that has access to one databse called 'menu'. The user has SELECT, UPDATE, and DELETE permissions for that database. I can connect on the command line: mysql-u newuser -p. But no luck using mysql_connect(). Anyone have this problem? .T -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: [PHP] mysl_connect question
The access denied message you are seeing is usually the result of either an incorrect password or username, but you don't give enough information to allow guessing beyond that. Are you certain your script is submitting the expected values? Doug On Sat, 05 Apr 2003 21:54:33 -0600, [EMAIL PROTECTED] wrote: Thanks for you help! First I tried flush privileges and I have tried to reboot mysql. I am running into a problem if I use user @localhost or @mysite.com. I have tried setting up the user with both those domains inside both mysql.User and mysql.db. I have used [EMAIL PROTECTED] or [EMAIL PROTECTED] both with success. I can still connect on the command line but not using mysql connect, I get the following error: Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in 3rdpage.php on line 123 I'm at a loss... /T PS: sorry about the cross posting, it won't happen again... on 4/5/03 3:04 PM, Jim Lucas at [EMAIL PROTECTED] wrote: did you reload mysql so it will have the new user? Jim - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: php mailing list list [EMAIL PROTECTED] Sent: Saturday, April 05, 2003 10:40 AM Subject: [PHP] mysl_connect question When I use myssql to connect to a db with anything besides root I get an error that I cannot connect. I created a user that has access to one databse called 'menu'. The user has SELECT, UPDATE, and DELETE permissions for that database. I can connect on the command line: mysql-u newuser -p. But no luck using mysql_connect(). Anyone have this problem? .T -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: [PHP] mysl_connect question
This is getting way off topic for the PHP list... What was the GRANT command you used to create this new user? When you issue the command the [EMAIL PROTECTED] part should match what you're getting in the error message. So if you granted permission for [EMAIL PROTECTED], then it's not going to work. It must be [EMAIL PROTECTED] or whatever your error message is saying. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, April 05, 2003 10:55 PM To: Jim Lucas; [EMAIL PROTECTED] Subject: [PHP-DB] Re: [PHP] mysl_connect question Thanks for you help! First I tried flush privileges and I have tried to reboot mysql. I am running into a problem if I use user @localhost or @mysite.com. I have tried setting up the user with both those domains inside both mysql.User and mysql.db. I have used [EMAIL PROTECTED] or [EMAIL PROTECTED] both with success. I can still connect on the command line but not using mysql connect, I get the following error: Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in 3rdpage.php on line 123 I'm at a loss... /T PS: sorry about the cross posting, it won't happen again... on 4/5/03 3:04 PM, Jim Lucas at [EMAIL PROTECTED] wrote: did you reload mysql so it will have the new user? Jim - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: php mailing list list [EMAIL PROTECTED] Sent: Saturday, April 05, 2003 10:40 AM Subject: [PHP] mysl_connect question When I use myssql to connect to a db with anything besides root I get an error that I cannot connect. I created a user that has access to one databse called 'menu'. The user has SELECT, UPDATE, and DELETE permissions for that database. I can connect on the command line: mysql-u newuser -p. But no luck using mysql_connect(). Anyone have this problem? .T -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php