SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Jul 2004
    Location
    israel
    Posts
    25
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    privelages problem in mysql

    just installed mysql. when i type MYSQL and get the command prompt im not allowed to do anything apart from get the status. it says : ERROR 1044: Access denied for user: '@localhost' to database 'database'.
    i know that the dwfault username/password is root/root, so i try to log on as MYSQL root -p, it prompts me for the password and when i enter root it replies:
    ERROR 1045: Access denied for user: 'ODBC@localhost' (Using password: YES)
    i've got a tutorial for mysql here but theres no mention of anything like it.

  2. #2
    Knowledge is key 2 progression Tryst's Avatar
    Join Date
    Sep 2003
    Location
    Wales
    Posts
    1,181
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    are you sure your password is set to 'root'??

    Try login into MySQL with the following command and see what happens...

    mysql -u root -proot

    Just having a second look at your error message,and it seems that MySQL is trying to log you in as ODBC (hence the ODBC@localhost part in your error message).

    Something is def not right here as you are (well, you say you are) specifying 'root' as your username, and yet MySQL is trying to log you in as ODBC???

    Tryst

  3. #3
    Non-Member
    Join Date
    Aug 2002
    Location
    USA
    Posts
    544
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You can restart mysql with the "skip-grant-tables" option if the password needs to be reset.


Bookmarks

Posting Permissions

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