MySQL创建数据库失败

4321pp · 发表于 2017-8-29 09:53:55

如果使用root账号登录到数据库create database时提错错误：

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

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

，一般是mysql用户没有目录权限的问题。

先用Linux指令 : ls -ld 查看data目录权限， data是存放数据文件的文件夹

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

如果显示：

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

则说明mysql用户没有操作权限，需要用chown指令授权：

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

at1358 · 发表于 2017-8-31 09:09:59

Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).

at1358 · 发表于 2017-8-31 09:10:09

Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).

at1358 · 发表于 2017-8-31 09:10:15

Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).

at1358 · 发表于 2017-8-31 09:10:26

Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).

at1358 · 发表于 2017-8-31 09:10:33

Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).Starting MySQL............. ERROR! The server quit without updating PID file (/home/shuicanjuOA/mysql/data/qwe123.pid).

账号		自动登录	找回密码
密码			立即注册

大疆运维招人啦，

C++ :try 语句块和异常处理

C++的多态

Red Hat RHCE 8 (EX294) Cert Guide

Java/C++ 区别：看完这一篇，就够用！

别再用过时库了！这 13 个顶级 C++ 库才是

c++ size_t 和 int 的区别

[经验分享] MySQL创建数据库失败

浏览过的版块

扫码加入运维网微信交流群