03-設置root密碼

發布時間：2020-05-23 21:44:48 來源：網絡閱讀：569 作者：771541213 欄目：MySQL數據庫

1).第一次設置root密碼 (默認root密碼為空)

1	[root@mysql1 ~]# mysqladmin -uroot password '123456'

2).修改root密碼

1	[root@mysql1 ~]# mysqladmin -uroot -p123456 password '123456789'

1	[root@mysql1 ~]# mysqladmin -uroot -p123456789 password 'hua19900822**'

3).set password設置密碼

mysql> set password=password('123456'); #修改密碼

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;　　　　　　　　　 #同步到磁盤上

Query OK, 0 rows affected (0.00 sec)

4).update語句修改密碼

mysql> use mysql;

Database changed

mysql> select user,host,password from user;

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

| user | host | password |

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

| root | localhost | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |

| root | mysql1 | |

| root | 127.0.0.1 | |

| root | ::1 | |

| | localhost | |

| | mysql1 | |

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

6 rows in set (0.00 sec)

mysql> update user set password=PASSWORD('789789') where user='root' and host='localhost';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

向AI問一下細節

91超碰碰碰碰久久久久久综合_超碰av人澡人澡人澡人澡人掠_国产黄大片在线观看画质优化_txt小说免费全本