redhat centos，redhat 6.5 【源碼編譯安裝 mysql-5.5.47】

操作系統：Redhat Enterprise Linux 6.5

一. 創建用戶、目錄和修改權限

[root@xuegod64 ~]#mkdir -p /usr/local/mysql/data[root@xuegod64 ~]#groupadd mysql[root@xuegod64 ~]#useradd -g mysql mysql[root@xuegod64 ~]#chown -R mysql.mysql /usr/local/mysql/data/　

?

redhat centos，二. 安裝所需相關庫文件

[root@xuegod64 ~]#yum install -y gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* cmake

?

三、解壓mysql-mysql-5.5.47

[root@xuegod64 ~]#tar -zxvf mysql-5.5.47.tar.gz

?

redhat虛擬機、四、編譯安裝

[root@xuegod64 ~]#cd mysql-5.5.47[root@xuegod64 mysql-5.5.47]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql[root@xuegod64 mysql-5.5.47]# make && make install[root@xuegod64 mysql-5.5.47]# cp /usr/local/mysql/support-files/my-large.cnf /etc/my.cnf

?

五、初始化數據庫

[root@xuegod64 mysql-5.5.47]#cd /usr/local/mysql/[root@xuegod64 mysql]# scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/

?

mysql源碼編譯、六、設置啟動腳本位置及開機啟動

?

[root@xuegod64 mysql]#cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@xuegod64 mysql]#chkconfig mysqld on

　　

七、添加環境變量

[root@xuegod64 mysql]# echo 'export PATH=/usr/local/mysql/bin:$PATH' >> /etc/profile
[root@xuegod64 mysql]# source /etc/profile

redhat7.4安裝教程，?

八、啟動mysql服務

[root@xuegod64 ]# /etc/init.d/mysql start

?

九、安裝完成修改mysql密碼和遠程訪問

[root@xuegod64 ]# mysql -u root -p
Enter password:       默認無密碼，直接回車
mysql>use mysql;
mysql> update user set password=password("123456");  //修改密碼
mysql> update user set `host` = '%' where `user` = 'root' limit 1;   //修改可遠程訪問
mysql > exit  //退出

redhat7？?

十、重啟Mysql

[root@xuegod64 ]# /etc/init.d/mysqld restart

?