Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'问题的解决
来源:互联网 发布:java打印word文档 编辑:程序博客网 时间:2024/05/22 23:59
这种问题需要强行重新修改密码,方法如下:
/etc/init.d/mysql stop (service mysqld stop )
/usr/bin/mysqld_safe --skip-grant-tables
另外开个SSH连接
[root@localhost ~]# mysql
mysql>use mysql
mysql>update user set password=password("123456") where user="root";
mysql>flush privileges;
mysql>exit
正常启动 MySQL:/etc/init.d/mysql start (service mysqld start)【可选操作】
/etc/init.d/mysql stop (service mysqld stop )
/usr/bin/mysqld_safe --skip-grant-tables
另外开个SSH连接
[root@localhost ~]# mysql
mysql>use mysql
mysql>update user set password=password("123456") where user="root";
mysql>flush privileges;
mysql>exit
正常启动 MySQL:/etc/init.d/mysql start (service mysqld start)【可选操作】
0 0
- Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'问题的解决
- mySQL 初始登陆问题的解决ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- ubuntu mysql问题 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YSE)解决
- 解决Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'问题
- 解决Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'问题
- 解决Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'问题
- 解决初次登录MySQL出现ERROR 1045 (28000):Access denied for user 'root'@'localhost'问题
- 解决Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'问题
- 解决Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'问题
- 解决MySQL登录ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passwor)问题
- 解决MySQL登录ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passwor)问题
- 解决MySQL登录ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passwor)问题
- 解决初次登录MySQL出现ERROR 1045 (28000):Access denied for user 'root'@'localhost'问题
- mysql“Access denied for user 'root'@'localhost'”问题的解决
- mysql“Access denied for user 'root'@'localhost'”问题的解决
- mysql“Access denied for user 'root'@'localhost'”问题的解决
- Mysql“Access denied for user 'root'@'localhost'”问题的解决
- 解决mysql“Access denied for user 'root'@'localhost'” 的问题
- 2015 11 03 内存分区
- [JPA错误]javax.persistence.EntityNotFoundException: Unable to find xxx
- 字符串回文子序列问题
- cjson不连续存储问题
- UML——类图,对象图,包图
- Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'问题的解决
- 7.1
- IOS开发 - KVC和KVO的使用
- 嵌入式 多线程下变量-原子操作__sync_fetch_and_add等等
- 2015 11 04 函数指针
- spring的四种注入方式
- 【LeetCode OJ 003】Longest Substring Without Repeating Characters
- hihocoder 1110 正则表达式
- poj1163 dp the triangle