Table of Contents iii Preface and Legal Notices .............................................................................................................. xxix 1 General Information ......................................................................................................................... 1 1.1 About This Manual ............................................................................................................... 2 1.2 Overview of the MySQL Database Management System ........................................................ 4 1.2.1 What is MySQL? ....................................................................................................... 4 1.2.2 The Main Features of MySQL .................................................................................... 5 1.2.3 History of MySQL ...................................................................................................... 8 1.3 What Is New in MySQL 8.0 .................................................................................................. 9 1.4 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.0 ....... 50 1.5 MySQL Information Sources ............................................................................................... 70 1.6 How to Report Bugs or Problems ........................................................................................ 71 1.7 MySQL Standards Compliance ............................................................................................ 76 1.7.1 MySQL Extensions to Standard SQL ........................................................................ 77 1.7.2 MySQL Differences from Standard SQL .................................................................... 80 1.7.3 How MySQL Deals with Constraints ......................................................................... 82 1.8 Credits ............................................................................................................................... 84 1.8.1 Contributors to MySQL ............................................................................................. 84 1.8.2 Documenters and translators .................................................................................... 88 1.8.3 Packages that support MySQL ................................................................................. 90 1.8.4 Tools that were used to create MySQL ..................................................................... 91 1.8.5 Supporters of MySQL .............................................................................................. 91 2 Installing and Upgrading MySQL .................................................................................................... 93 2.1 General Installation Guidance ............................................................................................. 96 2.1.1 Supported Platforms ................................................................................................ 96 2.1.2 Which MySQL Version and Distribution to Install ....................................................... 96 2.1.3 How to Get MySQL ................................................................................................. 97 2.1.4 Verifying Package Integrity Using MD5 Checksums or GnuPG ................................... 97 2.1.5 Installation Layouts ................................................................................................ 111 2.1.6 Compiler-Specific Build Characteristics ................................................................... 111 2.2 Installing MySQL on Unix/Linux Using Generic Binaries ...................................................... 111 2.3 Installing MySQL on Microsoft Windows ............................................................................ 114 2.3.1 MySQL Installation Layout on Microsoft Windows .................................................... 117 2.3.2 Choosing an Installation Package ........................................................................... 117 2.3.3 MySQL Installer for Windows ................................................................................. 118 2.3.4 Installing MySQL on Microsoft Windows Using a  noinstall  ZIP Archive ................. 143 2.3.5 Troubleshooting a Microsoft Windows MySQL Server Installation .............................. 151 2.3.6 Windows Postinstallation Procedures ...................................................................... 153 2.3.7 Windows Platform Restrictions ................................................................................ 155 2.4 Installing MySQL on macOS ............................................................................................. 156 2.4.1 General Notes on Installing MySQL on macOS ....................................................... 157 2.4.2 Installing MySQL on macOS Using Native Packages ............................................... 158 2.4.3 Installing and Using the MySQL Launch Daemon .................................................... 162 2.4.4 Installing and Using the MySQL Preference Pane .................................................... 166 2.5 Installing MySQL on Linux ................................................................................................ 170 2.5.1 Installing MySQL on Linux Using the MySQL Yum Repository .................................. 171 2.5.2 Installing MySQL on Linux Using the MySQL APT Repository ................................... 175 2.5.3 Installing MySQL on Linux Using the MySQL SLES Repository ................................. 176 2.5.4 Installing MySQL on Linux Using RPM Packages from Oracle .................................. 176 2.5.5 Installing MySQL on Linux Using Debian Packages from Oracle ............................... 181 2.5.6 Deploying MySQL on Linux with Docker .................................................................. 182 2.5.7 Installing MySQL on Linux from the Native Software Repositories ............................. 194