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 "user@host" part should match what you're getting in the error message. So if you granted permission for user@localhost, then it's not going to work. It must be user@****.com 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: Info@Best-IT [mailto:info@best-it.biz] > Sent: Saturday, April 05, 2003 10:55 PM > To: Jim Lucas; php-db@lists.php.net > 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 root@localhost or root@mysite.com 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: '****@****.com' (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 phplist@zonedzero.net wrote: > > > did you reload mysql so it will have the new user? > > > > Jim > > ----- Original Message ----- > > From: "Info@Best-IT" <info@best-it.biz> > > To: "php mailing list list" <php-general@lists.php.net> > > 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