[mythtv-users] My MySql hell :-)

Dave squilla.dave at gmail.com
Fri Mar 9 20:28:35 UTC 2007


Hi Damian
I'm using Ubuntu Feisty.
I had just this problem yesterday when I switched from wired to
wireless connection with dhcp - the host ip# changed and thus borked
my set up :-/
I get the same error if I do not specify "-p" when conencting as root to mysql

What happens if you use "mysql -uroot -p<password> mythconverg"

Are you restarting mysql after changes? (not sure if it makes a
difference but I always do)
Don't start over.
It's just mysql listenenign on one ip# and myth looking on another.
I
've been using phpMyAdmin for setting mysql privileges - I recommend it.
Unfortunately I don't know which setting I twaeked in phpMyAdmin but I
got ity after an hour :-). Don't give up

Cheers
Dave
On 09/03/07, Damian Surr <damian at gingermagic.co.uk> wrote:
>
>  Hello all,
>
>  I've been here before, somehow got past it, now I'm here again.
>
>  I'm running Ubuntu and have followed this guide:
>
> https://help.ubuntu.com/community/MythTV_Edgy_Backend_Frontend_Desktop
>
>  I did this a couple of weeks ago, then got stuck. Intended to come straight
> back to it, but family and work life have been hectic. Anyway, I'm back to
> it now.
>
>  All seems to go fine until I get to running mythtv-setup, where it seems I
> can't connect to any database. I'm having this problem whether I log into
> Ubuntu as 'mythtv' or my own user account. Here's the output from
> mythtv-setup:
>
>  SELECT NULL;
>  No error type from QSqlError?  Strange...
>  2007-03-09 19:25:42.847 Database not open while trying to load setting:
>  GuiResolution
>  2007-03-09 19:25:42.979 Unable to connect to database!
>  2007-03-09 19:25:42.980 Driver error was [1/1045]:
>  QMYSQL3: Unable to connect
>  Database error was:
>  Access denied for user 'mythtv'@'192.168.0.2' (using password: YES)
>
>  QSqlQuery::exec: database not open
>  QSqlQuery::exec: database not open
>  2007-03-09 19:25:43.071 DB Error (KickDatabase):
>  Query was:
>  SELECT NULL;
>  No error type from QSqlError?  Strange...
>  2007-03-09 19:25:43.131 Database not open while trying to load setting:
>  GuiWidth
>  2007-03-09 19:25:43.192 Unable to connect to database!
>  2007-03-09 19:25:43.192 Driver error was [1/1045]:
>  QMYSQL3: Unable to connect
>  Database error was:
>  Access denied for user 'mythtv'@'192.168.0.2' (using password: YES)
>
>  QSqlQuery::exec: database not open
>  QSqlQuery::exec: database not open
>  2007-03-09 19:25:43.303 DB Error (KickDatabase):
>  Query was:
>  SELECT NULL;
>  No error type from QSqlError?  Strange...
>  2007-03-09 19:25:43.355 Database not open while trying to load setting:
>  GuiHeight
>  2007-03-09 19:25:43.832 Unable to connect to database!
>  2007-03-09 19:25:43.832 Driver error was [1/1045]:
>  QMYSQL3: Unable to connect
>  Database error was:
>  Access denied for user 'mythtv'@'192.168.0.2' (using password: YES)
>
>  etc etc
>  there's loads of this.
>
>  Here's what I've checked:
>  /home/'myuser'/.mythtv/mysql.txt contains:
>  DBHostName=192.168.0.2
>  DBUserName=mythtv
>  DBPassword=mythtv
>  DBName=mythconverg
>  DBType=QMYSQL3
>
>  /home/mythtv/.mythtv/mysql.txt contains:
>  DBHostName=192.168.0.2
>  DBUserName=mythtv
>  DBPassword=mythtv
>  DBName=mythconverg
>  DBType=QMYSQL3
>
>  /etc/mythtv/mysql.txt contains:
>  DBHostName=localhost
>  DBUserName=mythtv
>  DBName=mythconverg
>  DBPassword=mythtv
>
>  although
>  /etc/mythtv/mysql.txt~ contains:
>  DBHostName=localhost
>  DBUserName=mythtv
>  DBName=mythconverg
>  DBPassword=
>  but I assume that's an older unused file.
>
>  The password when I go into mythtv-setup (after all the errors) is set to
>  mythtv.
>
>  I've just changed /etc/mythtv/mysql.txt to say DBHostName=192.168.0.2, but
> myhtv-setup is still giving me the same problems.
>
>  $ mysql -u root mysql
>  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
>  password: NO)
>
>  but
>
>  $ mysql -u mythtv -p mythconverg
>  Enter password: <mythtv>
>  Welcome to the MySQL monitor.  Commands end with ; or \g.
>  Your MySQL connection id is 132 to server version: 5.0.24a-Debian_9-log
>
>  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
>  mysql>
>
>  What should I do now? Should I try to remove things entirely and start yet
> again? I wouldn't mind doing that if I thought things would be different
> next time, but this is the second time I've been here.
>
>  Please help. I just want a media centre :-)
>
>  Damian
>
>
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>


More information about the mythtv-users mailing list