Password recovery
Posted by: Luis Melgarejo
Date: May 14, 2014 06:03AM

Hi there,

I try to change the password to access my MySQL using the following command:

UPDATE mysql.user SET password = PASSWORD <"root"> WHERE user = "root";

and I get the following error:

Error 1064 <42000>: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where user = "root"' at line 1

I can not create a new database because it asks for a username and password and do not remember to have indicated at the installation. Any help?

Options: ReplyQuote


Subject
Views
Written By
Posted
Password recovery
2277
May 14, 2014 06:03AM
1029
May 14, 2014 02:14PM
1385
May 16, 2014 06:31AM
1230
May 27, 2014 03:45AM
1027
May 24, 2014 12:59AM
984
May 27, 2014 03:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.