django Access denied for user 'Administrator'@'localhost'
来源:互联网 发布:淘宝手机壳店 编辑:程序博客网 时间:2024/06/03 18:41
从书上抄了以下两句执行时报题目所示错误
mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';
执行结果如下:
mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
ERROR 1133 (42000): Can't find any matching row in the user table
mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';
ERROR 1133 (42000): Can't find any matching row in the user table
其实如果事先在mysql.user表中存在admin和dummy两个用户就正常了。
另外,将这两句末尾加上identified by '密码' 也就正常了
mysql> GRANT select ON *.* TO 'admin'@'localhost' identified by '123';
Query OK, 0 rows affected (0.00 sec)
参考:
http://blog.sina.com.cn/s/blog_548c08c801018559.html
0 0
- django Access denied for user 'Administrator'@'localhost'
- Access denied for user 'Administrator'@'localhost' (using password: YES)
- Access denied for user 'Administrator'@'localhost' (using password: YES)
- java.sql.SQLException: Access denied for user 'Administrator'@'localhost' (using password: YES)
- ssm整合过程中问题记录--异常:Access denied for user 'Administrator'@'localhost' (using password: YES)
- java.sql.SQLException: Access denied for user 'Administrator'@'localhost' (using password: YES)
- SSM整合问题:Cannot create PoolableConnectionFactory (Access denied for user 'Administrator'@'localhost'
- ssm 框架整合出错:Access denied for user 'Administrator'@'localhost' (using password: YES)
- java.sql.SQLException: Access denied for user 'Administrator'@'localhost' (using password: YES)
- c3p0加载properties配置文件 报错 Access denied for user 'Administrator'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' 解决方法
- Access denied for user 'root'@'localhost' 解决方案
- Access denied for user 'root'@'localhost'
- Access denied for user 'root'@'localhost'
- Access denied for user 'root'@'localhost'
- Access denied for user 'root'@'localhost'
- Access denied for user 'root'@'localhost'
- Access denied for user 'root'@'localhost'
- 一、shell监控网站是否可以访问
- nginx mysql 在并发的一个错误原因探究
- 正则表达式学习笔记(一)基本用法
- ZSTU4272-最佳淘汰算法
- 实验室智能管理系统(3)——zigbee部分
- django Access denied for user 'Administrator'@'localhost'
- 生成全排列(经典题 && 洛谷 P1706 )
- 1021. 个位数统计 (15)-PAT乙级
- 修改包名最便捷做法
- XML:inerXML和outerXML
- 【数据压缩】bmp2yuv
- 【UESTC 1523 我想上厕所】
- selenium对浏览器操作、鼠标操作等总结
- 安装遇错误无法将grub-efi-amd64-signed软件包安装