mysql_basic_learning_environment

基于Docker快速构建mysql基础学习环境

1. pull docker images（拉取镜像）

docker pull nanamisauce/mysql_basic_learning_environment

2. clone github repository（拉取github仓库文件，非必要）

git clone https://github.com/Machine-gun-dadadadadadada/mysql_basic_learning_environment.git

3. create container（设置容器参数）

docker run -it --name mysql -h mysql -p 3306:3306 nanamisauce/mysql_basic_learning_environment /bin/bash

4. enter mysql（进入mysql）

root@mysql:~# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 77
Server version: 5.7.36 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is 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> 

5. allow remote connections and configure passwords（设置允许远程登录，以及密码）

mysql> grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;

6. view character encoding（mysql字符编码，确保mysql输入中文不会乱码）

mysql> show variables like 'character_%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

mysql> show variables like 'collation_%';
+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database   | utf8_general_ci |
| collation_server     | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.01 sec)

7. remote connection test using navicat（远程测试）