一杂伟、進(jìn)入mysql
- 進(jìn)入mysql容器（安裝在docker里面)祭芦，安裝在物理機(jī)上的這一步省略筷笨。
docker ps
docker exec -it 容器id(容器名) bash
docker exec -it mysql-test bash
- 輸入root賬戶(hù)進(jìn)入mysql
mysql -u root -p密碼
二、創(chuàng)建數(shù)據(jù)庫(kù)
- 默認(rèn)創(chuàng)建數(shù)據(jù)庫(kù)的配置字符集
mysql> CREATE DATABASE testdb1;
查看數(shù)據(jù)：SHOW DATABASES;
刪除數(shù)據(jù)庫(kù)：DROP DATABASE testdb1;
- 也可以指定字符集
mysql> CREATE DATABASE testdb1 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
Query OK, 0 rows affected (0.09 sec)
三龟劲、創(chuàng)建用戶(hù)
create user 'test'@'%' identified by 'test';
Query OK, 0 rows affected (0.09 sec)
四胃夏、授權(quán)用戶(hù)
mysql> grant all on *.* to 'test'@'%' ;
Query OK, 0 rows affected (0.10 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
五、查看數(shù)據(jù)庫(kù)
1昌跌，選擇mysql數(shù)據(jù)庫(kù)
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select host,user,plugin from user;
mysql用戶(hù)列表
兩個(gè)root用戶(hù) 仰禀，'root'@'%'，'root'@'localhost'（只有本地參能連接）蚕愤、搭建好mysql數(shù)據(jù)庫(kù)后答恶，記得修改兩個(gè)root用戶(hù)的密碼，修改方式如下审胸。
Navicat
1亥宿、創(chuàng)建數(shù)據(jù)庫(kù)
mysql> CREATE DATABASE testdb1 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
2、創(chuàng)建用戶(hù)
mysql> CREATE user 'test'@'%' identified by 'test123';
3砂沛、授權(quán)
grant all on testdb1 .* to 'test'@'%' ;
grant all on *.* to 'test'@'%' ;
4烫扼、刷新權(quán)限
flush privileges;
修改加密方式
- 修改密碼為用不過(guò)期
mysql> ALTER USER 'root'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.02 sec)
- 修改密碼并指定加密規(guī)則為mysql_native_password
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.01 sec)
- 刷新權(quán)限
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
