toolkitbox/mysql repository overview

# Interactive mode
docker run -it --rm \
  ghcr.io/pabpereza/toolkitbox/mysql:latest \
  mysql -h my-server.com -u root -p

# Run single query
docker run --rm \
  ghcr.io/pabpereza/toolkitbox/mysql:latest \
  mysql -h my-server.com -u root -pPASSWORD -e "SHOW DATABASES;"

apiVersion: v1
kind: Pod
metadata:
  name: mysql-client
spec:
  containers:
  - name: mysql-client
    image: ghcr.io/pabpereza/toolkitbox/mysql:latest
    command: ["sleep", "infinity"]
    env:
    - name: MYSQL_HOST
      value: "mysql-service"
    - name: MYSQL_USER
      value: "root"
    - name: MYSQL_PWD
      valueFrom:
        secretKeyRef:
          name: mysql-credentials
          key: password

mysql -h hostname -u user -p

mysql -h hostname -u user -p database_name

mysql -h hostname -u user -p -e "SHOW DATABASES;"

mysql -h hostname -u user -p database < backup.sql

mysqldump -h hostname -u user -p database > backup.sql

mysqldump -h hostname -u user -p --all-databases > full_backup.sql

mysqldump -h hostname -u user -p --no-data database > schema.sql

-- Show databases
SHOW DATABASES;

-- Use database
USE database_name;

-- Show tables
SHOW TABLES;

-- Describe table structure
DESCRIBE table_name;

-- Show active processes
SHOW PROCESSLIST;

-- View server variables
SHOW VARIABLES LIKE '%max_connections%';