mysql root账号权限自己作没了咋办

1、使用客户端登录

mysql库

更新的MYSQL.USER表的所有字段中为N的为Y就可以了。

update user set Select_priv ='Y' where user = 'root';

update user set Insert_priv ='Y' where user = 'root';

update user set Update_priv ='Y' where user = 'root';

update user set Delete_priv ='Y' where user = 'root';

update user set Create_priv ='Y' where user = 'root';

update user set Drop_priv ='Y' where user = 'root';

update user set Reload_priv ='Y' where user = 'root';

update user set Shutdown_priv ='Y' where user = 'root';

update user set Process_priv ='Y' where user = 'root';

update user set File_priv ='Y' where user = 'root';

update user set Grant_priv ='Y' where user = 'root';

update user set References_priv ='Y' where user = 'root';

update user set Index_priv ='Y' where user = 'root';

update user set Alter_priv ='Y' where user = 'root';

update user set Show_db_priv ='Y' where user = 'root';

update user set Super_priv ='Y' where user = 'root';

update user set Create_tmp_table_priv ='Y' where user = 'root';

update user set Lock_tables_priv ='Y' where user = 'root';

update user set Execute_priv ='Y' where user = 'root';

update user set Repl_slave_priv ='Y' where user = 'root';

update user set Repl_client_priv ='Y' where user = 'root';

update user set Create_view_priv ='Y' where user = 'root';

update user set Show_view_priv ='Y' where user = 'root';

update user set Create_routine_priv ='Y' where user = 'root';

update user set Alter_routine_priv ='Y' where user = 'root';

update user set Create_user_priv ='Y' where user = 'root';

update user set Event_priv ='Y' where user = 'root';

update user set Trigger_priv ='Y' where user = 'root';

2、# 查看账户权限
show grants; --自己
show grants for dba@localhost； --指定用户指定host
# 查看可用账户
use mysql;
select user,host,password from user;
# 生成用户，并给用户授权
grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option; --授予所有权限给root@%账户，密码为password，并且有给其他用户授权的权限
flush privileges;--生效
# 删除用户
delete from mysql.user where user='' and host='';
# 更新用户密码
update mysql.user set password=PASSWORD('111111') where user='root';