mysql 5.7 access denied for user ‘root’@’localhost’

$ killall -9 mysqld $ sudo mysqld_safe –skip-grant-tables & $ mysql -u root mysql> use mysql; mysql> select user,host from user where user=’root’; mysql> update user set plugin = ‘mysql_native_password’ where user=’root’; mysql> update user set authentication_string = password(‘<newPassword>) where user=’root’; mysql> flush privileges; mysql> exit $ killall mysqld $ sudo service mysql start $…

Read More