[mythtv-users] FC3 Mysql problems - PLEASE HELP ME...

Michael Cheshire (Mailing Lists) michael-mlists at cheshire.id.au
Sun Apr 10 00:47:05 UTC 2005


Craig,

You are not looking at directory permission problems, but permissions on the 
mysql database.

Try this :

mysql <enter>

you should see

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

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

type this at the mysql> prompt.

GRANT ALL PRIVILEGES ON *.* TO mythtv at localhost IDENTIFIED BY 'mythtv';

then :

flush privileges;

then :

\q

(to quit).

Now try it :)

M.
----- Original Message ----- 
From: "Craig Cooper" <craig.cooper at gmail.com>
To: "MythTV-Users" <mythtv-users at mythtv.org>
Sent: Sunday, April 10, 2005 9:39 AM
Subject: [mythtv-users] FC3 Mysql problems - PLEASE HELP ME...


> [mythtv at localhost craig]$ mythtvsetup
> Session management error: Authentication Rejected, reason : None of
> the authentication protocols specified are supported and host-based
> authentication failed
> 2005-04-10 10:05:11.670 Unable to connect to database!
> 2005-04-10 10:05:11.671 Driver error was [1/1045]:
> QMYSQL3: Unable to connect
> Database error was:
> Access denied for user: 'mythtv at localhost' (Using password: YES)
>
> couldn't open db
> 2005-04-10 10:05:11.671 Switching to square mode (blue)
> mythtv: could not connect to socket
> mythtv: No such file or directory
> lirc_init failed for mythtv, see preceding messages
> 2005-04-10 10:05:11.980 Joystick disabled.
> Segmentation fault
>
> Default rpms installed from FC3 dvd. Only difference is kernel was
> rebuilt to 2.6.11.2 out of necessity. If anyone can help me out here,
> I would appreciate it very much.
>
> PS. I have chmod 777 all directories I think are related to mysql...
>
> Cheers,
>
> CraigC
> _______________________________________________
> 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