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

# 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（远程测试）