Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    1

    Unanswered: Connecting to MySQL 4.1.1

    I've just upgraded to mysql 4.1.1. I am having problems connecting to the database whenever I use a user with a password. I've tried setting the password with the password function and the old_password function, and neither works for me. I get the same error from both the mysql client, and when trying to connect with the JDBC drivers. The error message I recieve is:
    ERROR 1045 (28000): Access denied for user: 'artsys'@'localhost' (Using password: YES)

    When I remove the password with the same user, I have no problems with the MySQL client, but I still have the same problem with the JDBC drivers. Anyone had a similar problem?

    Scott

  2. #2
    Join Date
    Sep 2003
    Location
    London
    Posts
    56
    Did you install/start mysql using --old-passwords, or just use the oldpassword() function when hashing the passwords?

  3. #3
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    Did you add your user with % as host ?
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  4. #4
    Join Date
    Jan 2004
    Posts
    1

    I get it.

    first add new user "with grant option"
    then use the instruction "flush prilvileges"
    or you will get the "ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using password:NO)"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •