Frequently Asked Question

Lost remote root access in Mysql / MariaDB? Get it back with....
Last Updated 4 years ago

Connect to the box hosing the mysql / mariadb via SSH or telnet then enter

mysql -u root

at the mysql> prompt enter

grant all privileges on *.* to 'root'@'remoteIP' with grant option;
and replace remoteIP with your workstation or % for everywhere (but don't use % please unless your on a LAN and nothing of any importace is in the database.

Then flush the changes with

flush privileges;
and your done.

Please Wait!

Please wait... it will take a second!