ERROR 1142 (42000): INSERT command denied to user 'radius'@'localhost' for table 'radcheck'
来源:互联网 发布:无锡房价 知乎 编辑:程序博客网 时间:2024/05/29 11:45
/etc/freeradius# mysql -uradius -p
passwd:
mysql> use radius;
mysql> show tables;
+------------------+
| Tables_in_radius |
+------------------+
| radacct |
| radcheck |
| radgroupcheck |
| radgroupreply |
| radpostauth |
| radreply |
| radusergroup |
+------------------+
mysql> insert into radgroupreply (groupname,attribute,op,value) values ('user','Auth-Type',':=','Local');
ERROR 1142 (42000): INSERT command denied to user 'radius'@'localhost' for table 'radgroupreply'
原因:权限不够,登录数据库的方式不对。用mysql -uradius -p 方式登录进去后无法进行插入操作,需要用root用户登录。
解决:/etc/freeradius# mysql -uroot -p
passwd:
mysql> use radius;
mysql> insert into radgroupreply (groupname,attribute,op,value) values ('user','Auth-Type',':=','Local');
Query OK, 1 row affected (0.00 sec)
成功!
阅读全文
1 0
- ERROR 1142 (42000): INSERT command denied to user 'radius'@'localhost' for table 'radcheck'
- mysqldump: Got error: 1142: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table
- - INSERT command denied to user 'XXX'@'XXX.internal' for table
- ERROR 1142 (42000): UPDATE command denied to user 'test'@'192.168.1.101' for table 'employees'
- mysql SELECT command denied to user 'root'@'localhost' for table 'XXX' 报错1142
- 1142,ALTER command denied to user 'test'@'localhost' for table 'django_content_type'
- mysql SELECT/UPDATE command denied to user 'root'@'localhost' for table 'XXX' 报错1142处理
- ERROR 1370 (42000): execute command denied to user backupAccount@'localhost' for routine 'databaseNa
- ERROR 1142 (42000) at line 6688: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for t
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database
- ERROR 1044 (42000): Access denied for user ”@’localhost’ to database
- 1370 (42000): grant command denied to user ''@'localhost' for routine 'test.f1'
- INSERT command denied to user 上线后
- mysql INSERT command denied to user
- mysql root 进入出现ERROR 1044(42000):Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql
- struts2中文乱码问题
- 排列(permutition)
- 设计模式之装饰者设计模式
- python模拟网站登录
- jieba分词
- ERROR 1142 (42000): INSERT command denied to user 'radius'@'localhost' for table 'radcheck'
- 深拷贝和浅拷贝
- 使用SciPy进行常用的图像操作
- html中的特殊字符
- 浅谈Java中的深拷贝和浅拷贝
- Nginx安装配置
- 解决libcudart.so.8.0或libcusolver.so.8.0: cannot open shared object file: No such file or directory
- Android 浏览器内核浅谈
- SharedPreferences工具类