A blog with the art of engineering!
$ mysql -u root -p Enter password: mysql> use mysql_database_name; mysql> GRANT ALL ON *.* to root IDENTIFIED BY 'your-root-password'; mysql> FLUSH PRIVILEGES;