Re: [PHP-DB] Mysql autentication problem

2007-03-03 Thread Roberto Tavares
, bedul wrote: - Original Message - From: Micah Stevens [EMAIL PROTECTED] To: Roberto F Tavares Neto [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Saturday, March 03, 2007 3:17 AM Subject: Re: [PHP-DB] Mysql autentication problem Strange. If you look at the users table

Re: [PHP-DB] Mysql autentication problem

2007-03-03 Thread Roberto Tavares
I did the reload, but with no effect... On Sat, 3 Mar 2007 09:17:36 +0700, bedul wrote - Original Message - From: Micah Stevens [EMAIL PROTECTED] To: Roberto F Tavares Neto [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Saturday, March 03, 2007 3:17 AM Subject: Re: [PHP-DB] Mysql

Re: [PHP-DB] Mysql autentication problem

2007-03-03 Thread Micah Stevens
*Subject:* Re: [PHP-DB] Mysql autentication problem Reloading the grant tables should happen almost immediately unless you have an extremely large set of users, very little memory, or a very slow computer. On 03/02/2007 06:17 PM, bedul wrote: - Original Message

Re: [PHP-DB] Mysql autentication problem

2007-03-02 Thread Ted Fines
Hi, So it works from PHP w/o a password, but with a password does not? What are you using for a password? I don't mean post it here, but are there any 'funny' characters in it? I've had trouble because of that before, on other systems. Try a dumb, obviously OK password, like 'apples' and see

Re: [PHP-DB] Mysql autentication problem

2007-03-02 Thread Roberto F Tavares Neto
Ted, I try the classic abc and had the same problem... Roberto Ted Fines escreveu: Hi, So it works from PHP w/o a password, but with a password does not? What are you using for a password? I don't mean post it here, but are there any 'funny' characters in it? I've had trouble because of

Re: [PHP-DB] Mysql autentication problem

2007-03-02 Thread Ted Fines
Hi, When you're connecting from your PHP script, are you connecting from the same machine that the db is on, or a different one? If a different one, you'll need to do grant commands like: grant all privileges on mydbname.* to 'mydbuser'@'myhostname.mycompany.net' identified by 'mypassword';

RE: [PHP-DB] Mysql autentication problem

2007-03-02 Thread Bastien Koert
have you tried to 'flush privileges' to get the server to recognize the user account. Another option might be to open the mysqld from the command line and use the GRANT statement to create user without the gui. bastien From: Roberto F Tavares Neto [EMAIL PROTECTED] To: php-db@lists.php.net

Re: [PHP-DB] Mysql autentication problem

2007-03-02 Thread Roberto F Tavares Neto
I tried both already. It does not work. Roberto Bastien Koert escreveu: have you tried to 'flush privileges' to get the server to recognize the user account. Another option might be to open the mysqld from the command line and use the GRANT statement to create user without the gui. bastien

Re: [PHP-DB] Mysql autentication problem

2007-03-02 Thread Roberto F Tavares Neto
Ted, The [EMAIL PROTECTED] does the same effect as 'mydbuser'@'myhostname.mycompany.net' , right? Btw, for web apps, I got another user, @localhost only. This user is working... I thought it was a problem on the GUI, so I tried a [EMAIL PROTECTED] from mysql command line. It fails too...

Re: [PHP-DB] Mysql autentication problem

2007-03-02 Thread Micah Stevens
Did you give the user permissions to use the database in question? Here's my sequence of actions: . 1) Create DB if it doesn't exist 2) Create the user w/password 3) Give the user permission to use the database. 4) Flush privileges to update the server. 5) login and enjoy. -Micah Roberto F

Re: [PHP-DB] Mysql autentication problem

2007-03-02 Thread Roberto F Tavares Neto
Micah: I did create the database. Then, I use the: GRANT ALL PRIVILEGES ON db.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' to do the 2 and 3 steps. FLUSH PRIVILEGES to do the step 4. But the step 5 really does not work... only on the shell or when I remove the password from the user...

Re: [PHP-DB] Mysql autentication problem

2007-03-02 Thread Micah Stevens
Strange. If you look at the users table, is there a password hash in the password field? Roberto F Tavares Neto wrote: Micah: I did create the database. Then, I use the: GRANT ALL PRIVILEGES ON db.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' to do the 2 and 3 steps. FLUSH PRIVILEGES to

Re: [PHP-DB] Mysql autentication problem

2007-03-02 Thread bedul
- Original Message - From: Micah Stevens [EMAIL PROTECTED] To: Roberto F Tavares Neto [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Saturday, March 03, 2007 3:17 AM Subject: Re: [PHP-DB] Mysql autentication problem Strange. If you look at the users table, is there a password hash

Re: [PHP-DB] Mysql autentication problem

2007-03-02 Thread Micah Stevens
PROTECTED] Cc: php-db@lists.php.net Sent: Saturday, March 03, 2007 3:17 AM Subject: Re: [PHP-DB] Mysql autentication problem Strange. If you look at the users table, is there a password hash in the password field? i think this must be reload?? not just flush?? it happen to me

Re: [PHP-DB] Mysql autentication problem

2007-03-02 Thread bedul
Subject: Re: [PHP-DB] Mysql autentication problem Reloading the grant tables should happen almost immediately unless you have an extremely large set of users, very little memory, or a very slow computer. On 03/02/2007 06:17 PM, bedul wrote: - Original Message - From: Micah Stevens