Answer the question
In order to leave comments, you need to log in
How to restore root permissions in mysql 8?
Good afternoon, don't scold me, but I can't figure out how to restore the root user rights in mysql 8 installed via openserver?
I accidentally reset the rights of all privelegies, or rather, I was looking for a password change in phpmyadmin and going to the "edit privileges" item I clicked on, and for some reason the system unchecked the all privelegies item by default and trouble happened!
I started reading the forums, but they did not help in any way, the solutions are mainly for versions 5.5, 5.6.
For example, go to the mysql folder and find the my.ini file there, enter the skip-grant-tables line, etc. But this does not help. I can't even stop the service and start it with the --skip-grant-tables key.
Can anyone come across? Help plz, the work is worth ((
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question