mysql SELECT/UPDATE command denied to user 'root'@'localhost' for table 'XXX' 报错1142处理
来源:互联网 发布:中长发发型知乎 编辑:程序博客网 时间:2024/05/16 15:49
该问题是因为root没有select权限引起的。
解决:赋予root权限
参考原文:https://www.cnblogs.com/owenma/p/7073297.html
1.首先停止MySQL服务:service mysqld stop
2.加参数启动mysql:/usr/bin/mysqld_safe --skip-grant-tables &
然后就可以无任何限制的访问mysql了
3.root用户登陆系统:mysql -u root -p mysql
4.切换数据库:use mysql
5.显示所有的表:show tables;
这里就可以访问表了
6.查看user表中root用户的localhost权限:select * from user where user='root' and host='localhost'
7.在显示的列表中显示:root用户的localhost的权限都是'N',表示root用户本地登陆不具有权限
8.修改root用户的localhost权限:
update user set
`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` = 'Y',
`Create_tablespace_priv` = 'Y'
where user='root' and host='localhost
-------在输入命令进行操作时报错,把 `Create_tablespace_priv` = 'Y'去掉解决
9.更新一下:flush privileges;
10.然后重新启动下mysql,可以解决问题了
- mysql SELECT/UPDATE command denied to user 'root'@'localhost' for table 'XXX' 报错1142处理
- mysql SELECT command denied to user 'root'@'localhost' for table 'XXX' 报错1142
- mysqldump: Got error: 1142: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table
- 解决mybatis的SELECT command denied to user 'root'@'192.168.1.47' for table 'user'的报错。mysql用户权限修改,表权限修改。
- MySql 安装报错 :Last Error:Unable to update security. Access denied for user 'root'@'localhost'(using pa
- MySql 安装报错 :Last Error:Unable to update security. Access denied for user 'root'@'localhost'(using pa
- - INSERT command denied to user 'XXX'@'XXX.internal' for table
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”的处理方法
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”的处理方法
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”的处理方法
- mysql登录报错“Access denied for user 'root'@'localhost' (using password: YES”)的处理方法
- ERROR 1142 (42000) at line 6688: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for t
- mysql安装报错 - Unable to update security settings. Access denied for user 'root'@'loca
- mysql 5.5 中mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' fo
- mysql切换数据库时会报错:ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'mysql'
- mysql "select command denied to user root" 问题解决
- 1142,ALTER command denied to user 'test'@'localhost' for table 'django_content_type'
- ERROR 1142 (42000): INSERT command denied to user 'radius'@'localhost' for table 'radcheck'
- 171111-数组的学习【连续第十九天】
- 新增的非主体结构元素
- vue入门案例
- 面试算法收集(网易)二
- (六)、Java复习笔记之异常
- mysql SELECT/UPDATE command denied to user 'root'@'localhost' for table 'XXX' 报错1142处理
- Git版本管理--reset
- python3.5《机器学习实战》学习笔记(五):决策树算法实战之预测隐形眼镜类型
- Uva247.Calling Circles(Floyd求连通性)
- 可变参数列表浅析
- c语言:错误C4473:“scanf_s”没有为格式字符串传递足够的参数
- 浅谈Android动画(二)
- week9-leetcode #19-Remove-Nth-Node-From-End-of-List
- 设计模式之JDK动态代理