Arch Linux

If mysql shoudl use InnoDB tables, starting the daemon fails due to wrong preconfiguration in my.cnf.

mysqld will create folders and permissions for $MYSQLD_ROOT = "/var/lib/mysql".
my.cnf sets the datadir properly to /var/lib/mysql.
Otherwise, the innodb part in my.cnf tells innodb to store data in /usr/var - which is not prepared by the daemon: Mysqld fails to start. It would be straight to use /var/lib/mysql for InnoDB as well. This can simply be done by changing the preconfigured InnoDB-settings in my.cnf from:

# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /usr/var
innodb_data_file_path = /usr/var
innodb_log_group_home_dir = /usr/var
innodb_log_arch_dir = /usr/var

to

# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /var/lib/mysql
innodb_data_file_path = /var/lib/mysql
innodb_log_group_home_dir = /var/lib/mysql
innodb_log_arch_dir = /var/lib/mysql

It would be nice if you would change the my.cnf used by the mysql-package, and in this case a user really has just to "uncomment" those lines.

With kind regards

Ingo Huber