Accidentally removed root user privileges

[expired user #11000]'s profile image [expired user #11000] posted 7 years ago in General Permalink

Hi all,

New to databases. I was working on a table in HeidiSQL and I accidentally removed all of the root user privileges. I was working from the root user and had not yet created another user account. Now I cannot access the table. Is there anyway that I can restore the root privileges?

Thanks in advance!

archfrog's profile image archfrog posted 7 years ago Permalink

For MySQL/MariaDB, I think this link will help you:

[StackOverflow](https://stackoverflow.com/questions/1709078/how-can-i-restore-the-mysql-root-user-s-full-privileges)

Please login to leave a reply, or register at first.