Database

From MythTV Official Wiki
Revision as of 15:48, 30 November 2006 by Iann (talk | contribs) (Added note)

Jump to: navigation, search

MythTV database

MythTV uses a MySQL relational database to manage almost all aspects of configuration and day-to-day operation. Mythfrontend, mythbackend, mythfilldatabase, MythTV plugins and ancillary programs all interact with the database and use it to store settings and information.

By default, the database is named mythconverg and contains a set of tables that interact with one-another.

Note that when running multiple frontends and/or backends, only one database is required.

Command line interface

Use the mysql command on the host running the database:

% mysql -u mythtv -pmythtv mythconverg

SQL commands can be issued at the mysql> prompt.

Web Interface

Try installing phpMyAdmin.