Home / Technology / IT / Linux / How to use root account to manage mysql databases

How to use root account to manage mysql databases

After installing mysql, you need to create an account to manage your databases as descried in this link. But if you do need to keep root as your databases manager!

Lets do the below steps:

sudo mysql -u root

USE mysql;

UPDATE user SET plugin='mysql_native_password' WHERE User='root';

FLUSH PRIVILEGES;

exit;

After this you can login to your mysql databases and manage them using the root account and phpmyadmin too.

About Kalaweeza

Check Also

How to Install Webmin 1.900 on Ubuntu and Linux Mint

If you face some bug related issues with the version 1.900, all you need her …

Leave a Reply

Your email address will not be published. Required fields are marked *

Powered by keepvid themefull earn money