While trying to get remote MySQL working, I somehow managed to lock myself out with the root account.
Normally, I would stop the MySQL service and restart it using
/etc/init.d/mysql --init-file, but when I try to do that, it says the script has been converted to an upstart job and to use the "service mysql" command. Unfortunately, as far as I know, the
service command doesn't support the
Is there any other way to reset the host for the root user?