Table of Contents
- 5.1. Overview of Server-Side Programs
- 5.2. mysqld — The MySQL Server
- 5.3. The mysqld-max Extended MySQL Server
- 5.4. MySQL Server Startup Programs
- 5.5. mysqlmanager — The MySQL Instance Manager
- 5.6. Installation-Related Programs
- 5.7. General Security Issues
- 5.8. The MySQL Access Privilege System
-
- 5.8.1. What the Privilege System Does
- 5.8.2. How the Privilege System Works
- 5.8.3. Privileges Provided by MySQL
- 5.8.4. Connecting to the MySQL Server
- 5.8.5. Access Control, Stage 1: Connection Verification
- 5.8.6. Access Control, Stage 2: Request Verification
- 5.8.7. When Privilege Changes Take Effect
-
5.8.8. Causes of
Access deniedErrors - 5.8.9. Password Hashing as of MySQL 4.1
- 5.9. MySQL User Account Management
- 5.10. Backup and Recovery
- 5.11. MySQL Localization and International Usage
-
- 5.11.1. The Character Set Used for Data and Sorting
- 5.11.2. Setting the Error Message Language
- 5.11.3. Adding a New Character Set
- 5.11.4. The Character Definition Arrays
- 5.11.5. String Collating Support
- 5.11.6. Multi-Byte Character Support
- 5.11.7. Problems With Character Sets
- 5.11.8. MySQL Server Time Zone Support
- 5.12. MySQL Server Logs
- 5.13. Running Multiple MySQL Servers on the Same Machine
- 5.14. The MySQL Query Cache
This chapter covers topics that deal with administering a MySQL installation:
-
Configuring the server
-
Managing user accounts
-
Performing backups
-
The server log files
-
The query cache
The MySQL server, mysqld, is the main program that does most of the work in a MySQL installation. The server is accompanied by several related scripts that perform setup operations when you install MySQL or that assist you in starting and stopping the server. This section provides an overview of the server and related programs. The following sections provide more detailed information about each of these programs.
Each MySQL program takes many different options. Most programs
provide a --help option that you can use to get a
description of the program's different options. For example, try
mysqld --help.
You can override default option values for MySQL programs by specifying options on the command line or in an option file. Section 4.3, “Specifying Program Options”.
The following list briefly describes the MySQL server and server-related programs:
-
The SQL daemon (that is, the MySQL server). To use client programs, mysqld must be running, because clients gain access to databases by connecting to the server. See Section 5.2, “mysqld — The MySQL Server”.
-
A version of the server that includes additional features. See Section 5.3, “The mysqld-max Extended MySQL Server”.
-
A server startup script. mysqld_safe attempts to start mysqld-max if it exists, and mysqld otherwise. See Section 5.4.1, “mysqld_safe — MySQL Server Startup Script”.
-
A server startup script. This script is used on systems that use System V-style run directories containing scripts that start system services for particular run levels. It invokes mysqld_safe to start the MySQL server. See Section 5.4.2, “mysql.server — MySQL Server Startup Script”.
-
A server startup script that can start or stop multiple servers installed on the system. See Section 5.4.3, “mysqld_multi — Manage Multiple MySQL Servers”. As of MySQL 5.0.3 (Unix-like systems) or 5.0.13 (Windows), an alternative to mysqld_multi is
mysqlmanager, the MySQL Instance Manager. See Section 5.5, “mysqlmanager — The MySQL Instance Manager”. -
This script creates the MySQL database and initializes the grant tables with default privileges. It is usually executed only once, when first installing MySQL on a system. See Section 2.10.2, “Unix Post-Installation Procedures”.
-
This program is used after a MySQL upgrade operation. It updates the grant tables with any changes that have been made in newer versions of MySQL. See Section 5.6.1, “mysql_fix_privilege_tables — Upgrade MySQL System Tables”.
Note: As of MySQL 5.0.19, this program has been superseded by mysql_upgrade.
-
This program is used after a MySQL upgrade operation. It checks tables for incompatibilities and repairs them if necessary, and updates the grant tables with any changes that have been made in newer versions of MySQL. See Section 5.6.2, “mysql_upgrade — Check Tables for MySQL Upgrade”.
-
The MySQL Instance Manager, a program for monitoring and managing MySQL servers. See Section 5.5, “mysqlmanager — The MySQL Instance Manager”.
There are several other programs that are run on the server host: