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 --init-file
option.
Is there any other way to reset the host for the root user?