MySQL Forums
Forum List  »  Newbie

Re: MySQL on Mac
Posted by: jinu mm
Date: January 20, 2016 01:16AM

hI Dear , i face this same problem last month of creating my web development company website creation but somebedy help me out and send below added codes to me , its worked , you can try this out " Try the command FLUSH PRIVILEGES when you log into the MySQL terminal. If that doesn't work, try the following set of commands while in the MySQL terminal

$ mysql -u root
mysql> USE mysql;
mysql> UPDATE user SET password=PASSWORD("NEWPASSWORD") WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
Change out NEWPASSWORD with whatever password you want. Should be all set!

Update: As of MySQL 5.7, the password field has been renamed authentication_string. When changing the password, use the following query to change the password. All other commands remain the same:

mysql> UPDATE user SET authentication_string=PASSWORD("NEWPASSWORD") WHERE User='root';

web development more info

Options: ReplyQuote


Subject
Written By
Posted
January 10, 2016 03:27AM
January 10, 2016 12:02PM
January 10, 2016 12:41PM
January 10, 2016 06:48PM
Re: MySQL on Mac
January 20, 2016 01:16AM


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.