Server Admin 10.4 Help

MySQL

MySQL provides a relational database management solution for your web server. With this open source software, you can link data in different tables or databases and provide the information on your website.

The MySQL Manager application simplifies setting up the MySQL database on Mac OS X Server. You can use MySQL Manager to initialize the MySQL database, and to start and stop the MySQL service. MySQL Manager is located in /Applications/Server. You use it to install required files (the first time you use the application), turn on MySQL service, enter a root password, and allow network connections. The first time you run MySQL manager, you may need to unlock it and supply an administrator password before making changes.

MySQL is preinstalled on Mac OS X Server, with its various files already in the appropriate locations. At some point you may wish to upgrade to a newer version of MySQL. You can install the new version in /usr/local/mysql, but MySQL Manager will not be aware of the new version of MySQL and will continue to control the pre-installed version. If you do install a newer version of MySQL, use MySQL Manager to stop the preinstalled version, then start the newer version via the config file.