Contact MySQL
|
Login
|
Register
The world's most popular open source database
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 and Upgrading 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
Connection Compression Control
Setting Environment Variables
MySQL 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
MySQL 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
MySQL 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 — Client for Administering a MySQL Server
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 — Load Emulation Client
MySQL 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
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
MySQL 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
MySQL Environment Variables
MySQL Server Administration
Security
Backup and Recovery
Optimization
Language Structure
Character Sets, Collations, Unicode
Data Types
Functions and Operators
SQL Statement Syntax
MySQL Data Dictionary
The InnoDB Storage Engine
Alternative Storage Engines
Replication
Group Replication
MySQL Shell
Using MySQL as a Document Store
InnoDB Cluster
MySQL NDB Cluster 8.0
Partitioning
Stored Objects
INFORMATION_SCHEMA Tables
MySQL Performance Schema
MySQL sys Schema
Connectors and APIs
Extending MySQL
MySQL Enterprise Edition
MySQL Workbench
MySQL 8.0 Frequently Asked Questions
Errors, Error Codes, and Common Problems
Restrictions and Limits
Indexes
MySQL Glossary
Related Documentation
MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
Download this Manual
PDF (US Ltr)
- 46.1Mb
PDF (A4)
- 46.1Mb
PDF (RPM)
- 41.5Mb
HTML Download (TGZ)
- 10.6Mb
HTML Download (Zip)
- 10.6Mb
HTML Download (RPM)
- 9.1Mb
Man Pages (TGZ)
- 220.4Kb
Man Pages (Zip)
- 325.8Kb
Info (Gzip)
- 4.1Mb
Info (Zip)
- 4.1Mb
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 OS X
MySQL and Solaris
Building MySQL from Source
MySQL Restrictions and Limitations
MySQL Partitioning
MySQL Secure Deployment Guide
MySQL Tutorial
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
version 8.0
5.7
5.6
5.5
5.6 Japanese
MySQL 8.0 Reference Manual
/
MySQL Programs
/ MySQL Installation-Related Programs
4.4 MySQL Installation-Related Programs
[
+/-
]
4.4.1
comp_err
— Compile MySQL Error Message File
4.4.2
mysql_secure_installation
— Improve MySQL Installation Security
4.4.3
mysql_ssl_rsa_setup
— Create SSL/RSA Files
4.4.4
mysql_tzinfo_to_sql
— Load the Time Zone Tables
4.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)
- 46.1Mb
PDF (A4)
- 46.1Mb
PDF (RPM)
- 41.5Mb
HTML Download (TGZ)
- 10.6Mb
HTML Download (Zip)
- 10.6Mb
HTML Download (RPM)
- 9.1Mb
Man Pages (TGZ)
- 220.4Kb
Man Pages (Zip)
- 325.8Kb
Info (Gzip)
- 4.1Mb
Info (Zip)
- 4.1Mb
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 OS X
MySQL and Solaris
Building MySQL from Source
MySQL Restrictions and Limitations
MySQL Partitioning
MySQL Secure Deployment Guide
MySQL Tutorial
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository