mysql改密码与权限
mysql命令怎么，数据库设置密码？
mysql命令怎么，数据库设置密码？
mysql设置数据库密码常用的有四种方法：
1.用root登陆MySQL终端 mysqlgtsetpasswordpassword(‘raykaeso‘) mysqlgtflushprivileges
2.在MySQL终端中使用GRANT语句 mysqlgtgrantallon*.*to‘root’@’localhost’IDENTIFIEDBY‘raykaeso’withgrantoption mysqlgtflushprivileges
3.在MySQL库user表中直接修改 mysqlgtusemysql mysqlgtupdateusersetpasswordpassword(‘raykaeso’)whereuser’root mysqlgtflushprivileges 4、在shell命令行里修改MySQL用户密码 [?leixuesong]mysqladmin-urootpassword“yourpassword”
ubuntu20.04修改mysql密码？
先进入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
下面就是修改初始密码的步骤：
现在mysql命令下输入
mysqlgt use mysql
1
1
然后修改密码：
mysqlgt ALTER USER #39root#39@#39localhost#39 IDENTIFIED WITH caching_sha2_password BY #39你的新密码#39
1
1
到这里新密码就设置好了，下面我们登录下：
$ 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