docker yml mysql_Docker安装Mysql（docker-compose.yml）

#########Docker命令查看对应MySQL容器的ContainerID/Image等信息#########

C:\Workspace\Docker\MySQL>docker ps

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

bac300781058 mysql/mysql-server:5.7 "/entrypoint.sh mysql" 2 days ago Up About an hour (healthy) 33060/tcp, 0.0.0.0:3337->3306/tcp mysql57

#########################通过Docker容器进入MySQL##############

C:\Workspace\Docker\MySQL>docker exec -it bac300781058 bash

#########################登陆Mysql并新建用户#######################

bash-4.2# mysql -u root -p

Enter password:

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

Your MySQL connection idis 123Server version:5.7.26MySQL Community Server (GPL)

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

Oracleis a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type'help;' or '\h' for help. Type '\c'to clear the current input statement.

#########################创建用户并分配权限#######################

mysql> create user 'admin001'@'%' identified by 'password123';

Query OK,0 rows affected (0.00sec)

mysql> grant all privileges on *.* to 'admin001'@'%' identified by 'password123';

Query OK,0 rows affected, 1 warning (0.00sec)

mysql>flush privileges;

Query OK,0 rows affected (0.00sec)

mysql>create database database001;

Query OK,1 row affected (0.00sec)

mysql>create database database002 defaultcharset utf8 collate utf8_general_ci;

Query OK,1 row affected (0.00sec)

####################### 删除用户及权限 #########################

mysql>drop user 'admin001'@'localhost'mysql>drop user 'admin001'@'%'####################### 新建用户后，使用admin001登陆 #########################

bash-4.2# mysql -u admin001 -p

Enter password:

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

Your MySQL connection idis 142Server version:5.7.26MySQL Community Server (GPL)

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

Oracleis a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type'help;' or '\h' for help. Type '\c'to clear the current input statement.

mysql>