Ok, I know I'm stupid. I deleted all privileges to MySQL, I have access to root account on host. Is there any way to add account to mysql?
Asked
Active
Viewed 475 times
1 Answers
1
First of all stop mysql & backup /var/lib/mysql or wherever the data files are on your system.
Then from a clean mysql install elsewhere tar up /var/lib/mysql/mysql and put it on the broken system.
Then re-add your users & permissions.
Of course if you have backed up the mysql database you can do this more quickly.
![](../../users/profiles/22000.webp)
jamespo
- 1,698
- 12
- 12