mysql ERROR 1045 (28000): Access denied for user 'zyl'@'localhost' (using password: YES)
来源:互联网 发布:淘宝网充值中心在哪 编辑:程序博客网 时间:2024/04/30 03:15
mysql创建用户:
mysql> grant all privileges on *.* to zyl@'%' identified by '123';Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
登陆:
[root@mta222 mysql]# mysql -u zyl -p --socket=/tmp/zhangyl/mysql.sock
ERROR 1045 (28000): Access denied for user 'zyl'@'localhost' (using password: YES)
后来把grant all privileges on *.* to zyl@'%' identified by '123';“%”改成了localhost就可以了,
成功登陆后,我再把localhost改成%,再登陆也是可以的。究竟是为什么我也不清楚,如果有人也遇到这样的问题,解决不了,可以试试这个方法。
- mysql ERROR 1045 (28000): Access denied for user 'zyl'@'localhost' (using password: YES)
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 解决办法
- mysql报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql登录出现:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql 错误解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql出现:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 错误
- 【MySql】ERROR 1045 (28000): Access denied for user 'ambari'@'localhost' (using password: YES)
- MySql 出现ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES).问题解决方案
- MySql数据库链接问题ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- Ubuntu下MySQL的“ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)”
- MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- MySQL登录出现ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- linux 下mysql 报 ERROR 1045 (28000): Access denied for user '-root'@'localhost' (using password: YES)
- linux安装MySQL出现ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- 记录学习过程
- 回调函数
- 毕业一年总结专题2--Web service基础
- linux command: cp, mv, rm
- HTTP协议 (四) 缓存
- mysql ERROR 1045 (28000): Access denied for user 'zyl'@'localhost' (using password: YES)
- javascript学习笔记(三)
- Android事件分发机制完全解析,带你从源码的角度彻底理解(上)
- can't open display
- MediaRecorder start failed -19 java.lang.RuntimeException: start failed
- 黑马程序员--第二十三天:网络编程第一天
- [日志]静心
- ERROR 2003 (HY000): Can't connect to MySQL server
- 设计模式之原型模式(clone)