Centos里MySQL抛 Create writable for user 'mysql'

发布于 2018-11-06 | 作者: aerchi | 来源: blog.csdn.net | 转载于: blog.csdn.net

如题,Centos下的MySQL配置过 /etc/my.cnf 后,
service mysqld start 启动时抛:
Starting MySQL.2018-06-25T01:34:24.931194Z mysqld_safe error: log-error set to '/usr/local/mysql/logs/mysqld.log', however file don't exists. Create writable for user 'mysql'.

解决方法:

[root@aerchi.com ~]#  cd/usr/local/mysql

[root@aerchi.com mysql]# mkdir logs 

[root@aerchi.com mysql]#  echo "" > /usr/local/mysql/logs/mysqld.log
[root@aerchi.com mysql]#  chown -R mysql:mysql /usr/local/mysql/logs/mysqld.log
[root@aerchi.com mysql]#  service mysqld start
Starting MySQL...                                          [ OK ]
---------------------