make安裝mysql

標籤：mysql   使用者   

yum install -y gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel*    //安裝編譯環境gcc

rz上傳cmake-2.8.8.tar.gz和mysql-5.5.32.tar.gz

tar xf cmake-2.8.8.tar.gz   //解壓make

cd cmake-2.8.8   //進入cmake目錄

./configure    //編譯cmake

gmake    //安裝gmake

gmake install //安裝gmake

cd ..  //退出cmake目錄

groupadd mysql   //建立組

useradd mysql -s /sbin/nologin -M -g mysql   //建立使用者屬於mysql組

tar xf mysql-5.5.32.tar.gz  //解壓mysql

cd mysql-5.5.32   //進入mysql目錄

輸入以下內容並斷行符號

cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32 \

-DMYSQL_DATADIR=/application/mysql-5.5.32/data \

-DMYSQL_UNIX_ADDR=/application/mysql-5.5.32/tmp/mysql.sock \

-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii \

-DENABLED_LOCAL_INFILE=ON \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_FEDERATED_STORAGE_ENGINE=1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \

-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \

-DWITH_FAST_MUTEXES=1 \

-DWITH_ZLIB=bundled \

-DENABLED_LOCAL_INFILE=1 \

-DWITH_READLINE=1 \

-DWITH_EMBEDDED_SERVER=1 \

-DWITH_DEBUG=0

make && make install  //安裝mysql

ln -s /application/mysql-5.5.32/ /application/mysql  //建立軟串連

cd ..  //退出mysql目錄

cp mysql-5.5.32/support-files/my-small.cnf /etc/my.cnf

echo ‘export PATH=/application/mysql/bin:$PATH‘ >>/etc/profile   //編輯環境變數

source /etc/profile  //即時生效

chown -R mysql.mysq /application/mysql/data/   //使用者賦權

chmod -R 1777 /tmp/  //檔案夾賦權

cd /application/mysql/scripts/    //進入初始化目錄

./mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysql   //初始化mysql

cd ..   //退出

cd /home/oldboy/tools/mysql-5.5.32   //進入目錄

cp support-files/mysql.server /etc/init.d/mysqld  //建立開機自開機檔案

chmod +x /etc/init.d/mysqld   //檔案夾賦權

/etc/init.d/mysqld start   //啟動mysql服務

mysql   //進入mysql

select user,host from mysql.user;   //查看是否有空使用者

delete from mysql.user where user=‘‘;   //刪除空使用者

delete from mysql.user where host=‘::1‘;   //刪除::1

quit  //退出mysql

/application/mysql//bin/mysqladmin -u root password ‘oldboy123‘    //添加密碼

chkconfig mysqld on   //設定開機啟動

mysql -uroot -poldboy123   //測試是否可以進入，密碼是否正確

本文出自 “11104762” 部落格，請務必保留此出處http://11114762.blog.51cto.com/11104762/1812556

make安裝mysql