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
myisamchk — MyISAM Table-Maintenance Utility
myisamchk General Options
myisamchk Check Options
myisamchk Repair Options
Other myisamchk Options
Obtaining Table Information with myisamchk
myisamchk Memory Usage
myisamlog — Display MyISAM Log File Contents
myisampack — Generate Compressed, Read-Only MyISAM Tables
mysql_config_editor — MySQL Configuration Utility
mysql_migrate_keyring — Keyring Key Migration Utility
mysqlbinlog — Utility for Processing Binary Log Files
mysqlbinlog Hex Dump Format
mysqlbinlog Row Event Display
Using mysqlbinlog to Back Up Binary Log Files
Specifying the mysqlbinlog Server ID
mysqldumpslow — Summarize Slow Query Log Files
Program Development Utilities
mysql_config — Display Options for Compiling Clients
my_print_defaults — Display Options from Option Files
Miscellaneous Programs
lz4_decompress — Decompress mysqlpump LZ4-Compressed Output
perror — Display MySQL Error Message Information
zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output
Environment Variables
Unix Signal Handling in MySQL
MySQL Server Administration
Security
Backup and Recovery
Optimization
Language Structure
Character Sets, Collations, Unicode
Data Types
Functions and Operators
SQL Statements
MySQL Data Dictionary
The InnoDB Storage Engine
Alternative Storage Engines
Replication
Group Replication
MySQL Shell
Using MySQL as a Document Store
InnoDB Cluster
InnoDB ReplicaSet
MySQL NDB Cluster 8.0
Partitioning
Stored Objects
INFORMATION_SCHEMA Tables
MySQL Performance Schema
MySQL sys Schema
Connectors and APIs
MySQL Enterprise Edition
MySQL Workbench
MySQL on OCI Marketplace
MySQL 8.0 Frequently Asked Questions
Error Messages and Common Problems
Indexes
MySQL Glossary
Related Documentation
MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
Download this Manual
PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.0Kb
Man Pages (Zip)
- 401.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
Security in MySQL
Starting and Stopping MySQL
MySQL and Linux/Unix
MySQL and Windows
MySQL and macOS
MySQL and Solaris
Building MySQL from Source
MySQL Restrictions and Limitations
MySQL Partitioning
MySQL Tutorial
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL NDB Cluster 8.0
version 8.0
9.1
9.0
8.4 current
5.7
8.0 Japanese
MySQL 8.0 Reference Manual
/
MySQL Programs
/ Installation-Related Programs
6.4 Installation-Related Programs
6.4.1 comp_err — Compile MySQL Error Message File
6.4.2 mysql_secure_installation — Improve MySQL Installation Security
6.4.3 mysql_ssl_rsa_setup — Create SSL/RSA Files
6.4.4 mysql_tzinfo_to_sql — Load the Time Zone Tables
6.4.5 mysql_upgrade — Check and Upgrade MySQL Tables
The programs in this section are used when installing or upgrading MySQL.
PREV
HOME
UP
NEXT
Related Documentation
MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
Download this Manual
PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.0Kb
Man Pages (Zip)
- 401.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
Security in MySQL
Starting and Stopping MySQL
MySQL and Linux/Unix
MySQL and Windows
MySQL and macOS
MySQL and Solaris
Building MySQL from Source
MySQL Restrictions and Limitations
MySQL Partitioning
MySQL Tutorial
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL NDB Cluster 8.0