[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