ike,
Well, there are quite a few wierdnessess that I have experienced. One, for
instance, is if you are working in the GUI editor interface, and are mucking
around with the User priveleges.... I have actually had the GUI
wipe the passwords to null for all rows. I'm sure its just because I'm not
aware of the assumptions being made by the Control Center. Something like,
"I will change everything with the prefix XYZ" when you press this button.
Anyway, I probably created a new user for a specific database or something
for my standard user login (but for a different machine host maybe) ( I use
explicit definitions for all hosts.) And forgot to put in the password and
that updated ALL the passwords for that login in the User table...on ALL
hosts?... which rapidly halted all working applications.
So I suggest logging into you mySQL server as root, and look at the user
table and the user privileges, use a specific SQL request, otherwise you'll
get an unreadable table in the Command Prompt viewer.
(Don't forget to set the database to the master mysql database.)
"Select Host, User, Password from User"
( The conclusion is that I believe you have all the passwords for your given
login will be "")
Use the Update User set Password = PASSWORD("mypasshere") where User =
"someone";
Don't forget to FLUSH PRIVILEGES; when you're done mucking around, or none
of you changes will take effect and you will quietly go crazy and or bald.
Does Paul.D. actually HAVE hair? Has anyone met him in person to verify the
existance of strands. lol- ;)
_TheMechE
-----Original Message-----
From: ike strong [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 22, 2003 12:16 PM
To: [EMAIL PROTECTED]
Subject: Error 1045: Acess denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
Can anyone help me to figure out why suddenly I
cant gain access into MySQL database with my password,
which I assigned myself and which was working fine
until yesterday when access was suddenly denied to me
with the following meassage:
Error 1045: Acess denied for user: '[EMAIL PROTECTED]'
(Using password: YES)
This is perhaps an old story here but very well new to
me.
Has anyone tackled or know what is causing this
problem? I'd appreciate some help with this one.
Thanks in advance
Ike
__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
