Root - MSQL :: Access denied for user 'root'@'localhost'

Hi All,

Well I went and messed some things up last night when modifying database privileges, and I managed to delete the Root privilege from MYSQL.

So when I go into Virtualmin I cannot see any of the databases (as I’m logged in as a Root user) and now when I try and connect with root to the MYSQL server I cannot get access.

How can I reset my privileges of the root user back to what they are supposed to be?

Just remembered I created another user with full privileges, so I can login using that (thank god)

Managed to get myself back up and running - no need to reply.

We’re glad to hear you were able to get it working!