Skip to content

Latest commit

 

History

History
64 lines (58 loc) · 1.37 KB

README.md

File metadata and controls

64 lines (58 loc) · 1.37 KB

crudapi mysql

mysql

mkdir -p /opt/crudapi/mysql
chmod 777 /opt/crudapi/mysql

docker pull crudapi/mysql
docker tag crudapi/mysql crudapi-mysql
docker rm -f mysql
docker run --privileged --name "mysql" \
   --restart=always \
   -e "MYSQL_DATABASE=crudapi" \
   -e "MYSQL_ROOT_PASSWORD=root@Mysql" \
   -e "TZ=Asia/Shanghai" \
   -p "3306:3306" \
   -p "33060:33060" \
   -v "/opt/crudapi/mysql/data:/var/lib/mysql" \
   -d crudapi-mysql  \
   --character-set-server=utf8mb4 \
   --collation-server=utf8mb4_unicode_ci \
   --lower_case_table_names=0 \
   --innodb_ft_min_token_size=1

mysql phpmyadmin

docker rm -f mysqladmin
docker run --name mysqladmin \
   --restart=always \
   -e UPLOAD_LIMIT=100M \
   --link mysql:db \
   -p 8081:80 \
   -d phpmyadmin/phpmyadmin

mariadb

mkdir -p /opt/crudapi/mariadb
chmod 777 /opt/crudapi/mariadb

docker pull mariadb
docker rm -f mariadb
docker run --name mariadb \
   --restart=always \
   -e TZ=Asia/Shanghai \
   -e MARIADB_DATABASE=crudapi \
   -e MARIADB_ROOT_PASSWORD=root@Mysql \
   -p "3307:3306" \
   -p "33070:33060" \
   -v "/opt/crudapi/mariadb/data:/var/lib/mysql" \
   -d mariadb:latest

mariadb phpmyadmin

docker rm -f mariadbadmin
docker run --name mariadbadmin \
   --restart=always \
   -e UPLOAD_LIMIT=100M \
   --link mariadb:db \
   -p 8082:80 \
   -d phpmyadmin/phpmyadmin