USDocker script for start MySQL
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
mysql
.eslintignore
.eslintrc.yml
.gitignore
.travis.yml
README.md
package-lock.json
package.json
usdocker_mysql.js

README.md

USDocker for MySQL

This script creates a MySQL applicantion from a docker image. You can persist your mysql and customize your mysql without expertise in Docker.

Installing

npm install -g @usdocker/usdocker # Install it first
npm install -g @usdocker/mysql
usdocker -r    # Update USDocker database

Start the mysql service

usdocker mysql up

Stop the mysql service

usdocker mysql down

Check if the service is running

usdocker mysql status

Run the mysql-client command line interface

usdocker mysql client -- [args]

Example:

usdocker mysql client -- -u root -p

Connect to the mysql bash interface

usdocker mysql connect -- [args]

Dump the database and save it to the /tmp/dump folder.

usdocker mysql dump -- [database]

Analyse the database service and get insights for tuning it

usdocker mysql analyse

Customize your Service

You can setup the variables by using:

usdocker mysql --set variable=value

Default values

  • image: "mysql:5.7",
  • folder: "$HOME/.usdocker/data/mysql",
  • port: 3306,
  • rootPassword: "password" (note: only will work at the first time)

Customize the "$HOME/.usdocker/setup/mysql/conf.d/custom.cnf"

Use your own setup for mysql changing this file.

[mysqld]
bind-address = 0.0.0.0

[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

Customize the "$HOME/.usdocker/setup/mysql/home/"

This folder exists for setup the database dump. You have only edit the file .my.cnf with the following setup:

[mysqldump]
user=backup
password=PasSWord