1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Redmond, WA
    Rep Power
    I'm having trouble with my mySQL server on my local computer --

    Whenever I type mysql -h localhost -u sano -p
    and it asks for the password, and I type it in, it returns with:

    error 1045: Access denied for user: 'sano@localhost' (Using password: YES)

    My questions:

    1. Why does this happen?
    2. How can I tell if I ever set a password for this account (I can also access by just using -h and -u without the -p flag)
    3. What's the command to change my password?
    4. How do I add additional usernames?

    Thanks in advance!

  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Rep Power
    Access denied for user error
    If you get the error Access denied for user: 'some-user@unknown' to database 'mysql' when accessing a MySQL server on the same machine, this means that MySQL can't resolve your host name properly. To fix this, you should create a file `windowshosts' with the following information: localhost

    Here are some URL if you care to read them I believe the MySQL manual will answer all your questions.


Similar Threads

  1. Win32 API: Using comboboxes, CB_ADDSTRING message.
    By peenie in forum C Programming
    Replies: 16
    Last Post: June 30th, 2008, 11:28 AM
  2. Access: list box/combo box "After Update" problems
    By hlove in forum Database Management
    Replies: 2
    Last Post: January 2nd, 2004, 01:22 AM
  3. changing the buttons in the message box
    By crackerweb in forum Visual Basic Programming
    Replies: 6
    Last Post: October 23rd, 2003, 06:36 PM
  4. multiple drop box messages
    By pink_koala in forum HTML Programming
    Replies: 2
    Last Post: August 23rd, 2003, 09:24 PM
  5. Mysterious box pops up at each Start Up
    By zubzub in forum Beginner Programming
    Replies: 1
    Last Post: August 14th, 2003, 05:17 AM

IMN logo majestic logo threadwatch logo seochat tools logo