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
> -----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
> tried setting up the user with both those domains inside both
> mysql.db. I have used [EMAIL PROTECTED] or [EMAIL PROTECTED] both with
> I can still connect on the command line but not using mysql connect, I
> the following error:
> Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
> 3rdpage.php on line 123
> I'm at a loss...
> 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
> >> error that I cannot connect. I created a user that has access to
> >> databse called 'menu'. The user has SELECT, UPDATE, and DELETE
> >> for that database.
> >> I can connect on the command line: mysql-u newuser -p. But no luck
> >> 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