mysql权限丢失
来源:互联网 发布:进度条js代码 编辑:程序博客网 时间:2024/04/27 23:23
ubuntu系统xampp环境下,mysql的root账号权限丢失,即root账号没有任何database的访问权限,mysql>show databases 只显示information_schema和test。
解决方法:进入mysql安全模式,修改root权限。
首先关闭mysql服务 /opt/lampp/lampp stop
进入安全模式:
打开一个命令行终端:/opt/lampp/sbin/mysqld --skip-grant-tables (该命令行终端不要关闭)
打开另一个命令行终端:mysql -u root
修改root权限:
use mysql;
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';最好更新下密码,最后刷新下权限
update user set Password=password('newPassword') where user="root";flush privileges;关闭第一个打开安全模式的终端,启动lampp:/opt/lampp/lampp start 。结束
0 0
- mysql权限丢失
- MySQL数据库root权限丢失解决方案
- 【mysql】忘记密码、权限丢失、mysql启动报错:1067
- Mysql复制还原后root帐号权限丢失问题
- windows下mysql的root权限丢失怎么…
- mysql-root权限丢失恢复 完全菜鸟教程
- 关于mysql 修改权限表user字段host导致权限丢失的问题
- root权限丢失解决方法
- 找回丢失的权限
- MySQL修改root用户密码引起的root超级权限丢失的问题(Mac平台
- SharePoint 2010 突然丢失权限
- MYSQL数据丢失讨论
- MYSQL数据丢失讨论
- MYSQL数据丢失讨论
- MYSQL数据丢失讨论
- MYSQL数据丢失讨论
- mysql.sock丢失问题
- MYSQL数据丢失讨论
- Table布局
- Python篇----命令行调用、输出log日志并打包的脚本
- OM-Internal Sales Order (ISO) Process Flow
- Unity 基础 场景切换
- 华为机试——最高出现频率字符
- mysql权限丢失
- mysql中的结果拼接
- easyui的datagrid中editor和combogrid的结合使用
- socket通信中select函数的使用和解释
- qt-gui的GUI hint参数
- [web安全] 服务器端请求伪造(SSRF)
- 如何去除移动端链接a标签产生带色边框
- Linux 下curl模拟Http 的get or post请求
- [Android Memory] 内存分析工具 MAT 的使用