|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
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/my...rivilege_system http://src.doc.ic.ac.uk/packages/my...#Win32_vs._Unix http://src.doc.ic.ac.uk/packages/my...l#Win32_running |
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > authenication help on local win32 box |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|