《Mysql學習Centos5.5中安裝Mysql5.5過程分享》要點：
本文介紹了Mysql學習Centos5.5中安裝Mysql5.5過程分享，希望對您有用。如果有疑問，可以聯系我們。
這幾天在centos下裝mysql,這里記錄一下安裝的過程,便利以后查閱MYSQL必讀
Mysql5.5.37安裝必要cmake,5.6版本開始都必要cmake來編譯,5.5以后的版本應該也要裝這個.MYSQL必讀
安裝cmakeMYSQL必讀
代碼如下:
[root@local ~]# wget http://www.cmake.org/files/v2.8/cmake-2.8.12.2.tar.gz
[root@local ~]# tar xvf cmake-2.8.12.2.tar.gz
[root@local ~]# cd cmake-2.8.12.2
[root@local cmake-2.8.12.2]#./bootstrap
[root@local cmake-2.8.12.2]# make
[root@local cmake-2.8.12.2]# make install
安裝mysqlMYSQL必讀
代碼如下:
[root@local ~]# wget http://cdn.mysql.com/Downloads/MySQL-5.5/mysql-5.5.37.tar.gz
[root@local ~]# tar xvf mysql-5.5.37.tar.gz
[root@local ~]# cd mysql-5.5.37
[root@local mysql-5.5.37]# cmake ./
可能還會報這個錯,沒有就跳過 MYSQL必讀
代碼如下:
CMake Error at cmake/readline.cmake:83(MESSAGE):
Curses library not found.? Pleaseinstall appropriate package,
remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name islibncurses5-dev, on Redhat and derivates it is ncurses-devel.
Call Stack (most recent call first):
?cmake/readline.cmake:127 (FIND_CURSES)
?cmake/readline.cmake:217 (MYSQL_USE_BUNDLED_LIBEDIT)
?CMakeLists.txt:355 (MYSQL_CHECK_READLINE
-- Configuring incomplete, errors occurred!
See also "/root/my/mysql-5.5.37/CMakeFiles/CMakeOutput.log".
See also"/root/my/mysql-5.5.37/CMakeFiles/CMakeError.log".
闡明centos系統沒有ncurses-develMYSQL必讀
代碼如下:
[root@local ~]# wget http://invisible-island.net/datafiles/release/ncurses.tar.gz
[root@local ~]# cd ncurses-5.9
[root@local ncurses-5.9]#./configure
[root@local ncurses-5.9]# make
[root@local ncurses-5.9]# make install
再刪除剛才編譯生成的 CMakeCache.txt 文件,不然無法進行下一步MYSQL必讀
代碼如下:
[root@local mysql-5.5.37]# rm -f CMakeCache.txt
繼續編譯mysqlMYSQL必讀
代碼如下:
[root@local ~]# cmake ./
[root@local ~]# make
[root@local ~]# make install
這樣,mysql默認將勝利安裝到/usr/local/mysqlMYSQL必讀
創立mysql用戶組MYSQL必讀
代碼如下:
[root@local ~]# groupadd mysql
[root@local ~]# useradd Cr Cg mysql mysql
[root@local ~]# chown CR mysql.mysql /usr/local/mysql
啟動mysqlMYSQL必讀
代碼如下:
[root@local ~]# /usr/local/mysql/bin/mysqld_safe --user=mysql?
這里可能會發生差錯,沒有就跳過：MYSQL必讀
代碼如下:
FATAL ERROR: Could not find./bin/my_print_defaults
If you compiled from source, you need torun 'make install' to
copy the software into the correct locationready for operation.
If you are using a binary release, you musteither be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.
解決辦法：MYSQL必讀
代碼如下:
[root@local ~]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
再啟動mysqlMYSQL必讀
代碼如下:
[root@local ~]# /usr/local/mysql/bin/mysqld_safe --user=mysql
注冊mysql服務,開機主動啟動MYSQL必讀
1.設置mysql配置文件到/etc目次MYSQL必讀
代碼如下:
[root@local ~]# cp /usr/local/mysql/support-files/my-medium.cnf/etc/my.cnf?
2.設置mysql開機自啟MYSQL必讀
代碼如下:
[root@local ~]# cp/usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
[root@local ~]# chmod +x /etc/init.d/mysql
[root@local ~]# /sbin/chkconfig --add mysql
3.啟動mysql服務MYSQL必讀
代碼如下:
[root@local ~]# service mysql start?
測試mysql是否安裝勝利MYSQL必讀
代碼如下:
[root@local ~]# /usr/local/mysql/bin/mysql -u root -p?
Enter password:??
Welcome to the MySQL monitor.? Co妹妹ands end with ; or \g.?
Your MySQL connection id is 1?
Server version: 5.5.37 Source distribution?
??
Copyright (c) 2000, 2014, Oracle and/or itsaffiliates. All rights reserved.?
??
Oracle is a registered trademark of OracleCorporation and/or its?
affiliates. Other names may be trademarksof their respective?
owners.?
??
Type 'help;' or '\h' for help. Type '\c' toclear the current input statement.?
??
mysql> show databases;?
+--------------------+?
| Database?????????? |?
+--------------------+?
| information_schema |?
| mysql????????????? |?
| performance_schema |?
| test?????????????? |?
+--------------------+?
4 rows in set (0.03 sec)?
《Mysql學習Centos5.5中安裝Mysql5.5過程分享》是否對您有啟發，歡迎查看更多與《Mysql學習Centos5.5中安裝Mysql5.5過程分享》相關教程，學精學透。維易PHP學院為您提供精彩教程。
轉載請注明本頁網址：
http://www.snjht.com/jiaocheng/13926.html
