11月 25, 2019 MySQL
### 修改 ROOT 使用者密碼

可以使用以下的 Command :

```sh
mysql > grant all privileges on *.* to 'root'@'localhost';

mysql > alter user 'root'@'localhost' identified by 'your-password'; 

mysql > update mysql.user set plugin = 'mysql_native_password' where host = 'localhost' and user = 'root'; 

mysql > flush privileges;
```
過去文章
2025 (9)
4 (5)
3 (1)
2 (3)
2024 (25)
11 (3)
10 (3)
9 (1)
3 (18)
2022 (6)
10 (1)
6 (2)
5 (1)
3 (1)
1 (1)
2021 (21)
11 (7)
7 (1)
6 (2)
5 (2)
4 (6)
3 (2)
2 (1)
2020 (92)
12 (1)
11 (2)
10 (4)
9 (10)
8 (5)
7 (1)
6 (3)
5 (1)
4 (4)
3 (25)
2 (7)
1 (29)
2019 (57)
12 (25)
11 (7)
9 (25)