Linux安裝MySQL的兩種方法

mysql-5.5.29-linux2.6-x86_64.tar.gz

MySQL-server-5.5.29-2.el6.x86_64.rpm MySQL-client-5.5.29-2.el6.x86_64.rpm

[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

[root@localhost?JavaEE]#groupadd?mysql [root@localhost?JavaEE]#useradd?-r?-g?mysql?mysql *useradd?-r參數表示mysql用戶是系統用戶，不可用于登錄系統。

[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

[root@localhost?local]#cd?mysql [root@localhost?mysql]#chown?-R?mysql?. [root@localhost?mysql]#chgrp?-R?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

[root@localhost?mysql]?cp?support-files/my-medium.cnf?/etc/my.cnf

*首先需要將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>

[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

[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

[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>