Skip to Main Content
The world's most popular open source database
Contact MySQL
|
Login
|
Register
MySQL.com
Downloads
Documentation
Developer Zone
Developer Zone
Downloads
MySQL.com
Documentation
MySQL Server
MySQL Enterprise
Workbench
InnoDB Cluster
MySQL NDB Cluster
Connectors
More
MySQL.com
Downloads
Developer Zone
Section Menu:
Documentation Home
MySQL 8.0 Reference Manual
Preface and Legal Notices
General Information
Installing MySQL
Upgrading MySQL
Downgrading MySQL
Tutorial
MySQL Programs
Overview of MySQL Programs
Using MySQL Programs
Invoking MySQL Programs
Specifying Program Options
Using Options on the Command Line
Using Option Files
Command-Line Options that Affect Option-File Handling
Program Option Modifiers
Using Options to Set Program Variables
Option Defaults, Options Expecting Values, and the = Sign
Command Options for Connecting to the Server
Connecting to the MySQL Server Using Command Options
Connecting to the Server Using URI-Like Strings or Key-Value Pairs
Connecting to the Server Using DNS SRV Records
Connection Transport Protocols
Connection Compression Control
Setting Environment Variables
Server and Server-Startup Programs
mysqld — The MySQL Server
mysqld_safe — MySQL Server Startup Script
mysql.server — MySQL Server Startup Script
mysqld_multi — Manage Multiple MySQL Servers
Installation-Related Programs
comp_err — Compile MySQL Error Message File
mysql_secure_installation — Improve MySQL Installation Security
mysql_ssl_rsa_setup — Create SSL/RSA Files
mysql_tzinfo_to_sql — Load the Time Zone Tables
mysql_upgrade — Check and Upgrade MySQL Tables
Client Programs
mysql — The MySQL Command-Line Client
mysql Client Options
mysql Client Commands
mysql Client Logging
mysql Client Server-Side Help
Executing SQL Statements from a Text File
mysql Client Tips
mysqladmin — A MySQL Server Administration Program
mysqlcheck — A Table Maintenance Program
mysqldump — A Database Backup Program
mysqlimport — A Data Import Program
mysqlpump — A Database Backup Program
mysqlshow — Display Database, Table, and Column Information
mysqlslap — A Load Emulation Client
Administrative and Utility Programs
ibd2sdi — InnoDB Tablespace SDI Extraction Utility
innochecksum — Offline InnoDB File Checksum Utility
myisam_ftdump — Display Full-Text Index information