mysql job start failed

asked 2014-09-16 09:52:21 -0500

Robert gravatar image

I am want to install mysql with these instructions: http://docs.openstack.org/icehouse/in...

I came to eddit /etc/mysql/my.cnf:

[mysqld]
bind-address = 192.168.200.25 //my IP address
default-storage-engine = innodb
innodb_file_per_table
collation-server = utf8_general_ci
init-connect = 'SET NAMES utf8'
character-set-server = utf8

after that I do:

service mysql restart

and I get error:

mysql job start failed

Affter that I reinstall mysql:

apt-get purge mysql-server-5.1 mysql-common
apt-get install mysql-server

And once again I eddit /etc/mysql/my.cnf:

[mysqld]
bind-address = 192.168.200.25 //my IP address
default-storage-engine = innodb
innodb_file_per_table
collation-server = utf8_general_ci
init-connect = 'SET NAMES utf8'
character-set-server = utf8

and then aftere restaring service mysql it works.

edit retag flag offensive close merge delete

Comments

What is the actual question, or is this just a statement of something that was broken that you got to work?

mpetason gravatar imagempetason ( 2014-09-16 12:36:21 -0500 )edit

The actual question is: Why does service mysql work after reinstalling it and once again configuring my.cnf file? What could be reason for this, what can cause this?

Robert gravatar imageRobert ( 2014-09-16 14:37:29 -0500 )edit

You'll have to look in the mysql logs to see if it has information about why the service failed to start. /var/log/mysql/

mpetason gravatar imagempetason ( 2014-09-16 14:40:40 -0500 )edit