mysql

The MySQL command-line tool. More information: <https://www.mysql.com/>.

Install

All systems
curl cmd.cat/mysql.sh
Debian Debian
apt-get install community-mysql
Ubuntu
apt-get install community-mysql
Alpine
apk add mysql
Arch Arch Linux
pacman -S community-mysql
image/svg+xml Kali Linux
apt-get install community-mysql
CentOS
yum install mysql
Fedora
dnf install community-mysql
Windows (WSL2)
sudo apt-get update sudo apt-get install community-mysql
OS X
brew install community-mysql
Raspbian
apt-get install community-mysql
Docker
docker run cmd.cat/mysql mysql powered by Commando

The MySQL command-line tool. More information: <https://www.mysql.com/>.

  • Connect to a database:
    mysql database_name
  • Connect to a database, user will be prompted for a password:
    mysql -u user --password database_name
  • Connect to a database on another host:
    mysql -h database_host database_name
  • Connect to a database through a Unix socket:
    mysql --socket path/to/socket.sock
  • Execute SQL statements in a script file (batch file):
    mysql -e "source filename.sql" database_name
  • Restore a database from a backup created with `mysqldump` (user will be prompted for a password):
    mysql --user user --password database_name < path/to/backup.sql
  • Restore all databases from a backup (user will be prompted for a password):
    mysql --user user --password < path/to/backup.sql

© tl;dr; authors and contributors