Comments - Error logging in

6 years, 8 months ago kanika satija

It seems that you have forgotten root password which was set during installation of MariaDB

Solution:- reset root password

Follow below steps to reset root password:- 1) Stop mariadb services service mysql stop

2) Run mysqld safe version by below command sudo mysqld_safe --skip-grant-tables &

3) Run mysql client with below commnad on new terminal mysql -u root

4) Set password in user table of mysql database use mysql; update user SET PASSWORD=PASSWORD("<new_password>") WHERE USER='root'; flush privileges; exit

5) Login with new password, set in above command mysql -u root -p Enter password: <new_password>

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.