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

    Join Date
    Apr 2000
    Location
    Redmond, WA
    Posts
    218
    Rep Power
    15
    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!

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

    Join Date
    Jun 2000
    Posts
    43
    Rep Power
    15
    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:
    127.0.0.1 localhost

    Here are some URL if you care to read them I believe the MySQL manual will answer all your questions.
    http://src.doc.ic.ac.uk/packages/mys...ivilege_system

    http://src.doc.ic.ac.uk/packages/mys...Win32_vs._Unix
    http://src.doc.ic.ac.uk/packages/mys...#Win32_running

Similar Threads

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

IMN logo majestic logo threadwatch logo seochat tools logo