codedeep79/Access denied for user 'root'@'localhost'.md

Created August 24, 2022 08:59

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/codedeep79/fb7141f65dfd02ff851b0a39e8caff39.js"></script>
Save codedeep79/fb7141f65dfd02ff851b0a39e8caff39 to your computer and use it in GitHub Desktop.

Download ZIP

ERROR 1698 (28000): Access denied for user 'root'@'localhost'

Raw

Access denied for user 'root'@'localhost'.md

When i try access MySQL: mysql -u root -p -h 127.0.0.1 -P 3306, then i get error:ERROR 1698 (28000): Access denied for user 'root'@'localhost'

Solution:

sudo mysql -u root # I had to use "sudo" since it was a new installation

mysql> USE mysql;
mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit;

sudo service mysql restart

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment