I have created a script to automatically install MySQL 5.6 on Ubuntu Server 12.10 (64bit). From all the information I gather I created the following script (different functions that's why you see multiple $1, $2, ect):
apt-get install libaio1 -y groupadd mysql useradd -r -g $3 $1 # $1 = Download URL MySQL (http://www.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.10-debian6.0-x86_64.deb/from/http://cdn.mysql.com/) echo "-Starting mysql_install-" wget $1 -O mysql-5.6.10-debian6.0-x86_64.deb dpkg -i mysql-5.6.10-debian6.0-x86_64.deb rm mysql-5.6.10-debian6.0-x86_64.deb # $1 = MySQL root username # $2 = MySQL root password # $3 = MySQL group echo "-Starting mysql_config-" cp /opt/mysql/server-5.6/support-files/mysql.server /etc/init.d/mysql.server cp /opt/mysql/server-5.6/support-files/my-default.cnf /etc/my.cnf cp /opt/mysql/server-5.6/support-files/mysql-log-rotate /etc/logrotate.d/mysql.server chmod +x /etc/init.d/mysql.server update-rc.d mysql.server defaults chown -R mysql /opt/mysql/server-5.6/ chgrp -R mysql /opt/mysql/server-5.6/ sed -i "s/^# basedir[[:blank:]]*=.*/basedir = \/opt\/mysql\/server-5.6/" /etc/my.cnf sed -i "s/^# port[[:blank:]]*=.*/port = 3360/" /etc/my.cnf echo -e "lc-messages-dir = /opt/mysql/server-5.6/share" >> /etc/my.cnf echo 'export PATH=$PATH:/opt/mysql/server-5.6/bin' | sudo tee /etc/profile.d/mysql.server.sh
So far so good, but when I try to start MySQL server with:
service mysql.server start
The following error message appears:
Starting MySQL . * The server quit without updating PID file (/opt/mysql/server-5.6/data/Playfair01.pid).
The directory were the PID file is stored did not exist. I created this directory and tried chrowning this folder without success:
chown mysql:mysql /opt/mysql/server-5.6/data
I have tried deleting temp files, PID files and lock file without success. Is there anyone how had this similar issue and solved it? Or if someone has ideas how to fix this please share this information with me.
Many thanks, Raoul