mysql job start failed
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.
What is the actual question, or is this just a statement of something that was broken that you got to work?
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?
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/