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

[Bill Meek]

On 11/04/2011 09:58 PM, Damian wrote:
...
> sudo service mysql status
>
> which returned:
>
> mysql start/post-start, process 4732
> 	post-start process 4733
>
> What on earth does that mean?
...

Hi;

See /etc/init/mysql.conf, the post-start script (its the last one.)

This should last 30 seconds at most and starts by doing:

   sudo /usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping

which returns (on a working system:)

   mysqld is alive

You can do it from the command line to see the result on your machine.



In your next post, you mentioned using:

   sudo rm -rf /var/lib/mysql to remove mysql's settings.

Just in case you don't know, that would also rip out your (hopefully)
existing mythconverg database!

You can see if its there:

   sudo -i
   cd /var/lib/mysql/mythconverg
   ls -l
   ls -l | wc -l
   exit

Expect to see over 300 files if the MythTV database is there.

-- 
Bill