Maybe updating the package the Updater overwrote the root password.
To restore it:
Stop mysqld deamons.
$ sudo service mysqld stop
Go to Mysql/bin Directory
$ cd /usr/bin
Start a MySQL deamon with this option:
$ sudo mysqld_safe --skip-grant-tables
Open another terminal and open a MySQL session to execute this:
$ mysqlmysql> use mysql;see Note1 below for next line.mysql> UPDATE user SET authentication_string=PASSWORD(‘YOUR_NEW_PASSWORD_HERE‘) WHERE user = ‘root‘;mysql> exit;
Now kill the Mysqld_safe process and restart Mysqld normally:
$ sudo service mysqld start
Note1: password
is the column name in table mysql.user
prior to version 5.7. After which it became authentication_string
. Change your UPDATE statement accordingly.
How you can not understand, give me a message, I teach you.
Troubleshoot MySQL ERROR 1045 under Mac (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)