MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
来源:互联网 发布:linux怎么查看ntp进程 编辑:程序博客网 时间:2024/05/16 14:33
MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
连接MySQL时出现这个访问拒绝问题,密码用户都正确但提示错误很无解,从网上搜索了相关资料后,发现是需要重新设置用户密码,于是我也尝试了下,果真成功,现在分享下给大家,哈哈。
首先确认你的MySQL安装成功,[~]mysql --version 后显示:
mysql Ver 14.14 Distrib 5.6.22, for Linux (x86_64) using EditLine wrapper
代表安装成功
然后你连接时,总是出现
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
做法是重改密码!
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysqld restart
# mysql -u root -p
Enter password:
mysql>
OK
之后,如果在提示:ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
意思让你必须设置下密码,则再运行:set password=password('123456');
最后,就可以完全畅所欲为的运行了。
注意:命令区分大小写的,因为最初使用全小写时,好像语法错误,为安全起见,建议区分大小写。
- 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 '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)
- 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)解决办法
- 线段树
- 15个顶级Java多线程面试题及答案
- Java中final关键字
- 如何通过map文件轻松找到崩溃的代码行
- Search Insert Position题解
- MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- 怎么删除Xcode的缓存
- memcached 一致性hash算法 - consistent hashing
- HDU 2099 -- 整除的尾数
- 为Xcode6 添加预编译文件 .pch
- 重入锁ReentrantLock
- 开源框架IIViewDeck使用
- Android应用基础——Activity
- 第二十五章 异常处理