[mythtv-users] database crash???

Mark Knecht markknecht at gmail.com
Sun May 29 22:56:16 UTC 2005


Hi,
   This afternoon no one can use mythfrontend. I've been messing
around trying to figure out what's going on my even from a terminal
I'm greeted with things like this:

mark at gandalf ~ $ mythfrontend
2005-05-29 15:45:48.446 New DB connection, total: 1
2005-05-29 15:45:48.448 Unable to connect to database!
2005-05-29 15:45:48.449 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user: 'mythtv at gandalf' (Using password: YES)

2005-05-29 15:45:48.450 Unable to connect to database!
2005-05-29 15:45:48.450 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user: 'mythtv at gandalf' (Using password: YES)

It seems that for some reason the database has stopped responding to
network logins?

mark at gandalf ~ $ mysql -u mythtv -p mythconverg
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 111 to server version: 4.0.24

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit
Bye
mark at gandalf ~ $ mysql -h 192.168.1.2 -u mythtv -p mythconverg
Enter password:
ERROR 1045: Access denied for user: 'mythtv at gandalf' (Using password: YES)
mark at gandalf ~ $


So, thinking that I could set up access over the network again I try
the command I think I used before but it no longer works:

mark at gandalf ~ $ mysql -u mythtv -p mythconverg
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 113 to server version: 4.0.24

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all on mythconverg.* to mythtv@"192.168.1.%" identified
by "mythtv";
ERROR 1044: Access denied for user: 'mythtv at localhost' to database
'mythconverg'mysql>

Where do I go from here? If I reinstall the initial database can I get
the existing nuv files into it later?

Thanks,
Mark


More information about the mythtv-users mailing list