1. è¿è¡å¹³å°ï¼CentOS 6.3 x86_64ï¼åºæ¬çåäºRHEL 6.3
2. å®è£
æ¹æ³ï¼
å®è£
MySQL主è¦æ两ç§æ¹æ³ï¼ä¸ç§æ¯éè¿æºç èªè¡ç¼è¯å®è£
ï¼è¿ç§éåé«çº§ç¨æ·å®å¶MySQLçç¹æ§ï¼è¿éä¸å说æï¼å¦ä¸ç§æ¯éè¿ç¼è¯è¿çäºè¿å¶æ件è¿è¡å®è£
ãäºè¿å¶æ件å®è£
çæ¹æ³åå为两ç§ï¼ä¸ç§æ¯ä¸é对ç¹å®å¹³å°çéç¨å®è£
æ¹æ³ï¼ä½¿ç¨çäºè¿å¶æ件æ¯åç¼ä¸º.tar.gzçå缩æ件ï¼ç¬¬äºç§æ¯ä½¿ç¨RPMæå
¶ä»å
è¿è¡å®è£
ï¼è¿ç§å®è£
è¿ç¨ä¼èªå¨å®æç³»ç»çç¸å
³é
ç½®ï¼æ以æ¯è¾æ¹ä¾¿ã
3. ä¸è½½å®è£
å
ï¼
a. å®æ¹ä¸è½½å°åï¼
http://dev.mysql.com/downloads/mysql/#downloadsæéåæ件ä¸è½½ï¼
http://dev.mysql.com/downloads/mirrors.html2. ä¸è½½æ件ï¼æ ¹æ®æä½ç³»ç»éæ©ç¸åºçåå¸çæ¬ï¼ï¼
a. éç¨å®è£
æ¹æ³
mysql-5.5.29-linux2.6-x86_64.tar.gz
b. RPMå®è£
æ¹æ³ï¼
MySQL-server-5.5.29-2.el6.x86_64.rpm
MySQL-client-5.5.29-2.el6.x86_64.rpm
4. éç¨å®è£
æ¥éª¤
a. æ£æ¥æ¯å¦å·²å®è£
ï¼grepç-ié项表示å¹é
æ¶å¿½ç¥å¤§å°å
[root@localhost JavaEE]#rpm -qa|grep -i mysql
mysql-libs-5.1.61-4.el6.x86_64
*å¯è§å·²ç»å®è£
äºåºæ件ï¼åºè¯¥å
å¸è½½ï¼ä¸ç¶ä¼åºç°è¦çé误ã注æå¸:è½½æ¶ä½¿ç¨äº--nodepsé项ï¼å¿½ç¥äºä¾èµå
³ç³»ï¼
[root@localhost JavaEE]#rpm -e mysql-libs-5.1.61-4.el6.x86_64 --nodeps
b. æ·»å mysqlç»åmysqlç¨æ·ï¼ç¨äºè®¾ç½®mysqlå®è£
ç®å½æ件ææè
åæå±ç»ã
[root@localhost JavaEE]#groupadd mysql
[root@localhost JavaEE]#useradd -r -g mysql mysql
*useradd -råæ°è¡¨ç¤ºmysqlç¨æ·æ¯ç³»ç»ç¨æ·ï¼ä¸å¯ç¨äºç»å½ç³»ç»ã
c. å°äºè¿å¶æ件解åå°æå®çå®è£
ç®å½ï¼æ们è¿éæå®ä¸º/usr/local
[root@localhost ~]# cd/usr/local/
[root@localhost local]#tar zxvf /path/to/mysql-5.5.29-linux2.6-x86_64.tar.gz
*å ååå¨/usr/local/çæäºè§£ååçæ件夹mysql-5.5.29-linux2.6-x86_64ï¼è¿åå太é¿ï¼æ们为å®å»ºç«ä¸ä¸ªç¬¦å·é¾æ¥mysqlï¼æ¹ä¾¿è¾å
¥ã
[root@localhost local]#ln -s mysql-5.5.29-linux2.6-x86_64 mysql
d. /usr/local/mysql/ä¸çç®å½ç»æ
Directory
Contents of Directory
bin
Client programs and the mysqld server
data
Log files, databases
docs
Manual in Info format
man
Unix manual pages
include
Include (header) files
lib
Libraries
scripts
mysql_install_db
share
Miscellaneous support files, including error messages, sample configuration files, SQL for database installation
sql-bench
Benchmarks
e. è¿å
¥mysqlæ件夹ï¼ä¹å°±æ¯mysqlæå¨çç®å½ï¼å¹¶æ´æ¹æå±çç»åç¨æ·ã
[root@localhost local]#cd mysql
[root@localhost mysql]#chown -R mysql .
[root@localhost mysql]#chgrp -R mysql .
f. æ§è¡mysql_install_dbèæ¬ï¼å¯¹mysqlä¸çdataç®å½è¿è¡åå§å并å建ä¸äºç³»ç»è¡¨æ ¼ã注æmysqlæå¡è¿ç¨mysqldè¿è¡æ¶ä¼è®¿é®dataç®å½ï¼æ以å¿
é¡»ç±å¯å¨mysqldè¿ç¨çç¨æ·ï¼å°±æ¯æ们ä¹å设置çmysqlç¨æ·ï¼æ§è¡è¿ä¸ªèæ¬ï¼æè
ç¨rootæ§è¡ï¼ä½æ¯å ä¸åæ°--user=mysqlã
[root@localhost mysql]scripts/mysql_install_db --user=mysql
*å¦æmysqlçå®è£
ç®å½ï¼è§£åç®å½ï¼ä¸æ¯/usr/local/mysqlï¼é£ä¹è¿å¿
é¡»æå®ç®å½åæ°ï¼å¦
[root@localhost mysql]scripts/mysql_install_db --user=mysql \
--basedir=/opt/mysql/mysql \
--datadir=/opt/mysql/mysql/data
*å°mysql/ç®å½ä¸é¤äºdata/ç®å½çæææ件ï¼æ¹årootç¨æ·ææï¼mysqlç¨æ·åªéä½ä¸ºmysql/data/ç®å½ä¸æææ件çææè
ã
[root@localhost mysql]chown -R root .
[root@localhost mysql]chown -R mysql data
g. å¤å¶é
ç½®æ件
[root@localhost mysql] cp support-files/my-medium.cnf /etc/my.cnf
h. å°mysqldæå¡å å
¥å¼æºèªå¯å¨é¡¹ã
*é¦å
éè¦å°scripts/mysql.serveræå¡èæ¬å¤å¶å°/etc/init.d/ï¼å¹¶éå½å为mysqldã
[root@localhostmysql] cp support-files/mysql.server /etc/init.d/mysqld
*éè¿chkconfigå½ä»¤å°mysqldæå¡å å
¥å°èªå¯å¨æå¡é¡¹ä¸ã
[root@localhost mysql]#chkconfig --add mysqld
*注ææå¡å称mysqldå°±æ¯æ们å°mysql.serverå¤å¶å°/etc/init.d/æ¶éå½åçå称ã
*æ¥çæ¯å¦æ·»å æå
[root@localhost mysql]#chkconfig --list mysqld
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
i. éå¯ç³»ç»ï¼mysqldå°±ä¼èªå¨å¯å¨äºã
*æ£æ¥æ¯å¦å¯å¨
[root@localhost mysql]#netstat -anp|grep mysqld
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 2365/mysqld
unix 2 [ ACC ] STREAM LISTENING 14396 2365/mysqld /tmp/mysql.sock
*å¦æä¸æ³éæ°å¯å¨ï¼é£å¯ä»¥ç´æ¥æå¨å¯å¨ã
[root@localhost mysql]#service mysqld start
Starting MySQL.. SUCCESS!
j. è¿è¡å®¢æ·ç«¯ç¨åºmysqlï¼å¨mysql/binç®å½ä¸ï¼æµè¯è½å¦è¿æ¥å°mysqldã
[root@localhost mysql]#/usr/local/mysql/bin/mysql
Welcome to the MySQLmonitor. Commands end with ; or \g.
Your MySQL connection idis 2
Server version:5.5.29-log MySQL Community Server (GPL)
Copyright (c) 2000, 2012,Oracle and/or its affiliates. All rights reserved.
Oracle is a registeredtrademark of Oracle Corporation and/or its affiliates. Other names may betrademarks of their respective owners.
Type 'help;' or '\h' forhelp. Type '\c' to clear the current input statement.
mysql> quit
Bye
*æ¤æ¶ä¼åºç°mysql>å½ä»¤æ示符ï¼å¯ä»¥è¾å
¥sqlè¯å¥ï¼è¾å
¥quitæexitéåºã为äºé¿å
æ¯æ¬¡é½è¾å
¥mysqlçå
¨è·¯å¾/usr/local/mysql/bin/mysqlï¼å¯å°å
¶å å
¥ç¯å¢åéä¸ï¼å¨/etc/profileæåå å
¥ä¸¤è¡å½ä»¤ï¼
MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin
è¿æ ·å°±å¯ä»¥å¨shellä¸ç´æ¥è¾å
¥mysqlå½ä»¤æ¥å¯å¨å®¢æ·ç«¯ç¨åºäº
[root@localhost mysql]#mysql
Welcome to the MySQLmonitor. Commands end with ; or \g.
Your MySQL connection idis 3
Server version:5.5.29-log MySQL Community Server (GPL)
Copyright (c) 2000, 2012,Oracle and/or its affiliates. All rights reserved.
Oracle is a registeredtrademark of Oracle Corporation and/or its
affiliates. Other namesmay be trademarks of their respective
owners.
Type 'help;' or '\h' forhelp. Type '\c' to clear the current input statement.
mysql>
5. RPMå®è£
æ¥éª¤
a. æ£æ¥æ¯å¦å·²å®è£
ï¼grepç-ié项表示å¹é
æ¶å¿½ç¥å¤§å°å
[root@localhost JavaEE]#rpm -qa|grep -i mysql
mysql-libs-5.1.61-4.el6.x86_64
å¯è§å·²ç»å®è£
äºåºæ件ï¼åºè¯¥å
å¸è½½ï¼ä¸ç¶ä¼åºç°è¦çé误ã注æå¸è½½æ¶ä½¿ç¨äº--nodepsé项ï¼å¿½ç¥äºä¾èµå
³ç³»ï¼
[root@localhost JavaEE]#rpm -e mysql-libs-5.1.61-4.el6.x86_64 --nodeps
2. å®è£
MySQLçæå¡å¨ç«¯è½¯ä»¶ï¼æ³¨æåæ¢å°rootç¨æ·ï¼
[root@localhost JavaEE]#rpm -ivh MySQL-server-5.5.29-2.el6.x86_64.rpm
å®è£
å®æåï¼å®è£
è¿ç¨ä¼å¨Linuxä¸æ·»å ä¸ä¸ªmysqlç»ï¼ä»¥åå±äºmysqlç»çç¨æ·mysqlãå¯éè¿idå½ä»¤æ¥çï¼
[root@localhost JavaEE]#id mysql
uid=496(mysql)gid=493(mysql) groups=493(mysql)
MySQLæå¡å¨å®è£
ä¹åè½ç¶é
ç½®äºç¸å
³æ件ï¼ä½å¹¶æ²¡æèªå¨å¯å¨mysqldæå¡ï¼éèªè¡å¯å¨ï¼
[root@localhost JavaEE]#service mysql start
Starting MySQL.. SUCCESS!
å¯éè¿æ£æ¥ç«¯å£æ¯å¦å¼å¯æ¥æ¥çMySQLæ¯å¦æ£å¸¸å¯å¨ï¼
[root@localhost JavaEE]#netstat -anp|grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 34693/mysqld
c. å®è£
MySQLç客æ·ç«¯è½¯ä»¶ï¼
[root@localhost JavaEE]#rpm -ivh MySQL-client-5.5.29-2.el6.x86_64.rpm
å¦æå®è£
æååºè¯¥å¯ä»¥è¿è¡mysqlå½ä»¤ï¼æ³¨æå¿
é¡»æ¯mysqldæå¡ä»¥åå¼å¯ï¼
[root@localhost JavaEE]#mysql
Welcome to the MySQLmonitor. Commands end with ; or \g.
Your MySQL connection idis 1
Server version: 5.5.29MySQL Community Server (GPL)
Copyright (c) 2000, 2012,Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademarkof Oracle Corporation and/or its affiliates. Other names may be trademarks oftheir respective owners.
Type 'help;' or '\h' forhelp. Type '\c' to clear the current input statement.
mysql>
d. RPMå®è£
æ¹å¼æ件åå¸
Directory
Contents of Directory
/usr/bin
Client programs and scripts
/usr/sbin
The mysqld server
/var/lib/mysql
Log files, databases
/usr/share/info
Manual in Info format
/usr/share/man
Unix manual pages
/usr/include/mysql
Include (header) files
/usr/lib/mysql
Libraries
/usr/share/mysql
Miscellaneous support files, including error messages, character set files, sample configuration files, SQL for database installation
/usr/share/sql-bench
Benchmarks