不好意思,請教各位前輩,小弟將MySQL的資料庫掛在NFS下就一直無法啟動MySQL,請問是不是需要修改SELinux的設定? 或是有麼方法能讓MySQL掛在NFS之下呢?
小弟上網找尋許多方法都無解,感謝各位前輩指導,感激再感激
my.cnf設定
[mysqld]
datadir=/home/mysql
socket=/var/lib/mysql/mysql.sock
User=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
id-file=/var/run/mysqld/mysqld.pid
/etc/fstab設定
192.168.1.12:centos /home nfs rw 0 0
修改MySQL資料庫掛載位置步驟如下:
1. 停止mysqld服務
# /etc/init.d/mysqld stop
2. 修改SELinux設定,使home可掛載在nfs下
# setsebool -P use_nfs_home_dirs 1
3. 掛載NFS
# mount -t nfs 192.168.1.12:centos /home
4. 建立mysql資料夾於/home下
# cd /home ; mkdir mysql
5. 修改資料夾擁有者
# chown mysql:mysql /home/mysql
6. 為確保權限無誤,再下一次指令
# chmod 755 /home/mysql
7. 複製原有資料庫內容至/home/mysql下
# cp -Ra /var/lib/mysql /home/msyql
8. 利用以下指令,初始化MySQL資料庫
# mysql_install_db --user=mysql --ldata=/home/mysql
9. 啟動MySQL
# /etc/init.d/mysqld start
出現錯誤:
120522 15:43:52 mysqld_safe Starting mysqld daemon with databases from /home/mysql
120522 15:43:52 [Warning] Can't create test file /home/mysql/ldap.lower-test
120522 15:43:52 [Warning] Can't create test file /home/mysql/ldap.lower-test
/usr/libexec/mysqld: Can't change dir to '/home/mysql/' (Errcode: 13)
120522 15:43:52 [ERROR] Aborting
120522 15:43:52 [Note] /usr/libexec/mysqld: Shutdown complete
120522 15:43:52 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
這個問題困擾了我兩天了,請求各位前輩協助解決此問題,感謝