MySQL failed to create database

If you log in to the database by using the root account, error is raised:

Mysql:1006-can ' t CREATE database ' * * * ' (ERRNO:13)
Or

Mysql:1006-can ' t CREATE database ' * * * ' (errno:28)

, which is generally a problem with MySQL users without directory permissions.

Start with the Linux command: LS-LD View the Data directory permissions, the file is the folder

Ls-ld/alidata/server/mysql-5.5.37/data

If displayed:

Drwxr-xr-x 6 root root 4096 Dec 08:57/alidata/server/mysql-5.5.37/data

The MySQL user does not have permission to operate and needs to be authorized with the Chown directive:

Chown-r Mysql:mysql/alidata/server/mysql-5.5.37/data

This article is from the "Blue Leaf Sheep" blog, please be sure to keep this source http://dellinger.blog.51cto.com/12445009/1930767

MySQL failed to create database