Difference between revisions of "Database"

From MythTV Official Wiki
Jump to: navigation, search
(MythTV database)
m (Categorized)
Line 16: Line 16:
Try installing [http://www.phpmyadmin.net phpMyAdmin].
Try installing [http://www.phpmyadmin.net phpMyAdmin].

Revision as of 05:11, 17 October 2006

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.

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.