恢复mysql的root用户权限
发布日期:11-09-19 02:24 文章来源:互联网
方法一:
1。启动mysql服务:
2。
开始 - 运行 - cmd 到mysql的bin目录下,
登录数据库(mysql -u root),
找到数据库(use mysql;),
修改密码或者权限(update user set host='127.0.0.1' where host='172.30.193.102' and user='root';)(我是这个是把root用户的host给改错了,你如果是权限错误,就把root的权限都改为Y,
如:
update user set `Host`='localhost', `User`='root', `Password`=password('ghjx'), `Select_priv`='Y', `Insert_priv`='Y',
`Update_priv`='Y', `Delete_priv`='Y', `Create_priv`='Y', `Drop_priv`='Y', `Reload_priv`='Y', `Shutdown_priv`='Y',
`Process_priv`='Y', `File_priv`='Y', `Grant_priv`='Y', `References_priv`='Y', `Index_priv`='Y', `Alter_priv`='Y',
`Show_db_priv`='Y', `Super_priv`='Y', `Create_tmp_table_priv`='Y', `Lock_tables_priv`='Y', `Execute_priv`='Y',
`Repl_slave_priv`='Y', `Repl_client_priv`='Y', `Create_view_priv`='Y', `Show_view_priv`='Y', `Create_routine_priv`='Y',
`Alter_routine_priv`='Y', `Create_user_priv`='Y', `Event_priv`='Y', `Trigger_priv`='', `ssl_type`='', `ssl_cipher`='',
`x509_issuer`='', `x509_subject`='', `max_questions`=0, `max_updates`=0, `max_connections`=0, `max_user_connections`=0
where user = 'root' and `Host`='localhost';
update user set `Host`='127.0.0.1', `User`='root', `Password`=password('ghjx'), `Select_priv`='Y', `Insert_priv`='Y',
`Update_priv`='Y', `Delete_priv`='Y', `Create_priv`='Y', `Drop_priv`='Y', `Reload_priv`='Y', `Shutdown_priv`='Y',
`Process_priv`='Y', `File_priv`='Y', `Grant_priv`='Y', `References_priv`='Y', `Index_priv`='Y', `Alter_priv`='Y',
`Show_db_priv`='Y', `Super_priv`='Y', `Create_tmp_table_priv`='Y', `Lock_tables_priv`='Y', `Execute_priv`='Y',
`Repl_slave_priv`='Y', `Repl_client_priv`='Y', `Create_view_priv`='Y', `Show_view_priv`='Y', `Create_routine_priv`='Y',
`Alter_routine_priv`='Y', `Create_user_priv`='Y', `Event_priv`='Y', `Trigger_priv`='', `ssl_type`='', `ssl_cipher`='',
`x509_issuer`='', `x509_subject`='', `max_questions`=0, `max_updates`=0, `max_connections`=0, `max_user_connections`=0
where user = 'root' and `Host`='127.0.0.1';
);
3。D:\Tool\xampp\phpMyAdmin\config.inc.php(到里面修改数据库用户名和密码)
4。重启下数据库
方法二:
根据网上查来的修改:
目前来说只有两种:
1、跳过授权表启动MYSQL:
?? WINDOWS或者LINUX下都可以用
??? MYSQLD --SKIP-GRANT-TABLES
??? 来启动 MYSQL。??? 更新的MYSQL.USER表的所有字段中为N的为Y就可以了。
2、就是COPY 别的有权限的MYSQL 库考到你原来的目录:之后的操作和上面的一样。