mysql ended
just did an install of redhat fedora core 2, including mysql.
when attempting to start mysql with safe_mysqld &, I was getting a message mysql ended. Attempting to open mysql was then resulting in the message: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ .
I’ve had this before and I know it is related to permsions – the mysql user (created during install) needs to be able to write to /var/lib/mysql/. So I did the following:-
# chmod -R 755 /var/lib/mysql
# chown -R mysql /var/lib/mysql
# chgrp -R mysql /var/lib/mysql
(apparently this might be overkill but this was only for a server on local network)
I also did this:-
# mysql_install_db
(not sure what order or whether I needed to!)
It still wasn’t working so checked error log /var/log/mysqld.log
There was a problem with InnoDB (not sure what that even is, sure i’ll find out soon enough…), followed intructions in error log to resolve, which involved adding a line to /etc/my.cnf under the mysqld section:-
innodb_data_file_path = ibdata1:10M:autoextend
(the alternative is skip-innodb if "you do not want to use transactional InnoDB tables"
still didn’t work, repeated some of earlier steps, then it started OK 🙂