1. /etc/my.cnfçé»è®¤é
ç½®
é
ç½®æ件çå
容å¦ä¸ï¼
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
ç±äºé¡¹ç®éè¦éè¦ä¿®æ¹datadirçå¼ï¼å¦ä¸
datadir=/usr/local/project/etc/data
å¨CentOSä¸å¯å¨MySQLï¼
[wzhwho@local~]#service mysqld start
Starting mysqld daemon [FAILED]
2. å
çé误æ¥å¿
éç¨rpmå®è£
çMySQLæ¥å¿æ件çé»è®¤è·¯å¾æ¯/var/log/mysqld.log
mysqld started
InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /usr/local/project/etc/data/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
mysqld ended
ä»æ¥å¿å¯ä»¥ç¥éï¼mysqlçæ°æ®æ件ç®å½æ²¡ææéï¼æ以æéè¦æç
§/var/lib/mysqlç®å½çæéç»/usr/local/project/etc/dataç®å½è®¾ç½®æéåå±ä¸»ã
[wzhwho@local~]#ll /var/lib
drwxr-x-r-x 1 mysql mysql 4 Apr 11 2009 mysql
[wzhwho@local~]#ll /var/lib
[wzhwho@local~]chown -R mysql:mysql /usr/local/project/etc/data
[wzhwho@local~]chmod -R 755 /usr/local/project/etc/data
[wzhwho@local~]#ll /usr/local/project/etc
drwxr-x-r-x 1 mysql mysql 4 Apr 11 2009 data
æ¥çæåå¯å¨äºMySQLï¼ä½æ¯è¿æ¯å¤±è´¥ï¼æ¥å¿ä¿¡æ¯è¿æ¯ä¸æ ·ã
3. ä¿®æ¹é
ç½®æ件/etc/selinux/config
æåï¼æå¨å¤å½å人çé®ä»¶æ¥å¾ä¸æ¥å°è¿æ ·çåå¤ï¼
If you are using SE linux, set it to permissive mode by editing /etc/selinux/config
and changing
SELINUX=enforcing to SELINUX=permissive
This solved all of my problems with the
"Operating system error number 13 in a file operation" error
æ以ï¼æåç¡®å®ä¸ºselinuxçé®é¢ï¼è¾å
¥å½ä»¤ls -Zï¼ä½ ä¼åç°å¨æ件ææ件夹ä¸é¢æçæ ç¾ãå¦æä¸ä¸ªæ件æ¯å¨selinuxæå¼çæ¶åå建çï¼é£ä¹å³ä½¿ä½ å
³éselinuxï¼å®çæéæ§å¶è¿æ¯ä¼èµ·ä½ç¨çãå¯ä»¥éè¿chconæ¥æ¹åæéã
4. MySQLæåå¯å¨
[wzhwho@local~]#service mysqld start
Starting mysqld daemon [OK]
温馨提示:答案为网友推荐,仅供参考