[Solved] Errorr: Access denied for the user root@localhost(using password: NO) in MariaDB and MySql

Hi SDSSDS,

Execute the below queries.

-- 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 this query you are changing the auth_plugin to mysql_native_password and setting the root password to root.

Now you will able to log in with root.

For more details refer MySQL or MariaDB.

If this will not help follow the steps in the below link.

https://www.educative.io/edpresso/access-denied-for-user-rootlocalhost-using-password-no