MySQL Manual- 1 General Information
- 2 MySQL Installation
- 3 Tutorial Introduction
- 4 Database Administration
- 4.1 Configuring MySQL
- 4.2 General Security Issues and the MySQL Access Privilege System
- 4.3 MySQL User Account Management
- 4.4 Disaster Prevention and Recovery
- 4.5 Database Administration Language Reference
- 4.6 MySQL Localisation and International Usage
- 4.7 MySQL Server-Side Scripts and Utilities
- 4.8 MySQL Client-Side Scripts and Utilities
- 4.9 The MySQL Log Files
- 4.10 Replication in MySQL
- 5 MySQL Optimisation
- 6 MySQL Language Reference
- 7 MySQL Table Types
- 8 National Character Sets and Unicode in MySQL 4.1
- 9 MySQL APIs
- 10 Error Handling in MySQL
- 11 Spatial Extensions in MySQL
- 12 Extending MySQL
- A Problems and Common Errors
- B Contributed Programs
- C Credits
- D MySQL Change History
- E Porting to Other Systems
- F Environment Variables
- G MySQL Regular Expressions
- H GNU General Public License
- I GNU Lesser General Public License
- SQL command, type and function index
- Concept Index
4 Database Administration
Subsections
- 4.1 Configuring MySQL
- 4.1.1
mysqldCommand-line Options - 4.1.2 `my.cnf' Option Files
- 4.1.3 Running Multiple MySQL Servers on the Same Machine
- 4.2 General Security Issues and the MySQL Access Privilege System
- 4.2.1 General Security Guidelines
- 4.2.2 How to Make MySQL Secure Against Crackers
- 4.2.3 Startup Options for
mysqldConcerning Security - 4.2.4 Security issues with
LOAD DATA LOCAL - 4.2.5 What the Privilege System Does
- 4.2.6 How the Privilege System Works
- 4.2.7 Privileges Provided by MySQL
- 4.2.8 Connecting to the MySQL Server
- 4.2.9 Access Control, Stage 1: Connection Verification
- 4.2.10 Access Control, Stage 2: Request Verification
- 4.2.11 Password Hashing in MySQL 4.1
- 4.2.13 Causes of
Access deniedErrors - 4.3 MySQL User Account Management
- 4.3.1
GRANTandREVOKESyntax - 4.3.2 MySQL User Names and Passwords
- 4.3.3 When Privilege Changes Take Effect
- 4.3.4 Setting Up the Initial MySQL Privileges
- 4.3.5 Adding New Users to MySQL
- 4.3.6 Limiting user resources
- 4.3.7 Setting Up Passwords
- 4.3.8 Keeping Your Password Secure
- 4.3.9 Using Secure Connections
- 4.4 Disaster Prevention and Recovery
- 4.4.1 Database Backups
- 4.4.2
BACKUP TABLESyntax - 4.4.3
RESTORE TABLESyntax - 4.4.4
CHECK TABLESyntax - 4.4.5
REPAIR TABLESyntax - 4.4.6 Using
myisamchkfor Table Maintenance and Crash Recovery - 4.4.6.1
myisamchkInvocation Syntax - 4.4.6.2 General Options for
myisamchk - 4.4.6.3 Check Options for
myisamchk - 4.4.6.4 Repair Options for myisamchk
- 4.4.6.5 Other Options for
myisamchk - 4.4.6.6
myisamchkMemory Usage - 4.4.6.7 Using
myisamchkfor Crash Recovery - 4.4.6.8 How to Check Tables for Errors
- 4.4.6.9 How to Repair Tables
- 4.4.6.10 Table Optimisation
- 4.4.7 Setting Up a Table Maintenance Regimen
- 4.4.8 Getting Information About a Table
- 4.5 Database Administration Language Reference
- 4.5.1
OPTIMIZE TABLESyntax - 4.5.2
ANALYZE TABLESyntax - 4.5.3
FLUSHSyntax - 4.5.4
RESETSyntax - 4.5.5
PURGE MASTER LOGSSyntax - 4.5.6
KILLSyntax - 4.5.7
SHOWSyntax - 4.5.7.1 Retrieving information about Database, Tables, Columns, and Indexes
- 4.5.7.2
SHOW TABLE STATUS - 4.5.7.3
SHOW STATUS - 4.5.7.4
SHOW VARIABLES - 4.5.7.5
SHOW [BDB] LOGS - 4.5.7.6
SHOW PROCESSLIST - 4.5.7.7
SHOW GRANTS - 4.5.7.8
SHOW CREATE TABLE - 4.5.7.9
SHOW WARNINGS | ERRORS - 4.5.7.10
SHOW TABLE TYPES - 4.5.7.11
SHOW PRIVILEGES - 4.6 MySQL Localisation and International Usage
- 4.6.1 The Character Set Used for Data and Sorting
- 4.6.2 Non-English Error Messages
- 4.6.3 Adding a New Character Set
- 4.6.4 The Character Definition Arrays
- 4.6.5 String Collating Support
- 4.6.6 Multi-byte Character Support
- 4.6.7 Problems With Character Sets
- 4.7 MySQL Server-Side Scripts and Utilities
- 4.7.1 Overview of the Server-Side Scripts and Utilities
- 4.7.2
mysqld_safe, The Wrapper Aroundmysqld - 4.7.3
mysqld_multi, A Program for Managing Multiple MySQL Servers - 4.7.4
myisampack, The MySQL Compressed Read-only Table Generator - 4.7.5
mysqld-max, An ExtendedmysqldServer - 4.8 MySQL Client-Side Scripts and Utilities
- 4.8.1 Overview of the Client-Side Scripts and Utilities
- 4.8.2
mysql, The Command-line Tool - 4.8.3
mysqladmin, Administrating a MySQL Server - 4.8.4
mysqlbinlog, Executing the queries from a binary log - 4.8.5 Using
mysqlcheckfor Table Maintenance and Crash Recovery - 4.8.6
mysqldump, Dumping Table Structure and Data - 4.8.7
mysqlhotcopy, Copying MySQL Databases and Tables - 4.8.8
mysqlimport, Importing Data from Text Files - 4.8.9
mysqlshow, Showing Databases, Tables, and Columns - 4.8.10
mysql_config, Get compile options for compiling clients - 4.8.11
perror, Explaining Error Codes - 4.8.12 How to Run SQL Commands from a Text File
- 4.9 The MySQL Log Files
- 4.9.1 The Error Log
- 4.9.2 The General Query Log
- 4.9.3 The Update Log
- 4.9.4 The Binary Log
- 4.9.5 The Slow Query Log
- 4.9.6 Log File Maintenance
- 4.10 Replication in MySQL
- 4.10.1 Introduction
- 4.10.2 Replication Implementation Overview
- 4.10.3 Replication Implementation Details
- 4.10.4 How To Set Up Replication
- 4.10.5 Replication Features and Known Problems
- 4.10.6 Replication Options in `my.cnf'
- 4.10.7 SQL Commands Related to Replication
- 4.10.7.1
START SLAVE(slave) - 4.10.7.2
STOP SLAVE(slave) - 4.10.7.3
SET SQL_LOG_BIN=0|1(master) - 4.10.7.4
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=n(slave) - 4.10.7.5
RESET MASTER(master) - 4.10.7.6
RESET SLAVE(slave) - 4.10.7.7
LOAD TABLE tblname FROM MASTER(slave) - 4.10.7.8
LOAD DATA FROM MASTER(slave) - 4.10.7.9
CHANGE MASTER TO master_def_list(slave) - 4.10.7.10
MASTER_POS_WAIT()(slave) - 4.10.7.11
SHOW MASTER STATUS(master) - 4.10.7.12
SHOW SLAVE HOSTS(master) - 4.10.7.13
SHOW SLAVE STATUS(slave) - 4.10.7.14
SHOW MASTER LOGS(master) - 4.10.7.15
SHOW BINLOG EVENTS(master) - 4.10.7.16
PURGE MASTER LOGS(master) - 4.10.8 Replication FAQ
- 4.10.9 Troubleshooting Replication
