æ´æ¹æ°æ®ç®å½å®æ´è®°å½ï¼
MYSQLé»è®¤çæ°æ®æ件åå¨ç®å½ä¸º/var/lib/mysqlãåå¦è¦æç®å½ç§»å°/home/dataä¸éè¦è¿è¡ä¸é¢å æ¥ï¼
1.homeç®å½ä¸å»ºç«dataç®å½
1
2
cd /home
mkdir data
2.æMySQLæå¡è¿ç¨åæï¼
1
mysqladmin -u root -p shutdown
3.æ/var/lib/mysqlæ´ä¸ªç®å½ç§»å°/home/data
1
mv /var/lib/mysqlã/home/data/
è¿æ ·å°±æMySQLçæ°æ®æ件移å¨å°äº/home/data/mysqlä¸
4.æ¾å°my.cnfé
ç½®æ件
å¦æ/etc/ç®å½ä¸æ²¡æmy.cnfé
ç½®æ件ï¼è¯·å°/usr/share/mysql/ä¸æ¾å°*.cnfæ件ï¼æ·è´å
¶ä¸ä¸ä¸ªå°/etc/并æ¹å为my.cnf)ä¸ãå½ä»¤å¦ä¸ï¼
1
cp /usr/share/mysql/my-medium.cnfã/etc/my.cnf
5.ç¼è¾MySQLçé
ç½®æ件/etc/my.cnf
为ä¿è¯MySQLè½å¤æ£å¸¸å·¥ä½ï¼éè¦ææmysql.sockæ件ç产çä½ç½®ãä¿®æ¹socket=/var/lib/mysql/mysql.sockä¸è¡ä¸çå·å³è¾¹çå¼ä¸ºï¼/home/mysql/mysql.sock ãæä½å¦ä¸ï¼
viã my.cnfã (ç¨viå·¥å
·ç¼è¾my.cnfæ件ï¼æ¾å°ä¸åæ°æ®ä¿®æ¹ä¹)
1
2
3
4
# The MySQL server[mysqld]ã
portã= 3306
#socketã = /var/lib/mysql/mysql.sock
socketã = /home/data/mysql/mysql.sockãï¼å ä¸æ¤è¡ï¼
6.ä¿®æ¹MySQLå¯å¨èæ¬/etc/init.d/mysql
æåï¼éè¦ä¿®æ¹MySQLå¯å¨èæ¬/etc/init.d/mysqlï¼æå
¶ä¸datadir=/var/lib/mysqlä¸è¡ä¸ï¼çå·å³è¾¹çè·¯å¾æ¹æä½ ç°å¨çå®é
åæ¾è·¯å¾ï¼home/data/mysqlã
viã/etc/init.d/mysql#datadir=/var/lib/mysqlï¼æ³¨éæ¤è¡ï¼
datadir=/home/data/mysql ï¼å ä¸æ¤è¡ï¼
å¦ææ¯CentOSè¿è¦æ¹ /usr/bin/mysqld_safe ç¸å
³æ件ä½ç½®ï¼
æå åä¸ä¸ªmysql.sock é¾æ¥ï¼
in -s /home/data/mysql/mysql.sock /var/lib/mysql/mysql.sock
7.éæ°å¯å¨MySQLæå¡
/etc/init.d/mysqldãstart
æç¨rebootå½ä»¤éå¯Linux
å¦æå·¥ä½æ£å¸¸ç§»å¨å°±æåäºï¼å¦å对ç
§åé¢ç7æ¥åæ£æ¥ä¸ä¸ãè¿è¦æ³¨æç®å½çå±ä¸»åæéã
å¤å¶å
容å°åªè´´æ¿
代ç :
[root@sample ~]# chown -R mysql:mysql /home/data/mysql/ã â æ¹åæ°æ®åºçå½å±ä¸ºmysql
[root@sample ~]# chmod 700 /home/data/mysql/test/ã â æ¹åæ°æ®åºç®å½å±æ§ä¸º700
[root@sample ~]# chmod 660 /home/data/mysql/test/*ã â æ¹åæ°æ®åºä¸æ°æ®çå±æ§ä¸º660
é误解å³æ¹æ¡ï¼
1.å¨CentOSä¸ï¼å¦æmysqlæ¯éè¿yumå®è£
çï¼é£ä¹å¯è½ä½¿ç¨ä¸é¢çæ¹æ³ä¸è½å®å
¨åæã
åå ï¼mysqlçé
ç½®æ件æå¤å¤ï¼é¤äºæ´æ¹/etc/my.cnfæ件ä¹å¤ï¼è¿éè¦æ´æ¹/usr/lib64/mysql/mysql_config
è¿ä¸ªæ件éé¢æä¸è¡âldata='/var/lib/mysql'âå"socket=/var/lib/mysql/mysql.sock"ï¼è¿éä¹éè¦æ¹æ
2.å¦å¤ï¼è¿ææéé®é¢ï¼æ¥ç/var/log/mysqld.log,åç°Can't create test file /xxx/mysql/centos5.lower-test
è¿éæ¯å 为没ææéå建æ读åæ件ã
解å³åæ³å°±æ¯ä½¿ç¨setenforce 0 è¿ä¸ªå½ä»¤ï¼è®©ç³»ç»å
³éæéæ ¡éªï¼ç¶ååè¿è¡å½ä»¤ service mysqld start åç°OKäºã
å¦æè¦å½»åºç¦ç¨SELinux éè¦å¨/etc/sysconfig/selinuxä¸è®¾ç½®åæ°selinux=0
å¦å¤ä¸ä¸ªåæ³æ¯restorecon -FRv /home/data/mysqlï¼æè
chcon -R -t mysqld_db_t /home/data/mysql
温馨提示:答案为网友推荐,仅供参考