distal-attribute
distal-attribute
distal-attribute
distal-attribute

Accidentally removed root user privileges

volejc posted 3 months ago in General

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 posted 3 months ago

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.