Restore the lost root user permissions of Mysql

Restore the lost root user permissions of Mysql when a program is installed today, because the program is silly, new root @ localhost user is created and all root permissions are changed to no. This is also silly. all programs on the server have crashed. in this case, you can use the root user to log in and cannot modify the permissions. hurry up, service mysqld stop, stop mysql, and start mysql/usr/bin/mysqld_safe -- skip-grant-tables root login in safe mode .. you do not need to enter the mysql database with a password (note that the database name is mysql). just remove the root @ localhost of the user table or change the permissions to yes. then restart mysql to restore the Service Permissions...