Re: Mysql autentication problem

I got 5 or 6 users... and a respectable computer... On Fri, 02 Mar 2007 22:48:52 -0800, Micah Stevens wrote > 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" <micah@raincross-tech.com> > > To: "Roberto F Tavares Neto" <tavares@dep.ufscar.br> > > 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.. > > 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 > >> > > > > -- Roberto F Tavares Neto Prof. Assistente - Departamento de Engenharia de Produção Universidade Federal de São Carlos - UFSCAR