View Full Version : MySQL help!
May 9th, 2007, 07:44 AM
I was trying to change my root password for my MySQL account, i ssued the command : 'update user set password='xxx' where user='me'; but i think i should have used 'set password=PASSWORD('xxx')'. So.....I now cannot access MySQL at all !!!!! pls help, is there a way to get my account back, or am I stuck with a reinstall, nooooooo :(
May 9th, 2007, 12:59 PM
Does the old or new password work?
What happens if you add the same quotes you used to make the password?
Can you log in as a different user?
May 9th, 2007, 02:46 PM
this might work:
Also, you might look at the GRANT syntax for updating/adding user roles. It's a bit easier to use than direct manipulation of the tables ...
May 9th, 2007, 03:04 PM
Yes, excellent stuff....(or in Irish: get up da yard ye good thing) :)
Powered by vBulletin® Version 4.2.2 Copyright © 2014 vBulletin Solutions, Inc. All rights reserved.