[mythtv-users] DB restore

Eric Sharkey eric at lisaneric.org
Mon Feb 2 18:44:54 UTC 2015


On Mon, Feb 2, 2015 at 12:48 PM, Daryl McDonald <darylangela at gmail.com> wrote:
> What is the command to log into my database? A quick look found this: "mysql
> -u root mysql" but I want to be certain.

Most people name their MythTV database mythconverg so:

mysql mythconverg

is usually sufficient if logged in as root or:

mysql -u user mythconverg

if not, where "user" matches whatever user you use for database
access.  You'll typically have all the info you need (username,
password, database name) in ~/.mythtv/config.xml.

mysql is the command line tool for database access.  It includes an
interactive query editor command line which is launched for you
automatically.  You just type your query in and press enter.

Eric


More information about the mythtv-users mailing list