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

From MythTV Official Wiki
Jump to: navigation, search
(Initial version, split off from main myth on osx page)
 
(fix double title)
Line 1: Line 1:
= MySQL Server Configuration on OSX =
 
  
 
The MySQL database server is used by [[Mythbackend|the backend]] to track your DVR configuration and the shows it has recorded.  It can be run one of two ways
 
The MySQL database server is used by [[Mythbackend|the backend]] to track your DVR configuration and the shows it has recorded.  It can be run one of two ways

Revision as of 21:37, 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 by creating a startup item /Library/StartupItems/MySQLCOM and setting a value in /etc/hostconfig. You enable it if you install the MySQLStartupItem.pkg included in the MySQL distribution's disk image.


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.