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