MySQL Error: : ‘Access denied for user ‘root’@’localhost’

by

All solutions I found were much more complex than necessary and none worked for me. Here is the solution that solved my problem. There isn’t any need to restart mysqld or start it with special privileges.

sudo mysql

-- for MySQL
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';

-- for MariaDB
ALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('root');

With a single query we are changing the auth_plugin to mysql_native_password and setting the root password to root (feel free to change it in the query).

Now you should be able to log in with root. More information can be found in MySQL documentation or MariaDB documentation.

(Exit the MySQL console with Ctrl + D or by typing exit.)

More Related Contents:

  1. Error Code: 2013. Lost connection to MySQL server during query
  2. MySQL Trigger after update only if row has changed
  3. difference between primary key and unique key
  4. Error creating table: You have an error in your SQL syntax near ‘order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ‘ at line 1 [duplicate]
  5. MySQL Query to select data from last week?
  6. Using an Alias in SQL Calculations
  7. Can a table field contain a hyphen?
  8. Adding a leading zero to some values in column in MySQL
  9. How do I add a custom CHECK constraint on a MySQL table?
  10. View’s SELECT contains a subquery in the FROM clause
  11. How to insert data to MySQL with auto-incremented column(field)?
  12. How to change the default port of mysql from 3306 to 3360
  13. Case statement in MySQL
  14. Replace Into Query Syntax
  15. Remote connect to clearDB heroku database
  16. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  17. Laravel join with 3 Tables
  18. Difference between two table structure
  19. MySQL query, MAX() + GROUP BY
  20. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  21. How to insert a file in MySQL database?
  22. How to get multiple records against one record based on relation?
  23. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  24. Foreign key constraints: When to use ON UPDATE and ON DELETE
  25. How to use a user variables in MySQL LIKE clause?
  26. How to speed up sql queries ? Indexes?
  27. Selecting distinct 2 columns combination in mysql
  28. How to store a one to many relation in MySQL database?
  29. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;
  30. MySQL: Computed Column

Leave a Comment