now you mention it.
i hope the same problem will solve.

i use in windows (own pc)..not in real-life server.. thx for your repair on my 
missuderstanding
  ----- Original Message ----- 
  From: Micah Stevens 
  To: bedul 
  Cc: php-db@lists.php.net 
  Sent: Saturday, March 03, 2007 1:48 PM
  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" <[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 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 [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...

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 "[EMAIL PROTECTED]" and "[EMAIL PROTECTED]"
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
    

  

Reply via email to