Friday, 9 August 2013

12.04 - MySql won't start by using service mysql start

12.04 - MySql won't start by using service mysql start

The only way I was able to get MySql to start was to issue:
mysqld
When I issued this command, it started rolling back some database
transactions that were conflicted. I have tried issuing
service mysql stop
and all I get is
Unknown instance:
The output of 'ls -l /etc/init.d/mysql' is:
lrwxrwxrwx 1 root root 21 Apr 9 03:45 /etc/init.d/mysql ->
/lib/init/upstart-job
The output of cat /etc/init/mysql.conf is:
# MySQL Service
description "MySQL Server"
author "Mario Limonciello <superm1@ubuntu.com>"
start on runlevel [2345]
stop on starting rc RUNLEVEL=[016]
respawn
respawn limit 2 5
env HOME=/etc/mysql
umask 007
# The default of 5 seconds is too low for mysql which needs to flush buffers
kill timeout 300
pre-start script
#Sanity checks
[ -r $HOME/my.cnf ]
[ -d /var/run/mysqld ] || install -m 755 -o mysql -g root -d
/var/run/mysqld
/lib/init/apparmor-profile-load usr.sbin.mysqld
LC_ALL=C BLOCKSIZE= df --portability /var/lib/mysql/. | tail -n 1 |
awk '{ exit ($4<4096) }'
end script
exec /usr/sbin/mysqld
post-start script
for i in `seq 1 30` ; do
/usr/bin/mysqladmin --defaults-file="${HOME}"/debian.cnf ping && {
exec "${HOME}"/debian-start
# should not reach this line
exit 2
}
statusnow=`status`
if echo $statusnow | grep -q 'stop/' ; then
exit 0
elif echo $statusnow | grep -q 'respawn/' ; then
exit 1
fi
sleep 1
done
exit 1
end script
Now when I try to upload anything to WordPress I get a HTTP 500 error. I
am assuming this is because MySQL is running under a different user. Any
thoughts on how to get this working again?
Was suggested to post here from this post in stackoverflow

No comments:

Post a Comment