ããmysqlå®è£ ååå¤
ããå¨å®è£ mysqlä¹åéè¦è¿è¡ä¸äºåå¤å·¥ä½ãé¦å è¦æç¡®Linuxä¸æ¯å¦å·²ç»å®è£ mysqlæå¡ï¼å¨ä¸æç¡®çæ åµä¸ï¼å¯ä»¥æ§è¡ä»¥ä¸å½ä»¤è¿è¡ç¡®è®¤ã
ã
ã[root@localhost ~]#rpm -q mysqlããæ§è¡å½ä»¤åçç»æå¦ä¸æ示ï¼è¡¨æmysqlæå¡æ²¡æå®è£ ã
ãã[root@localhost ~]#rpm -q mysqlããå¦ææ£æµå°mysqlæå¡æ²¡æå®è£ ï¼åéè¦åå¤å®è£ mysqlæå¡æéè¦çRPMå ï¼å¦ä¸æ示ï¼ä¸è½½å°åï¼http://dev.mysql.com/downloads/mysql/ã
ããMySQL-server-community-5.1.26-0.rhel4.i386.rpm
ããMySQL-client-community-5.1.26-0.rhel4.i386.rpm
ããMySQL-shared-community-5.1.26-0.rhel4.i386.rpm
ããMySQL-devel-community-5.1.26-0.rhel4.i386.rpm
ããMySQL-test-community-5.1.26-0.rhel4.i386.rpm
ããMySQL-community-debuginfo-5.1.26-0.rhel4.i386.rpm
ããmysqlå®è£ ç详ç»è¿ç¨
ããå®è£ mysqlçæ¹æ³æå¤ç§ï¼ä¸é¢å°±ä»¥RPMå å®è£ åæºç å®è£ 两ç§æ¹å¼ä¸ºä¾è¿è¡è®²è§£ã
ãã1.RPMå å®è£ æ¹å¼
ããè¿è¡å¦ä¸å½ä»¤ï¼
ãã[root@test1 local]# rpm -ivh MySQL-server-community-5.1.26-0.rhel4.i386.rpmããå¦ä¸å®è£ å ¶ä»ç5个rpmæ件ï¼åºè¯¥æ²¡æä»ä¹é®é¢ã
ãã2.æºç å®è£ æ¹å¼
ããè¦ä½¿ç¨æºç çæ¹å¼å¯¹mysqlæ°æ®åºè¿è¡å®è£ ï¼åéè¦å ä»ç¸å ³ç½ç«ä¸è½½è·å¾ç¸åºçmysqlå®è£ å æ件ï¼mysql-5.0.15.tar.gzï¼ï¼ç¶åè¿è¡ç¸å ³çå®è£ å·¥ä½ï¼å®è£ çå ·ä½æ¥éª¤å¦ä¸ã
ãã第1æ¥ï¼ä¸ºâmysqldâæå¡å¢æ·»ä¸ä¸ªç»å½ç»åç¨æ·åï¼æ§è¡å¦ä¸å½ä»¤ã
ãã[root@localhost ~]#groupadd mysqlãã第2æ¥ï¼è§£åmysqlå®è£ å ï¼æ§è¡å¦ä¸å½ä»¤ã
ãã[root@localhost ~]#gunzip < mysql-5.0.15.tar.gz | tar -xvf -ãã第3æ¥ï¼è¿è¡ç¸å ³çé ç½®åç¼è¯ã
ããç»configureåé å¯æ§è¡æ件ï¼æ§è¡å¦ä¸å½ä»¤ã
ãã[root@localhost ~]#chmod +x configureããæ¹åå符é为GBK[é»è®¤å符é为 ISO-8859-1(Latin1)]ï¼æ§è¡å¦ä¸å½ä»¤ã
ãã[root@localhost ~]#./configure --prefix=/usr/local/mysql --with-charset=gbkãã第4æ¥ï¼æ§è¡å¦ä¸å½ä»¤è¿è¡å®è£
ãã[root@localhost ~]#make installããå¦å¤ï¼å¦ææ³å®è£ é项æ件ï¼ä½¿ç¨å½ååå¨çâsupport-filesâæ件夹ä½ä¸ºæ¨¡æ¿ï¼æ§è¡å¦ä¸æ令ã
ãã[root@localhost ~]#cp support-files/my-medium.cnf /etc/my.cnfããåæ¶ï¼å¦æéè¦è®©mysqlæ¯æ¬¡å¼æºæ¶èªå¨å¯å¨ï¼éè¦æ§è¡å¦ä¸æ令ã
ãã[root@localhost ~]#cp -r support-files/mysql.server /etc/init.d/mysqlãã第5æ¥ï¼æ§è¡ä»¥ä¸å½ä»¤è¿è¡å®è£ ç®å½ã
ãã[root@localhost ~]#cd /usr/local/mysqlãã第6æ¥ï¼å°ç¨åºçæææéæç»ârootâ,并ä¸ææ°æ®ç®å½çææææç»å¯ä»¥è¿è¡âmysqldâçç¨æ·ï¼å设mysqlçå®è£ ç®å½ä¸ºâ/usr/local/mysqlâï¼æ§è¡ä»¥ä¸å½ä»¤ã
ããé¦å ææ件æ¥æææç»ârootâï¼æ§è¡å¦ä¸å½ä»¤ã
ãã[root@localhost ~]#chown -R rootããç¶åææ°æ®ç®å½æ¥æ¤ææç»âmysqlâç¨æ·ï¼æ§è¡å¦ä¸å½ä»¤ã
ãã[root@localhost ~]#chown -R mysql varããæåæç»çæéæç»âmysqlâç»ï¼æ§è¡å¦ä¸å½ä»¤ã
ãã[root@localhost ~]#chgrp -R mysqlãã第7æ¥ï¼ææçé ç½®å®æåï¼æ§è¡ä»¥ä¸å½ä»¤æµè¯å¹¶è¿è¡mysql
ãã[root@localhost ~]#/usr/local/mysql/bin/mysqld_safe --user=mysql &ãã第8æ¥ï¼æµè¯ä¸åæ£å¸¸åï¼ä¸ºäºå®å ¨èµ·è§ï¼æ好æ´æ¹ç®¡çåçå¯ç ãå¯ä»¥è¿è¡mysqladminï¼æ§è¡å¦ä¸å½ä»¤ã
ãã[root@localhost ~]#cd binãã第9æ¥ï¼å è®¸å ¶ä»ç¨æ·è®¿é®æ¬æºï¼æ§è¡ä»¥ä¸å½ä»¤ã
ãã[root@localhost ~]#./mysqladmin -u root -p mysqlãã第10æ¥ï¼ä¿®æ¹mysqlæ°æ®åºç«¯å£å·ï¼æ§è¡å¦ä¸å½ä»¤ã
ãã[root@localhost ~]#vi /etc/my.cnfãã第11æ¥ï¼éå¯åºç¨ï¼æ§è¡å¦ä¸å½ä»¤ã
ãã[root@localhost ~]#service mysql restartãã以ä¸mysqlå®è£ æ¹å¼é½ç¨æ¾å¤æï¼å»ºè®®å¨â软件å 管çè âçªå£ä¸è¿è¡å®è£ ã
Linux系统上安装MySQL数据库