MariaDB root password error


You just installed MySQL or MariaDB and you receive this error: Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges. How to solve it? In many websites there are a lot of different approaches and solutions, often with 5 or more steps to do.

A working solution for old systems is to execute ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

if you get: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'BY 'password'' at line 1 ... then your version of MariaDB is not compatible with this solution.

In this case is better to use

sudo mysql 
 
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password USING PASSWORD('password');` this should correctly reset your password. 


marco.dev newsletter

Be the coolest developer in your team joining our community!
WebApp built by Marco using SpringBoot, Java 16, Mustache, Markdown and Hosted using Jelastic