RHEL下安裝MySQL

1、.RHEL下安裝MySQL1.到mysql的網(wǎng)站(必須到官方網(wǎng)站下載,防止數(shù)據(jù)被修改,纂改過(guò))下載四個(gè)必須rpm 安裝包:MySQL-client-5.1.16-0.glibc23.i386.rpmMySQL-devel-5.1.16-0.glibc23.i386.rpmMySQL-server-5.1.16-0.glibc23.i386.rpmMySQL-shared-5.1.16-0.glibc23.i386.rpm2. 通過(guò)ssh遠(yuǎn)程控制工具傳到服務(wù)器上,放在適當(dāng)?shù)哪夸浵?如:/opt/mysql/mysql5.1.16)3.進(jìn)入目錄(/opt/mysql/mysql5.1.16)下安裝

2、msyql:rpm 文件是Red Hat公司開(kāi)發(fā)的軟件安裝包，rpm可讓Linux在安裝軟件包時(shí)免除許多復(fù)雜的手續(xù)。該命令在安裝時(shí)常用的參數(shù)是 ivh ,其中i表示將安裝指定的rmp軟件包，V表示安裝時(shí)的詳細(xì)信息，h表示在安裝期間出現(xiàn)"#"符號(hào)來(lái)顯示目前的安裝過(guò)程。這個(gè)符號(hào)將持續(xù)到安裝完成后才停止。rootqudee mysql5.1.16# rpm ivh MySQL-client-5.1.16-0.glibc23.i386.rpmrootqudee mysql5.1.16# rpm ivh MySQL-devel-5.1.16-0.glibc23.i386.rpmroo

3、tqudee mysql5.1.16# rpm ivh MySQL-shared-5.1.16-0.glibc23.i386.rpmrootqudee mysql5.1.16# rpm ivh MySQL-server-5.1.16-0.glibc23.i386.rpm顯示如下信息warning: MySQL-server-5.1.16-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5Preparing. # 100%1:MySQL-server # 100%PLEASE REMEMBER TO SET A PASSWORD FOR TH

4、E MySQL root USER !To do so, start the server, then issue the following commands:/usr/bin/mysqladmin -u root password 'new-password'/usr/bin/mysqladmin -u root -h localhost password 'new-password'See the manual for more instructions.NOTE: If you are upgrading from a MySQL <= 3.22.

5、10 you should runthe /usr/bin/mysql_fix_privilege_tables. Otherwise you will not beable to use the new GRANT command!Please report any problems with the /usr/bin/mysqlbug script!The latest information about MySQL is available on the web atSupport MySQL by buying support/licenses atStarting MySQL.失敗4

6、.查看已安裝的包rootqudee mysql5.1.20# rpm -qa | grep -i mysql或者 rootqudee mysql5.1.20# rpm -qa | grep mysqlMySQL-devel-5.1.20-0.glibc23MySQL-shared-5.1.20-0.glibc23MySQL-client-5.1.20-0.glibc23MySQL-server-5.1.20-0.glibc235.查看rootqudee /# locate mysql.server 的路徑/usr/share/man/man1/mysql.server.1.gz/usr/sha

7、re/mysql/mysql.server復(fù)制并更名 rootqudee /#cp /usr/share/mysql/mysql.server /etc/init.d/mysqld6.查看rootqudee /# locate my-f 的路徑/usr/share/doc/MySQL-server-5.1.16/my-f/usr/share/mysql/my-f復(fù)制并更名rootqudee /#cp /usr/share/mysql/my-f /etc/f7.啟動(dòng)服務(wù):service mysqld startStarting MySQL OK 啟動(dòng)成功!恭喜8.編輯vi /etc/f 這個(gè)文件

8、,設(shè)置字符集,支持國(guó)際化.default-character-set=utf8 /在此添加字符集# Here follows entries for some specific programs# The MySQL servermysqld port = 3306#socket = /var/lib/mysql/mysql.sockskip-lockingkey_buffer = 384Mmax_allowed_packet = 1Mtable_cache = 512sort_buffer_size = 2Mread_buffer_size = 2Mread_rnd_buffer_size

9、= 8Mmyisam_sort_buffer_size = 64Mthread_cache_size = 8query_cache_size = 32Mdefault-character-set=utf8 /在此添加字符集# Try number of CPU's*2 for thread_concurrencythread_concurrency = 16先按Esc, 再同時(shí)按Shift + ; 再輸入wq! (推出并保存)呵呵! 字符集就配置好了9.MySQL默認(rèn)的數(shù)據(jù)文件存儲(chǔ)目錄為/var/lib/mysql。假如要把目錄移到/qudeedata/dbdata/mysql5.1.

10、16下需要進(jìn)行下面幾步：(1)、/qudeedata/dbdata目錄下建立mysql5.1.16目錄cd /qudeedata/dbdatamkdir mysql5.1.16(2)、把MySQL服務(wù)進(jìn)程停掉：service mysqld stop(3)、把/var/lib/mysql整個(gè)目錄移到/qudeedata/dbdata/mysql5.1.16mv /var/lib/mysql/qudeedata/dbdata/mysql5.1.16這樣就把MySQL的數(shù)據(jù)文件移動(dòng)到了/qudeedata/dbdata/mysql5.1.16 下(4)、編輯MySQL的配置文件/etc/f為保證My

11、SQL能夠正常工作，需要指明mysql.sock文件的產(chǎn)生位置。修改socket=/var/lib/mysql/mysql.sock一行中等號(hào)右邊的值為：/qudeedata/dbdata/mysql5.1.16/mysql/mysql.sock 。操作如下：命令: vi f (用vi工具編輯f文件，找到下列數(shù)據(jù)修改之)# The MySQL servermysqldport= 3306#socket = /var/lib/mysql/mysql.sock（原內(nèi)容，為了更穩(wěn)妥用"#"注釋此行）socket = /qudeedata/dbdata/mysql5.1.16/my

12、sql/mysql.sock（加上此行）(5)、修改MySQL啟動(dòng)腳本/etc/rc.d/init.d/mysqld最后，需要修改MySQL啟動(dòng)腳本/etc/rc.d/init.d/mysqld，把其中datadir=/var/lib/mysql一行中，等號(hào)右邊的路徑改成你現(xiàn)在的實(shí)際存放路徑：/qudeedata/dbdata/mysql5.1.16。roottest1 etc# vi/etc/rc.d/init.d/mysqld#datadir=/var/lib/mysql（注釋此行）datadir=/qudeedata/dbdata/mysql5.1.16 （加上此行）10、自動(dòng)啟動(dòng)1）察

13、看mysql是否在自動(dòng)啟動(dòng)列表中rootqudee /#chkconfig list2）把MySQL添加到你系統(tǒng)的啟動(dòng)服務(wù)組里面去rootqudee /#chkconfig addmysql11.測(cè)試通過(guò)命令是否能夠啟動(dòng),停止,重啟結(jié)果:rootqudee /# service mysqld startStarting MySQL OK rootqudee /# service mysqld restartShutting down MySQL. OK Starting MySQL OK rootqudee /# service mysqld stopShutting down MySQL. OK rootqudee /# /etc/init.d/mysqld startStarting MySQL OK rootqudee