MySQL 5.6 Reference Manual
iv
2.5.7 Installing MySQL on Linux from the Native Software Repositories ........................ 142
2.5.8 Installing MySQL on Linux with docker .............................................................. 146
2.5.9 Installing MySQL on Linux with juju ................................................................... 146
2.6 Installing MySQL Using Unbreakable Linux Network (ULN) ........................................... 146
2.7 Installing MySQL on Solaris and OpenSolaris ............................................................... 147
2.7.1 Installing MySQL on Solaris Using a Solaris PKG .............................................. 148
2.7.2 Installing MySQL on OpenSolaris Using IPS ...................................................... 148
2.8 Installing MySQL on FreeBSD ..................................................................................... 149
2.9 Installing MySQL from Source ..................................................................................... 150
2.9.1 MySQL Layout for Source Installation ............................................................... 152
2.9.2 Installing MySQL Using a Standard Source Distribution ...................................... 152
2.9.3 Installing MySQL Using a Development Source Tree .......................................... 156
2.9.4 MySQL Source-Configuration Options ............................................................... 158
2.9.5 Dealing with Problems Compiling MySQL .......................................................... 171
2.9.6 MySQL Configuration and Third-Party Tools ...................................................... 172
2.10 Postinstallation Setup and Testing ............................................................................. 172
2.10.1 Initializing the Data Directory .......................................................................... 173
2.10.2 Starting the Server ......................................................................................... 177
2.10.3 Testing the Server ......................................................................................... 179
2.10.4 Securing the Initial MySQL Accounts ............................................................... 181
2.10.5 Starting and Stopping MySQL Automatically .................................................... 185
2.11 Upgrading or Downgrading MySQL ............................................................................ 186
2.11.1 Upgrading MySQL .......................................................................................... 186
2.11.2 Downgrading MySQL ..................................................................................... 198
2.11.3 Checking Whether Tables or Indexes Must Be Rebuilt ...................................... 203
2.11.4 Rebuilding or Repairing Tables or Indexes ....................................................... 204
2.11.5 Copying MySQL Databases to Another Machine .............................................. 206
2.12 Environment Variables .............................................................................................. 207
2.13 Perl Installation Notes ............................................................................................... 208
2.13.1 Installing Perl on Unix .................................................................................... 209
2.13.2 Installing ActiveState Perl on Windows ............................................................ 209
2.13.3 Problems Using the Perl DBI/DBD Interface ..................................................... 210
3 Tutorial ................................................................................................................................. 213
3.1 Connecting to and Disconnecting from the Server ........................................................ 213
3.2 Entering Queries ......................................................................................................... 214
3.3 Creating and Using a Database ................................................................................... 217
3.3.1 Creating and Selecting a Database ................................................................... 218
3.3.2 Creating a Table .............................................................................................. 219
3.3.3 Loading Data into a Table ................................................................................ 220
3.3.4 Retrieving Information from a Table .................................................................. 221
3.4 Getting Information About Databases and Tables ......................................................... 234
3.5 Using mysql in Batch Mode ........................................................................................ 235
3.6 Examples of Common Queries .................................................................................... 237
3.6.1 The Maximum Value for a Column .................................................................... 237
3.6.2 The Row Holding the Maximum of a Certain Column .......................................... 237
3.6.3 Maximum of Column per Group ........................................................................ 238
3.6.4 The Rows Holding the Group-wise Maximum of a Certain Column ....................... 238
3.6.5 Using User-Defined Variables ........................................................................... 239
3.6.6 Using Foreign Keys ......................................................................................... 239
3.6.7 Searching on Two Keys ................................................................................... 241
3.6.8 Calculating Visits Per Day ................................................................................ 241
3.6.9 Using AUTO_INCREMENT ............................................................................... 242
3.7 Using MySQL with Apache .......................................................................................... 244
4 MySQL Programs .................................................................................................................. 245
4.1 Overview of MySQL Programs .................................................................................... 246
4.2 Using MySQL Programs ............................................................................................. 250
4.2.1 Invoking MySQL Programs ............................................................................... 250
4.2.2 Connecting to the MySQL Server ...................................................................... 251
