mysql中出现 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)的解决办法
来源:互联网 发布:电脑数据 编辑:程序博客网 时间:2024/05/16 03:47
转载自百度知道 链接
#1.停止mysql数据库/etc/init.d/mysqld stop #2.执行如下命令mysqld_safe --user=mysql --skip-grant-tables --skip-networking & #3.使用root登录mysql数据库mysql -u root mysql #4.更新root密码mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';#最新版MySQL请采用如下SQL:mysql> UPDATE user SET authentication_string=PASSWORD('newpassword') where USER='root'; #5.刷新权限 mysql> FLUSH PRIVILEGES; #6.退出mysqlmysql> quit #7.重启mysql/etc/init.d/mysqld restart #8.使用root用户重新登录mysqlmysql -uroot -p Enter password: <输入新设的密码newpassword>
0 0
- mysql中出现 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)的解决办法
- ERROR 1045 (28000): Access denied for user root@localhost (using password: NO) 的解决办法 ---linux
- Ubuntu下 MySQL的“ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)”
- MySQL 报错 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) 的解决办法
- mysql-->ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql Error 1045(28000) Access Denied for user 'root'@'localhost' (Using password:NO)
- [linux][mysql]ERROR 1045 (28000) : Access denied for user 'root'@'localhost' (using password:No)错误
- mysql解决ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- MySQL: Error 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: NO)
- centOS下mysql-ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql问题:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql提示ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql问题ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- 新安装mysql ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
- 解决MySQL 报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Linux mysql 5.6: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Mysql没有初始密码(ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO))
- Linux mysql 5.6: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- lintcode阶梯训练第二关(九章)
- 3991: [SDOI2015]寻宝游戏
- ssm框架简单整合
- 单点登录(四)-----遇到问题-----cas server 源码部署tomcat运行报错ClassNotFoundException: org.jasig.cas.CasEnvironmentCo
- bootstrap在线定制工具
- mysql中出现 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)的解决办法
- 使用可变函数
- oj-输出格式
- 算法竞赛一些基础问题的复习(java) 2(开灯问题、蛇形填数、TEX、wertyu)
- JavaScript 使用 requestAnimationFrame 代替 setInterval
- 乘法密码
- Spring入门实例
- 洛谷P1181 数列分段
- 【Python学习】 之 Turtle库