MySQL Manager Overview
MySQL (Structured Query Language) is an open-source relational database management system that is primarily used on Mac OS X Server as part of a dynamic Web site. The MySQL Manager tool is designed to set up and enable the MySQL service with the default settings. MySQL is complicated and is typically managed using command-line tools and text configuration files. However, free detailed documentation is available at [http://www.mysql.com/documentation/]. To enable MySQL:
1. | On your server, open the MySQL Manager tool by choosing /Applications/Server/MySQL Manager (Figure 2.89).
Figure 2.89. Open the MySQL Manager tool by choosing /Applications/Server/MySQL Manager.
[View full size image]
| 2. | Click the lock, and authenticate as an administrative user (Figure 2.90).
Figure 2.90. Click the lock, and authenticate as an administrative user.
| 3. | Click the Install button to install the default files needed for the MySQL service (Figure 2.91).
Figure 2.91. Click Install to install the default files needed for the MySQL service.
You must do this in order to enable the Start button. | 4. | Once the MySQL files are installed, click the Start button to start the MySQL service (Figure 2.92).
Figure 2.92. Click Start to start the MySQL service.
|
Tip Although doing so isn't required to use MySQL, installing the Mac OS X Xcode development tools is highly recommended. Xcode includes many of the tools used to build Web-based applications.
|
![[View full size image]](/image/library/english/13825_02fig089_alt.jpg;380139){kind=link}