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

PHP GD library is NOT installed on your web server ubuntu – Linux mint19

GD module for PHP7 .1, .2 and .3 php7.2-gd php7.3-gd Above a deep dive to …

Leave a Reply

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

Powered by keepvid themefull earn money