Mysql的編譯安裝

一、安裝編譯工具及庫文件

yum -y install gcc gcc-c++ make autoconf libtool-ltdl-devel gd-devel freetype-devel libxml2-devel libjpeg-devel libpng-devel openssl-devel curl-devel bison patch unzip libmcrypt-devel libmhash-devel ncurses-devel sudo bzip2 flex libaio-devel

二、安裝cmake 編譯器

cd /usr/local/src

wget https://www.cmake.org/files/v3.1/cmake-3.1.1.tar.gz

tar zxvf cmake-3.1.1.tar.gz

cd cmake-3.1.1

./bootstrap

make && make install

三、編譯安裝

添加用戶

useradd -s /sbin/nologin mysql

建立所需目錄

mkdir -p /data/mysql/data

chown -R mysql:mysql /data/mysql

cd /usr/local/src/

wget https://mirrors.sohu.com/mysql/MySQL-5.5/mysql-5.5.54.tar.gz

tar xzvf mysql-5.5.54.tar.gz

cd mysql-5.5.54

cmake -DMYSQL_USER=mysql -DCMAKE_INSTALL_PREFIX=/usr/local/mysql5.5 -DINSTALL_DATADIR=/data/mysql/data -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1

make && make install

chown -R mysql:mysql /usr/local/mysql5.5/

mv /usr/local/src/mysql-5.5.54/support-files/my-large.cnf /etc/my.cnf

mv /usr/local/src/mysql-5.5.54/support-files/mysql.server /etc/init.d/mysqld

chmod a+x /etc/init.d/mysqld

開啟啟動

chkconfig –level 345 mysqld on

設置環境變量

echo "export PATH=/usr/local/mysql5.5/bin/:$PATH" >> /etc/profile

source /etc/profile

/usr/local/mysql5.5/scripts/mysql_install_db –user=mysql –defaults-file=/etc/my.cnf –basedir=/usr/local/mysql5.5 –datadir=/data/mysql/data

vim /etc/my.cnf

在[mysqld]下面加上

basedir=/usr/local/mysql5.5

datadir=/data/mysql/data

啟動:

service mysqld start

創建mysql管理員

/usr/local/mysql5.5/bin/mysqladmin -u root password 'root'

連接資料庫:

mysql -u root -proot

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。 必填欄位標示為 *