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

4 posts / 0 new
Topic locked
Last post
#1 Sat, 12/14/2013 - 10:51
JamesSimpson

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?

Sat, 12/14/2013 - 11:19
JamesSimpson

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

Sat, 12/14/2013 - 11:28
JamesSimpson

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

Sat, 12/14/2013 - 23:53
andreychek

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

Topic locked