<p>I believe that this mysql problem has been brought on by Ubuntu. I encountered it during an Ubuntu upgrade, although probably a year prior to your experience. And that's why I can't recall what solutions I tried; I think that I ended up uninstalling and re-installing mysql (both server and client).</p>
<p>In my case, I had 2 Ububtu systems that I was upgrading. You didn't say if your installs were fresh or if they had ever gone through the Ubuntu upgrade process. Suffice to say, I believed that my problems would not have occurred with a fresh install and I stopped upgrading Ubuntu after last years desktop changes.</p>
<div class="gmail_quote">On 18 Feb 2012 20:59, "Duncan Gillibrand" <<a href="mailto:duncang92@yahoo.com">duncang92@yahoo.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Cheers Bill.<br>
<br>
I checked apparmor and all looks same as yours in option 2.<br>
<br>
I do believe that all my issues are owner/permissions based although after I<br>
created a user mysql and changed ownership of files to be mysql then there<br>
was no way that I could get the database to run etc..<br>
<br>
I am confused as to owners and users of files between root, mysql and mythtv<br>
as to who should own what and what should be entered into files such as<br>
mysql.txt etc..<br>
<br>
Is there a good guide as to how to set this all upanywhere? I originally<br>
followed <a href="http://www.mythtv.org/wiki/User_Manual:Initial_Installation" target="_blank">http://www.mythtv.org/wiki/User_Manual:Initial_Installation</a> but had<br>
changed user to duncan vs. mythtv ... I think I remember that I could not<br>
access the database with the mysql -u duncan -p until I had changed the<br>
owners of the files to be Duncan.<br>
<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:mythtv-users-bounces@mythtv.org">mythtv-users-bounces@mythtv.org</a><br>
[mailto:<a href="mailto:mythtv-users-bounces@mythtv.org">mythtv-users-bounces@mythtv.org</a>] On Behalf Of Bill Meek<br>
Sent: Saturday, February 18, 2012 1:12 PM<br>
To: <a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
Subject: Re: [mythtv-users] Starting MythTV<br>
<br>
On 02/18/2012 11:28 AM, Duncan Gillibrand wrote:<br>
...<br>
<br>
Duncan;<br>
<br>
> Ubuntu 11.10<br>
<br>
Good, did you upgrade from an earlier release?<br>
<br>
> I've tried all of the suggestions and I'm still stuck.<br>
...<br>
<br>
I'm running the same version, keep using: sudo start mysql.<br>
FYI, the entry in /etc/init.d should be a symbolic link:<br>
<br>
mysql -> /lib/init/upstart-job<br>
<br>
I disagree with: user = duncan in my.cnf. At least in mine, user = mysql.<br>
<br>
All files under /var/lib/mysql should all be have both owner and group set<br>
to mysql.<br>
<br>
Just to save an email, go to /etc/apparmor.d and check this file:<br>
<br>
usr.sbin.mysqld<br>
<br>
Does it have two lines like:<br>
<br>
/var/run/mysqld/mysqld.pid w,<br>
/var/run/mysqld/mysqld.sock w,<br>
<br>
Or this:<br>
<br>
/{,var/}run/mysqld/mysqld.pid w,<br>
/{,var/}run/mysqld/mysqld.sock w,<br>
<br>
The 2nd version is correct.<br>
<br>
--<br>
Bill<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
</blockquote></div>