MythTV
 

Hello.........................im just finish install MythTV.............i already suply all dependencies for the rpm...........all of it. But when i try to run it i just get this message:
[dexter@dexter settings]$ mythtv
Unable to connect to database!
Driver error was [1/-1]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

couldn't open db

How can i solve this problem??????

did you set up mysql and then run mythfilldatabase?

oh... and before mythfilldatabase but after setting up mysql you have to run mythtvsetup

Myth TV......Im still stock
 

Whe i do ¨mythfilldatabase¨:

[root@dexter settings]# mythfilldatabase
Session management error: Authentication Rejected, reason : None of the authentication protocols specified are supported and host-based authentication failed
Unable to connect to database!
Driver error was [1/-1]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

couldn't open db
[root@dexter settings]#

----------------------------------------------------
When i do ¨mythtvsetup¨:

[root@dexter settings]# mythtvsetup
Session management error: Authentication Rejected, reason : None of the authentication protocols specified are supported and host-based authentication failed
Unable to connect to database!
Driver error was [1/-1]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Unable to open database:
Driver error was:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@dexter settings]#

I'm also getting this exact error. Has anything been resolved here at all?

there is clearly no sql database running...

First things first.
Is MySQL installed and running?

MySQL
 

After Installing MySQL you need to do the following...

chkconfig mysqlon
service mysqld start

Thanks,

Robert Liguori

I have the same problem!

[root@eugeny eugeny]# mythtv
Unable to connect to database!
Driver error was [1/-1]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user: 'mythtv@localhost' (Using password: YES)

couldn't open db


[root@eugeny eugeny]# chkconfig mysqlon
[root@eugeny eugeny]# service mysqld start
Cannot find mysqld service
Usage: service -[Rfshv] SERVICE ARGUMENTS
-f|--full-restart: Do a fullrestart of the service.
-R|--full-restart-all: Do a fullrestart of all services currently running.
-s|--status-all: Print a status of all services.
-d|--debug: Launch with debug.
-h|--help: This help.
-v|--version: Print version.

Not sure if thats a typo but it should be:


[root@eugeny eugeny]# chkconfig mysql on

and if it can not find the mysqld service that usually means you don't have mysql installed. See if you have the startup script in /etc/init.d and query your packages to see if you have mysql installed.

Yes I have the mysql file in /etc/init.d/ also I've checked the drakconf||system||DrakXservices and it shows that mysql is running and it is in "startup";
"chkconfig mysql on" and "chkconfig mysqlon" shows nothing(even after turning mysql off via drakconf);
I've installed MythTV, MySQL & other packages from rpms.
May be SQL needs additional configuration?

I solved it: i fogot to configure MySQL after installing mythbackend:

mysql -u root < /usr/share/doc/mythtv-0.12/database/mc.sql