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

Create a New User and Grant Permissions in MySQL

To connect to any database with same account, open your connection to your server: 1- …

Leave a Reply

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

Powered by keepvid themefull earn money