I did the reload, but with no effect... On Sat, 3 Mar 2007 09:17:36 +0700, bedul wrote > ----- Original Message ----- > From: "Micah Stevens" <micah@xxxxxxxxxxxxxxxxxx> > To: "Roberto F Tavares Neto" <tavares@xxxxxxxxxxxxx> > Cc: <php-db@xxxxxxxxxxxxx> > Sent: Saturday, March 03, 2007 3:17 AM > Subject: Re: 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.. > or perhaps need some times to realy reload?? > > Roberto F Tavares Neto wrote: > > > Micah: > > > > > > I did create the database. Then, I use the: > > > > > > GRANT ALL PRIVILEGES ON db.* TO user@localhost 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... > > > > > > Roberto > > > > > > Micah Stevens escreveu: > > >> 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 Tavares Neto wrote: > > >>> Hello, > > >>> > > >>> I'm trying to do a very simple thing: create a database and a user > > >>> to use it. > > >>> > > >>> So, initially, I use the web interface phpmyadmin. Logged as root, I > > >>> created the database, and the user with some password. > > >>> > > >>> But, I could not login using phpmyadmin. Either any php-based system > > >>> could connect to the BD. > > >>> > > >>> So, I make sure that I got the "user@localhost" and "user@%" > > >>> created, with permissions and same password. Nothing. > > >>> > > >>> But I *can* log on mysql shell. > > >>> > > >>> One more info: when the user is set without password, it works fine > > >>> on PHP. > > >>> > > >>> > > >>> Does anyone can give me a clue of what is happening? > > >>> > > >>> Thanks! > > >>> > > >>> Roberto > > >>> > > >> > > > > > > > > > > > > ---------------------------------------------------------------------------- > ---- > > > -- > > 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 -- Roberto F Tavares Neto Prof. Assistente - Departamento de Engenharia de Produção Universidade Federal de São Carlos - UFSCAR -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
