MySQL: Solve Access Denied for User Root Error – set password to NUL – Jamie McCleave – Shopify Developer

MySQL: Solve Access Denied for User Root Error – set password to NUL

Posted on December 11, 2020 by jamie

// Issue 
jamie:~/environment $ mysql -u root -p
Enter password: 
ERROR 1698 (28000): Access denied for user 'root'@'localhost'

//Fix 

$ sudo mysql

// MySQL

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '';

mysql> exit;

// Restart 

$ sudo service mysql restart 
//or
$ sudo service mysql stop
$ sudo service mysql start