登录mysql密码报错_浅谈mysql密码遗忘和登陆报错的问题

mysql> insert into user(host,user,password) values("localhost","root","123456");

Query OK, 1 row affected, 3 warnings (0.01 sec)

mysql> select host,user,password from user;

+-----------+------+----------+

| host | user | password |

+-----------+------+----------+

| localhost | root | 123456 |

+-----------+------+----------+

1 row in set (0.00 sec)

mysql> update mysql.user set password=password("123456") where host="localhost" and user="root";

Query OK, 1 row affected (0.01 sec)

Rows matched: 1 Changed: 1 Warnings: 0

mysql> select host,user,password from user;

+-----------+------+-------------------------------------------+

| host | user | password |

+-----------+------+-------------------------------------------+

| localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |

+-----------+------+-------------------------------------------+

1 row in set (0.00 sec)

mysql> insert into user(host,user,password) values("127.0.0.1","root","123456");

Query OK, 1 row affected, 3 warnings (0.00 sec)

mysql> select host,user,password from user;

+-----------+------+-------------------------------------------+

| host | user | password |

+-----------+------+-------------------------------------------+

| localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |

| 127.0.0.1 | root | 123456 |

+-----------+------+-------------------------------------------+

2 rows in set (0.00 sec)

mysql> update mysql.user set password=password("123456") where user="root";

Query OK, 1 row affected (0.00 sec)

Rows matched: 2 Changed: 1 Warnings: 0

mysql> select host,user,password from user;

+-----------+------+-------------------------------------------+

| host | user | password |

+-----------+------+-------------------------------------------+

| localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |

| 127.0.0.1 | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |

+-----------+------+-------------------------------------------+

热点聚合:

©CopyRight 2010-2020 EASCK.COM Inc All Rights Reserved. 易采站长站 版权所有

微信扫一扫