[mythtv-users] Upgraded the Ubuntu 11.10 and not Myth, can't connect to MySQL

[Damian]

On 08/11/2011 12:00, mythtv-users-request at mythtv.org wrote:
> Date: Mon, 07 Nov 2011 21:22:45 -0500 From: "Kris B." 
> <krisbee at krisbee.com> Subject: Re: [mythtv-users] Upgraded the Ubuntu 
> 11.10 and not Myth can't connect to MySQL To: myth at surr.co.uk, 
> "Discussion about MythTV" <mythtv-users at mythtv.org> Message-ID: 
> <1320718965.16159.140660996001845 at webmail.messagingengine.com> 
> Content-Type: text/plain; charset="us-ascii" On Tuesday, November 08, 
> 2011 12:08 AM, "Damian" <myth at surr.co.uk> wrote:
>> >  damian at MythBox:/var/log/mysql$ sudo service mysql stop
>> >  mysql stop/waiting
>> >  damian at MythBox:/var/log/mysql$ sudo service mysql start
>> >  
>> >  
>> >  This again just left a blinking cursor, so I opened up another terminal
>> >  and did the following:
>> >  
>> >  damian at MythBox:~$ cd /var/log/mysql
>> >  damian at MythBox:/var/log/mysql$ ls
>> >  error.log
>> >  damian at MythBox:/var/log/mysql$ ps ax |grep -i mysql
>> >     3411 pts/1    S+     0:00 sudo service mysql start
>> >     3412 pts/1    S+     0:00 start mysql
>> >     3985 pts/2    S+     0:00 grep -i mysql
>> >  damian at MythBox:/var/log/mysql$ cat /var/log/mysql/*.log
>> >  111107 20:51:09 [Note] Plugin 'FEDERATED' is disabled.
>> >  111107 20:51:09  InnoDB: Initializing buffer pool, size = 8.0M
>> >  111107 20:51:09  InnoDB: Completed initialization of buffer pool
>> >  111107 20:51:10  InnoDB: Started; log sequence number 0 20263543
>> >  111107 20:51:10 [ERROR] Can't start server : Bind on unix socket:
>> >  Permission denied
>> >  111107 20:51:10 [ERROR] Do you already have another mysqld server
>> >  running on socket: /var/run/mysqld/mysqld.sock ?
>> >  111107 20:51:10 [ERROR] Aborting
>> >  
>> >  111107 20:51:10  InnoDB: Starting shutdown...
>> >  111107 20:51:15  InnoDB: Shutdown completed; log sequence number 0
>> >  20263543
>> >  111107 20:51:15 [Note] /usr/sbin/mysqld: Shutdown complete
>> >  
>> >  111107 20:51:40 [Note] Plugin 'FEDERATED' is disabled.
>> >  111107 20:51:40  InnoDB: Initializing buffer pool, size = 8.0M
>> >  111107 20:51:40  InnoDB: Completed initialization of buffer pool
>> >  111107 20:51:40  InnoDB: Started; log sequence number 0 20263543
>> >  111107 20:51:40 [ERROR] Can't start server : Bind on unix socket:
>> >  Permission denied
>> >  111107 20:51:40 [ERROR] Do you already have another mysqld server
>> >  running on socket: /var/run/mysqld/mysqld.sock ?
>> >  111107 20:51:40 [ERROR] Aborting
>> >  
>> >  111107 20:51:40  InnoDB: Starting shutdown...
>> >  111107 20:51:45  InnoDB: Shutdown completed; log sequence number 0
>> >  20263543
>> >  111107 20:51:45 [Note] /usr/sbin/mysqld: Shutdown complete
>> >  
>> >  etc etc ....
>> >  
>> >  Any clue for where to go next??
>> >  
>> >  Damian
>> >  _______________________________________________
>> >  mythtv-users mailing list
>> >  mythtv-users at mythtv.org
>> >  http://www.mythtv.org/mailman/listinfo/mythtv-users
>> >  
> Damian, you seem to run mysql and not mysqld and often flip between the
> two.  You want to be running the Daemon, mysqld.  So your attempts at
> running sudo service mysql start isn't correct, it should be sudo
> service mysqld start.
>
> But to be honest, have you thought about wiping out everything and just
> starting again?  Or rolling back to your older mythbuntu at this point?
> It seems all of your directories are borked at this point.  Also, you
> keep getting this permission denied things because you are looking at
> privledged areas without switching to root.  When you look at those logs
> and things, just sudo su, then start looking so you can actually see
> what is going on, and not just skip over when you are denied.
>
>
> -- Kris B. krisbee at krisbee.com

Hi Kris,

Bill seems to think that the 'mysql' command is ok. Maybe that's a 
peculiarity of a MythBuntu setup?

I don't think I can bring myself to wipe the OS and install afresh at 
the moment. If this carries on much longer, the family is probably going 
to campaign for a windows media centre replacement or some hardware box 
or other. If I can't get this fixed I've not got much of an argument!

Thanks for everyone's help so far.

Cheers
Damian