ubuntu20.04修改mysql密碼？先進(jìn)入root模式：sudo -s11然后輸入命令mysql:/home/cdd/Desktop/Django/typeidea-env/typeidea/t

ubuntu20.04修改mysql密碼？

先進(jìn)入root模式：

sudo -s

1

1

然后輸入命令mysql

:/home/cdd/Desktop/Django/typeidea-env/typeidea/typeidea# mysql

Welcome to the MySQL monitor. Commands end with or g.

Your MySQL connection id is 22

Server version: 8.0.21-0ubuntu0.20.04.4 (Ubuntu)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type #39help#39 or #39h#39 for help. Type #39c#39 to clear the current input statement.

mysqlgt

1

2

3

4

5

6

7

8

9

10

11

12

13

14

1

2

3

4

5

6

7

8

9

10

11

12

13

14

下面就是修改初始密碼的步驟：

現(xiàn)在mysql命令下輸入

mysqlgt use mysql

1

1

然后修改密碼：

mysqlgt ALTER USER #39root#39@#39localhost#39 IDENTIFIED WITH caching_sha2_password BY #39你的新密碼#39

1

1

到這里新密碼就設(shè)置好了，下面我們登錄下：

$ mysql -u root -p

Enter password: # 這里輸入你的新密碼

Welcome to the MySQL monitor. Commands end with or g.

Your MySQL connection id is 28

Server version: 8.0.21-0ubuntu0.20.04.4 (Ubuntu)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type #39help#39 or #39h#39 for help. Type #39c#39 to clear the current input statement.

mys

ubuntu 12.04刪除了管理員密碼和root密碼后無(wú)法更改設(shè)置，現(xiàn)如何重置，求大神指點(diǎn)～～詳細(xì)點(diǎn)～～～謝謝～？

“更改root密碼:sudo passwd root 更改管理員密碼:把上面的root改成相應(yīng)的賬號(hào)名?！毕Ｍ軒偷侥?/p>