Shulou(Shulou.com)06/01 Report--

If you log in to the database create database using the root account, there is an error:

MySQL: 1006-Can't create database'* *'(errno: 13)

Or

MySQL: 1006-Can't create database'* *'(errno: 28)

Generally, the problem is that mysql users do not have directory permissions

First, use the Linux directive: ls-ld to check the permissions of the data directory. Data is the folder where the data files are stored.

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

If the display:

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

It means that the mysql user does not have the permission to operate and needs to be authorized with the chown instruction:

Chown-R mysql:mysql / alidata/server/mysql-5.5.37/data

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.