Frequently Asked Question

Lost remote root access in Mysql / MariaDB? Get it back with....
Last Updated 7 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.
This website relies on temporary cookies to function, but no personal data is ever stored in the cookies.
OK
Powered by GEN UK CLEAN GREEN ENERGY

Loading ...