Specifications
Viewing MySQL Service and Admin Logs
MySQL service keeps two types of logs:
 The MySQL service log, which records the time of events such as when MySQL
service is started and stopped.
 The MySQL admin log, which records information such as when clients connect
or disconnect and each SQL statement received from clients. This log is located at
/Library/Logs/MySQL.log.
You can view MySQL service logs using Server Admin.
To view MySQL service logs:
1 Open Server Admin and connect to the server.
2 Click the triangle at the left of the server.
The list of services appears.
3 From the expanded Servers list, click MySQL.
4 Click Logs.
Use the Filter eld to search for specic entries.
Stopping MySQL Service
You can use Server Admin to stop MySQL service.
To stop MySQL service:
1 Open Server Admin and connect to the server.
2 Click the triangle at the left of the server.
The list of services appears.
3 From the expanded Servers list, select MySQL.
4 Click Stop MySQL (below the Servers list).
Upgrading MySQL
Mac OS X Server v10.6 includes the latest version of MySQL, v5.0. Because it’s
preinstalled, you won’t nd it in /usr/local/mysql. Instead, its elements are distributed
in the le system according to standard UNIX le layout as follows:
MySQL executables are located in the /usr/sbin/ and /usr/bin/ folders. Â
MySQL man pages are located in the /usr/share/man/ folder. Â
Other MySQL parts are located in the /usr/share/mysql/ folder. Â
When installed, the MySQL database resides in the /var/mysql/ folder.
70 Chapter 5 Working with Open Source Applications