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: 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
