Sometimes I notice if I change the root password via Digital Ocean the password doesn’t get updated with mysql.
I’m in a weird situation right now and could use some help. Virtualmin is displaying no databases in the Webmin>Servers>MySQL area:
But, I know this server has other databases, users, etc and they’re running because those sites aren’t down.
The other weird thing is the settings don’t match my my.cnf file values:
I’m able to get into mysql without a password for root. Luckily the server isn’t open to the internet.
When I try SET PASSWORD FOR ‘root’@‘localhost’ = PASSWORD(‘my_password’) I get this error:
ERROR 1133 (42000): Can’t find any matching row in the user table
I really don’t know how to fix the issue here and would love any help you can give.