[mythtv-users] Starting MythTV

[R. G. Newbury]

On 02/18/2012 09:21 PM, Bill Meek wrote:
> On 02/18/2012 06:09 PM, Duncan Gillibrand wrote:
>
> Duncan;
>
>> I want to watch the hockey.
> 1st things 1st;)
>
> Do all the files in /var/lib/mysql have owner and group = mysql?
>
>     sudo ls -lAR /var/lib/mysql
>
> Note that in the mysql.conf file in /etc/init, if the /var/run/mysqld
> directory exists, it won't be created with the proper user and group,
> so if you've already done the steps in your 1st post, then when you
> correct the user to mysql, mysqld won't be able to write to that directory.
>
> So, remove the directory then sudo start mysql, or just reboot.

If you can get access to a Fedora installation prior to Fedora 16, and 
get a copy of the /etc/rc.d/init.d/mysqld file, which starts the mysqld 
daemon in Fedora, you will see that 'service mysqld start' checks the 
various folders that mysql uses, for the proper permissions, and re-sets 
them to be sure that they are correct. It  runs mysqladmin and 
mysql_install_db to ensure that the mysql database exists. It does all 
that as user 'mysql'. All of the ownerships for the various 
files/folders are mysql:mysql and the service will fail if that it not 
so. Haven't been following the thread but it seems that this may be the 
problem.
Make sure you have a user mysql and group mysql. Use chown liberally.
You need at least these directories:
(From the mysql fedora service script)
get_mysql_option mysqld datadir "/var/lib/mysql"
datadir="$result"
get_mysql_option mysqld socket "$datadir/mysql.sock"
socketfile="$result"
get_mysql_option mysqld_safe log-error "/var/log/mysqld.log"
errlogfile="$result"
get_mysql_option mysqld_safe pid-file "/var/run/mysqld/mysqld.pid"
mypidfile="$result"

It seems you are floundering in the dark. The tutorial here:

http://www.howtogeek.com/howto/ubuntu/install-mysql-server-5-on-ubuntu/

looks to be well written and complete.

Until you have mysql is up and running, you should not even *think* 
about worrying about getting myth running.. seriously.

Geoff











--