1 檢視機器上是否裝有mysql
rpm -qa | grep mysql
2. 删除已經存在的mysql
rpm -e --nodeps mysql ()強力删除模式)
3.安裝編譯代碼需要的包
yum -y install gcc gcc-devel gcc-c++ gcc-c++-devel autoconf* automake* zlib* libxml* ncurses-devel ncurses libgcrypt* libtool* cmake openssl openssl-devel bison bison-devel unzip -y
4. 解壓編譯:tar -zxvf mysql-5.6.14.tar.gz
cd mysql-5.6.14
編譯安裝: mysql5.5以後編譯安裝使用cmake
cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DSYSCONFDIR=/etc \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
*********************************************************************
如果出現一下錯誤:
cmake .
-- MySQL 5.5.8
-- Could NOT find Curses (missing: CURSES_LIBRARY CURSES_INCLUDE_PATH)
CMake Error at cmake/readline.cmake:82 (MESSAGE):
Curses library not found. Please install appropriate package,
remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.
Call Stack (most recent call first):
cmake/readline.cmake:126 (FIND_CURSES)
cmake/readline.cmake:216 (MYSQL_USE_BUNDLED_LIBEDIT)
CMakeLists.txt:256 (MYSQL_CHECK_READLINE)
-- Configuring incomplete, errors occurred!
則需要安裝 yum -y install ncurses-devel -y *******而且删除掉 CMakeCache.txt 這個檔案。重新再編譯一次就OK
5 make && make install
6. 建立mysql使用者和mysql組
groupadd mysql
useradd -s /sbin/nologin -g mysql -M mysql
-M:不建立家目錄
7.修改/usr/local/mysql權限chown -R mysql:mysql /usr/local/mysql
8.。。
進入安裝路徑,執行初始化配置腳本,建立系統自帶的資料庫和表
cd /usr/local/mysqlscripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
9 啟動資料庫
/usr/local/mysql/bin/mysqld_safe &
10 添加服務,拷貝服務腳本到init.d目錄
cp support-files/mysql.server /etc/init.d/mysqld
chkconfig mysql on
/etc/init.d/mysqld start
11 配置mysql全局使用路徑
vim /etc/profile
增加 PATH=$PATH:/usr/local/mysql/bin/
echo $PATH
12: source /etc/profile
使路徑生效
13 mysql登陸指令
mysql -u root -p
修改mysql登陸密碼(預設為空)
mysqladmin -u root password '123456'
15檢視系統自帶表
mysql>show databases;
16 若要設定root使用者可以遠端通路,執行
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.%' IDENTIFIED BY '123456' WITH GRANT OPTION; 紅色的password為遠端通路時,root使用者的密碼,可以和本地不同。
17 防火牆的3306端口預設沒有開啟,若要遠端通路,需要開啟這個端口
Vim /etc/sysconfig/iptables-A INPUT -m state --state NEW -m tcp -p -dport 3306 -j ACCEPT