When starting mysql on Centos servers with a custom data directory you might get an error similar to the following:
2014-10-15 10:23:56 17081 [Warning] Can't create test file /database/mysql/localhost.lower-test
MySQL Error – Can’t Create Test File on CentOS
centosMySQL
Related Question
- Mysql Can’t create test file + 1067 Error
- Mysql – How to move a MySQL data directory to an external hard drive
- MongoDB – Error Starting on CentOS
- MySQL 5.7 doesn’t start after installation on CentOS 6.7
- MySQL Relay Log File Not Found Error – Changing Data Directory
- Thesql can’t start, can’t dump. Error: page 5 log sequence number
Best Answer
If your chmod and chown settings are already correct you might need to look into selinux.
This page explains how to configure selinux for mysql: https://blogs.oracle.com/jsmyth/entry/selinux_and_mysql