Re: Mysql autentication problem

In mysql 4.1, they changed the hash format of the passwords. If you stored the password from a 3.x client, and area accessing with a 4.x or 5.x client, or the other way around, you might have similar problems. Your command line client is likely the same version as the server, so I'm guessing that your php might be older. However, this situation is usually accompanied by a specific error message referencing the client version. Do you have that? -Micah On 03/02/2007 11:35 PM, bedul wrote:

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 <mailto:micah@raincross-tech.com>
    *To:* bedul <mailto:landavia81@gmail.com>
    *Cc:* php-db@lists.php.net <mailto: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" <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