MySQL Administrator

Copyright 2004-2006 MySQL AB

This documentation is NOT distributed under a GPL license. Use of this documentation is subject to the following terms: You may create a printed copy of this documentation solely for your own personal use. Conversion to other formats is allowed as long as the actual content is not altered or edited in any way. You shall not publish or distribute this documentation in any form or on any media, except if you distribute the documentation in a manner similar to how MySQL disseminates it (that is, electronically for download on a Web site with the software) or on a CD-ROM or similar medium, provided however that the documentation is disseminated together with the software on the same medium. Any other use, such as any dissemination of printed copies or use of this documentation, in whole or in part, in another publication, requires the prior written consent from an authorized representative of MySQL AB. MySQL AB reserves any and all rights to this documentation not expressly granted above.

Please email for more information or if you are interested in doing a translation.

Abstract

This is the MySQL Administrator Manual.

Document generated on: 2006-11-10 (revision: 3902)


Table of Contents

1. Introduction to MySQL Administrator
2. Installation
2.1. Introduction
2.2. Installing Under Windows
2.2.1. Using the Windows Installer
2.2.2. Installing From the ZIP File
2.3. Installing Under Linux
2.3.1. Installing the Generic Tarball
2.3.2. RPM Installation
2.4. Installing Under Mac OS X
3. Removing MySQL GUI Tools
3.1. Uninstall – Windows
3.2. Uninstall – Linux
3.3. Uninstall – OS X
4. Running MySQL GUI Tools
4.1. Running Under Windows
4.2. Running Under Linux
4.3. Running On Mac OS X
5. Connection Dialog
5.1. Connection Dialog
5.2. Configure-service Mode
6. Main Window
6.1. Introduction
6.2. Sidebar
6.3. Working Area
6.4. Menus
6.4.1. File
6.4.2. Edit
6.4.3. View
6.4.4. Tools
6.4.5. Help
7. Server Information
8. Service Control
8.1. Introduction
8.2. Start/Stop Service
8.3. Configure Service
9. Startup Variables
9.1. Introduction
10. Server Connections
10.1. Introduction
10.2. Threads
10.3. User Connections
11. User Administration
11.1. Introduction
11.2. User Accounts
11.3. User Information
11.4. Global Privileges
11.5. Schema Privileges
11.6. Table Column Privileges
12. Health
12.1. Introduction
12.2. Connection Health
12.3. Memory Health
12.4. Creating Custom Health Graphs
12.5. Status Variables
12.6. System Variables
13. Server Logs
13.1. Introduction
13.2. Error Log
13.3. Slow Log
13.4. General Log
14. Backup
14.1. Introduction
14.2. Backup Project
14.3. Advanced Options
14.3.1. Backup Execution Method
14.3.2. Output File Options
14.4. Schedule
15. Restore
15.1. Introduction
15.2. The General Tab
15.3. Restore Content
16. Replication Status
16.1. Introduction
16.2. Configuring Replication Servers
16.3. Using the Replication Status Section
17. Catalogs
17.1. Introduction
17.2. Schema Tables
17.2.1. Table Status
17.2.2. Row Status
17.3. Schema Indexes
18. The MySQL Table Editor
18.1. Introduction
18.2. The Main Editor Window
18.3. The Columns And Indices Tab
18.3.1. The Column Editor
18.3.2. The Detail Area
18.4. The Table Options Tab
18.5. The Advanced Options Tab
18.5.1. The Various Section
18.5.2. The Row Options Section
18.5.3. The Storage Options Section
18.5.4. The Merge Table Options Section
18.5.5. The Table RAID Settings Section
18.6. Applying Your Changes
19. Options Dialog
19.1. Introduction
19.2. General Options
19.3. Connections
19.4. Editors
19.5. Administrator
19.5.1. User Administration
19.5.2. Health Graphs
19.5.3. Backup
A. The MySQL System Tray Monitor
B. Installing From Source
B.1. Introduction
B.2. Downloading The Source Code
B.3. Building from Source under Windows
B.3.1. Prerequisites
B.3.2. Compiling and Building
B.4. Building from Source under Linux
B.4.1. Prerequisites
B.5. Compiling and Building
B.5.1. Building Static Binaries
B.5.2. Building RPMs
C. Troubleshooting Application Errors
C.1. Troubleshooting Connection Errors
C.2. Troubleshooting Display Problems
D. How Connections Are Stored
E. XML Files Common to the MySQL GUI Applications
F. XML Files Used by MySQL Administrator
G. Notes for Translators
H. Third-party Software Used by the MySQL GUI Tools
H.1. PCRE Library
H.2. PNG Support

List of Figures

5.1. Connection dialog
5.2. Switching to configure-service mode
5.3. Configure-service mode
6.1. MySQL Administrator main window
6.2. Marked area between sidebar and working area
11.1. User accounts
11.2. User Information tab
12.1. The Graph Settings dialog
13.1. Displaying entries from the middle of the General Log
15.1. The Restore Content tab
16.1. The Replication Status section
18.1. The MySQL Table Editor
18.2. The column editor
18.3. The index editor
18.4. The Confirm Table Edit dialog
19.1. Options dialog
19.2. Options dialog: Connections
A.1. The MySQL System Tray Monitor
C.1. Error message dialog

List of Tables

B.1. Required Components
B.2. Requirements for MySQL Query Browser