S
S
survivor20052021-07-30 08:38:20
MySQL
survivor2005, 2021-07-30 08:38:20

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

1 answer(s)
V
Vladimir Korotenko, 2021-07-30
@survivor2005

https://stackoverflow.com/questions/50691977/how-t...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question