HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlMinor

mysql "can't create test file" error on Centos

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
canfileerrorcentoscreatemysqltest

Problem

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

Solution

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

Context

StackExchange Database Administrators Q#80232, answer score: 4

Revisions (0)

No revisions yet.