mysql数据库root权限丢失(密码丢失)
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了mysql数据库root权限丢失(密码丢失),小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3397字,纯文字阅读大概需要5分钟。
内容图文
![mysql数据库root权限丢失(密码丢失)](/upload/InfoBanner/zyjiaocheng/481/678fed76eca749489d708a268e549148.jpg)
mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | oldboy_gbk | | performance_schema | | qiuyuetao | | test | +--------------------+ 6 rows in set (0.00 sec) mysql> show tables; +---------------------------+ | Tables_in_mysql | +---------------------------+ | columns_priv | | db | | event | | func | | general_log | | help_category | | help_keyword | | help_relation | | help_topic | | host | | ndb_binlog_index | | plugin | | proc | | procs_priv | | proxies_priv | | servers | | slow_log | | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name | | time_zone_transition | | time_zone_transition_type | | user | +---------------------------+ 24 rows in set (0.00 sec) 更新的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‘;
本文出自 “逗哥笔记” 博客,请务必保留此出处http://qiuyt.blog.51cto.com/1229789/1920781
mysql数据库root权限丢失(密码丢失)
标签:数据库 root权限 databases mysql权限丢失
本文系统来源:http://qiuyt.blog.51cto.com/1229789/1920781
内容总结
以上是互联网集市为您收集整理的mysql数据库root权限丢失(密码丢失)全部内容,希望文章能够帮你解决mysql数据库root权限丢失(密码丢失)所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。