• Home
  • MySQL
  • PHP
  • Apache
  • About
  • Contact Us
 
 
 
  • MySQL 5.5 Reference Manual
  • MySQL 5.1 Reference Manual
  • MySQL 3.23/4.0/4.1 Manual
  • MySQL 4.0 Russian Manual


MySQL 5.5 Reference Manual :: 5 MySQL Server Administration
« 4.8.3 resolveip — Resolve Host name to IP Address or Vice Versa

5.1 The MySQL Server »
Section Navigation      [Toggle]
  • Preface, Notes, Licenses
  • 1 General Information
  • 2 Installing and Upgrading MySQL
  • 3 Tutorial
  • 4 MySQL Programs
  • 5 MySQL Server Administration
    • 5.1 The MySQL Server
    • 5.2 MySQL Server Logs
    • 5.3 General Security Issues
    • 5.4 The MySQL Access Privilege System
    • 5.5 MySQL User Account Management
    • 5.6 Running Multiple MySQL Servers on the Same Machine
    • 5.7 Tracing mysqld Using DTrace
  • 6 Backup and Recovery
  • 7 Optimization
  • 8 Language Structure
  • 9 Internationalization and Localization
  • 10 Data Types
  • 11 Functions and Operators
  • 12 SQL Statement Syntax
  • 13 Storage Engines
  • 14 High Availability and Scalability
  • 15 MySQL Enterprise Monitor
  • 16 Replication
  • 17 Partitioning
  • 18 Stored Programs and Views
  • 19 INFORMATION_SCHEMA Tables
  • 20 MySQL Performance Schema
  • 21 Connectors and APIs
  • 22 Extending MySQL
  • A MySQL 5.5 Frequently Asked Questions
  • B Errors, Error Codes, and Common Problems
  • C MySQL Change History
  • D Restrictions and Limits
  • Index
  • Standard Index
  • C Function Index
  • Command Index
  • Function Index
  • INFORMATION_SCHEMA Index
  • Transaction Isolation Level Index
  • JOIN Types Index
  • Operator Index
  • Option Index
  • Privileges Index
  • SQL Modes Index
  • Status Variable Index
  • Statement/Syntax Index
  • System Variable Index

Chapter 5. MySQL Server Administration

Table of Contents     [+/-]

5.1. The MySQL Server     [+/-]
5.1.1. Server Option and Variable Reference
5.1.2. Server Command Options
5.1.3. Server Options for Loading Plugins
5.1.4. Server System Variables
5.1.5. Using System Variables
5.1.6. Server Status Variables
5.1.7. Server SQL Modes
5.1.8. Server-Side Help
5.1.9. Server Response to Signals
5.1.10. The Shutdown Process
5.2. MySQL Server Logs     [+/-]
5.2.1. Selecting General Query and Slow Query Log Output Destinations
5.2.2. The Error Log
5.2.3. The General Query Log
5.2.4. The Binary Log
5.2.5. The Slow Query Log
5.2.6. Server Log Maintenance
5.3. General Security Issues     [+/-]
5.3.1. General Security Guidelines
5.3.2. Password Security in MySQL
5.3.3. Making MySQL Secure Against Attackers
5.3.4. Security-Related mysqld Options
5.3.5. Security Issues with LOAD DATA LOCAL
5.3.6. How to Run MySQL as a Normal User
5.4. The MySQL Access Privilege System     [+/-]
5.4.1. Privileges Provided by MySQL
5.4.2. Privilege System Grant Tables
5.4.3. Specifying Account Names
5.4.4. Access Control, Stage 1: Connection Verification
5.4.5. Access Control, Stage 2: Request Verification
5.4.6. When Privilege Changes Take Effect
5.4.7. Causes of Access-Denied Errors
5.5. MySQL User Account Management     [+/-]
5.5.1. User Names and Passwords
5.5.2. Adding User Accounts
5.5.3. Removing User Accounts
5.5.4. Setting Account Resource Limits
5.5.5. Assigning Account Passwords
5.5.6. Using SSL for Secure Connections
5.5.7. Connecting to MySQL Remotely from Windows with SSH
5.5.8. Auditing MySQL Account Activity
5.6. Running Multiple MySQL Servers on the Same Machine     [+/-]
5.6.1. Running Multiple Servers on Windows
5.6.2. Running Multiple Servers on Unix
5.6.3. Using Client Programs in a Multiple-Server Environment
5.7. Tracing mysqld Using DTrace     [+/-]
5.7.1. mysqld DTrace Probe Reference

MySQL Server (mysqld) is the main program that does most of the work in a MySQL installation. This section provides an overview of MySQL Server and covers topics that deal with administering a MySQL installation:

  • Server configuration

  • The server log files

  • Security issues and user-account management

  • Management of multiple servers on a single machine

Copyright © 1997, 2010, Oracle and/or its affiliates. All rights reserved. Legal Notices
Previous / Next / Up / Table of Contents

User Comments

Top / Previous / Next / Up / Table of Contents
Copyright © 2011, doc0.ru
All rights reserved