[求助]mysql启动：Failed to create file(file: './auto.cnf', errno 13)_MySQL, Oracle及数据库讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛

总帖数

每页帖数

1/1页

返回列表

发起投票

查看: 4000 | 回复: 0

主题： [求助]mysql启动：Failed to create file(file: './auto.cnf', errno 13)

dream0110

注册用户

等级：中士
经验：242
发帖：87
精华：0
注册：2012-2-15
状态：离线
发送短消息息给dream0110

加好友发送短消息息给dream0110

发消息

发表于：

2015-1-7 15:11:08 | [全部帖] [楼主帖]

楼主

我的MySql版本是Server version: 5.6.16 Source distribution，
使用 “service mysql.server start ”启动mysql总是失败，

错误日志有如下信息：

2014-07-03 19:46:50 4095 [Note] InnoDB: 128 rollback segment(s) are active.
2014-07-03 19:46:50 4095 [Note] InnoDB: Waiting for purge to start
2014-07-03 19:46:50 4095 [Note] InnoDB: 5.6.16 started; log sequence number 1626173
2014-07-03 19:46:50 4095 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: b8821c78-02a7-11e4-9981-000c29711563.
/usr/local/mysql/bin/mysqld: File './auto.cnf' not found (Errcode: 13 - Permission denied)
2014-07-03 19:46:50 4095 [ERROR] Failed to create file(file: './auto.cnf', errno 13)
2014-07-03 19:46:50 4095 [ERROR] Initialzation of the server's UUID failed because it could not be read from the auto.cnf file. If this is a new server, the initialization failed because it was not possible to generate a new UUID.
2014-07-03 19:46:50 4095 [ERROR] Aborting
2014-07-03 19:46:50 4095 [Note] Binlog end
2014-07-03 19:46:50 4095 [Note] Shutting down plugin 'partition'
2014-07-03 19:46:50 4095 [Note] Shutting down plugin 'ARCHIVE'
2014-07-03 19:46:50 4095 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'

服务启动方式配置过程如下
1）cp /usr/local/mysql/support-files/mysql.server /etc/init.d/
2）chkconfig --add mysql.server
3）启动mysql服务器:service mysql.server {start|stop|restart|reload|force-reload|status}

注：如下2种启动方式正常：

./mysqld --defaults-file=/etc/my.cnf --user=root
./mysqld_safe --defaults-file=/etc/my.cnf --user=root &

有人遇到过这种情况么？求大神指教。

--转自