Difference between revisions of "MySQL For Myth on Mac OS X"

From MythTV Official Wiki
Jump to: navigation, search
(fix double title)
(MySQL Server Startup Details: describe)
Line 15: Line 15:
 
===== MySQL Server Startup Details =====
 
===== MySQL Server Startup Details =====
  
The MySQL distribution can [http://dev.mysql.com/doc/refman/5.1/en/mac-os-x-installation.html set itself] to start automatically on boot by creating a startup item <code>/Library/StartupItems/MySQLCOM</code> and setting a value in <code>/etc/hostconfig</code>. You enable it if you install the '''MySQLStartupItem.pkg''' included in the MySQL distribution's disk image. 
+
The MySQL distribution can [http://dev.mysql.com/doc/refman/5.1/en/mac-os-x-installation.html set itself] to start automatically on boot.  You enable it if you install the '''MySQLStartupItem.pkg''' included in the MySQL distribution's disk image.
 +
 
 +
For the curious, all this package does is create a startup item <code>/Library/StartupItems/MySQLCOM</code> and set a value in <code>/etc/hostconfig</code>.
  
 
 
==== Server Startup ====
 
==== Server Startup ====
 
After installation, the MySQL server needs to be started.  To start MySQL manually you can use the command line invocation <code>/usr/local/bin/mysql/bin/mysqld</code>.  Rebooting will also cause the server to start.
 
After installation, the MySQL server needs to be started.  To start MySQL manually you can use the command line invocation <code>/usr/local/bin/mysql/bin/mysqld</code>.  Rebooting will also cause the server to start.

Revision as of 21:38, 30 March 2012

The MySQL database server is used by the backend to track your DVR configuration and the shows it has recorded. It can be run one of two ways

  • As a slave process to a user login
  • As a server process

If your DVR only has one user account can simply set that account to login automatically. If you have multiple user accounts, however, you may want to ensure the process does not depend on any particular user account being logged in.

This document details how to set the database server as a server process, which will run regardless of user logins.

Preference Pane

It is not necessary to install MySQL.prefPane. You can ignore all preference pane related instructions in the backend setup guide for OSX.


MySQL Server Startup Details

The MySQL distribution can set itself to start automatically on boot. You enable it if you install the MySQLStartupItem.pkg included in the MySQL distribution's disk image.

For the curious, all this package does is create a startup item /Library/StartupItems/MySQLCOM and set a value in /etc/hostconfig.

Server Startup

After installation, the MySQL server needs to be started. To start MySQL manually you can use the command line invocation /usr/local/bin/mysql/bin/mysqld. Rebooting will also cause the server to start.