access denied mysql stop code example

Example 1: mysql failed to login as root@localhost

UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';
FLUSH PRIVILEGES;

Example 2: mysql root permission denied lost

GRANT ALL ON *.* TO 'user'@'localhost' with GRANT OPTION;