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
