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

Kris B. krisbee at krisbee.com
Tue Nov 8 02:22:45 UTC 2011


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


More information about the mythtv-users mailing list