authenication help on local win32 box - DevShed Discussion Forums

★ wanayoo — archive 1999 http://www.devshed.com/Talk/Forums/Forum4/HTML/000650.html

Nouvelle recherche | Portail wanayoo

DevShed Menu

* DevShed Home

* Developer News

* DevShed Brain Dump

UBBFriend: Email This Page to Someone!

DevShed Discussion Forums

MySQL

authenication help on local win32 box

profile | register | preferences | faq | search

next newest topic | next oldest topic

Author

Topic: authenication help on local win32 box

sano
Member

posted June 30, 2000 06:48 PM

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

lhallusa
Member

posted June 30, 2000 11:41 PM

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 `\windows\hosts' 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/mysql/Manual_chapter/manual_Privilege_system.html#Privilege_system

http://src.doc.ic.ac.uk/packages/mysql/Manual_chapter/manual_Installing.html#Win32_vs._Unix
http://src.doc.ic.ac.uk/packages/mysql/Manual_chapter/manual_Installing.html#Win32_running

All times are MST (US)	next newest topic \| next oldest topic
Administrative Options: Close Topic \| Archive/Move \| Delete Topic
	Hop to:

Contact Us | DevShed.com