cmake編譯安裝mysql5.5

CMAKE方式編譯安裝MySQL5.5

創(chuàng)新互聯(lián)專注于網(wǎng)站建設(shè)，為客戶提供成都網(wǎng)站設(shè)計(jì)、成都網(wǎng)站制作、網(wǎng)頁設(shè)計(jì)開發(fā)服務(wù)，多年建網(wǎng)站服務(wù)經(jīng)驗(yàn)，各類網(wǎng)站都可以開發(fā)，成都品牌網(wǎng)站建設(shè)，公司官網(wǎng)，公司展示網(wǎng)站，網(wǎng)站設(shè)計(jì)，建網(wǎng)站費(fèi)用，建網(wǎng)站多少錢，價(jià)格優(yōu)惠，收費(fèi)合理。

1、源碼cmake方式編譯安裝MySQL5.5.32

安裝前先安裝：

yum install ncurses-devel -y

1.1 下載Mysql和cmake安裝包：

wget http://wwwNaNake.org/files/v2.8/cmake-2.8.8.tar.gz

1.2 查看系統(tǒng)環(huán)境

cat /etc/redhat-release

uname -r

uname -m

1.3 安裝cmake包

tar zxf cmake-2.8.8.tar.gz

cd cmake-2.8.8

./configure

gmake

gmake install

cd ../

1.4 開始安裝mysql

1.4.1 創(chuàng)建用戶和組

groupadd mysql

useradd mysql -s /sbin/nologin -M -g mysql

yum install ncurses-devel -y

1.4.2 解壓編譯MySQL

tar zxf mysql-5.5.32.tar.gz

cd mysql-5.5.32

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\

-DDEFAULT_CHARSET=gbk\

-DDEFAULT_COLLATION=gbk_chinese_ci\

-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

make

make install

ln -s /application/mysql-5.5.32/ /application/mysql

如果上述操作未出現(xiàn)錯(cuò)誤，則MySQL軟件的安裝就算成功了。

1.4.3 初始化配置MySQL

1.查看默認(rèn)模板配置文件

[root@Mysqlmysql-5.5.32]# ll support-files/my*.cnf

-rw-r--r--1 root root 4759 Apr 25 18:19support-files/my-huge.cnf

-rw-r--r--1 root root 19809 Apr 25 18:19 support-files/my-innodb-heavy-4G.cnf

-rw-r--r--1 root root 4733 Apr 25 18:19support-files/my-large.cnf

-rw-r--r--1 root root 4744 Apr 25 18:19support-files/my-medium.cnf

-rw-r--r--1 root root 2908 Apr 25 18:19support-files/my-small.cnf

2.選擇配置文件

/bin/cpsupport-files/my-small.cnf /etc/my.cnf

測(cè)試環(huán)境選小的，生產(chǎn)環(huán)境可以根據(jù)硬件選擇support-files/my-innodb-heavy-4G.cnf

3.配置環(huán)境變量

echo 'export PATH=/application/mysql/bin:$PATH' >>/etc/profile

tail -1 /etc/profile

source /etc/profile

echo $PATH

4.初始化數(shù)據(jù)文件（容易出錯(cuò)的步驟）

#建立mysql數(shù)據(jù)文件目錄

mkdir -p /application/mysql/data

#授權(quán)mysql用戶訪問mysql的安裝目錄

chown -R mysql.mysql /application/mysql/*

chmod -R 1777 /tmp

#初始化數(shù)據(jù)庫文件(如果重新初始化數(shù)據(jù)庫文件，必須先執(zhí)行：rm -fr /application/mysql/data/*)

/application/mysql/scripts/mysql_install_db --basedir=/application/mysql--datadir=/application/mysql/data --user=mysql

特別提示：

a.如果用mysql 5.0，5.1省略指定datadir會(huì)出錯(cuò)。

5.設(shè)置常規(guī)方式啟動(dòng)關(guān)閉腳本

cd /application/tools/mysql-5.5.32/

#拷貝mysql啟動(dòng)腳本到/etc/init.d/下

cp support-files/mysql.server /etc/init.d/mysqld

#授權(quán)700權(quán)限，即腳本可執(zhí)行

chmod 700 /etc/init.d/mysqld

/etc/init.d/mysqldstart

chkconfig mysqld on

chkconfig --list mysqld

6.登錄mysql

7.簡(jiǎn)單優(yōu)化mysql

a.刪除test庫：

mysql>show databases;

+--------------------+

|Database |

+--------------------+

|information_schema |

|mysql |

|performance_schema |

|test |

+--------------------+

4 rowsin set (0.03 sec)

mysql>drop database test;

Query OK, 0 rows affected (0.04 sec)

mysql>show databases;

+--------------------+

|Database |

+--------------------+

|information_schema |

|mysql |

|performance_schema |

+--------------------+

3 rowsin set (0.00 sec)

b.清除并修改管理員用戶

mysql>select user,host from mysql.user;

+------+-----------+

| user| host |

+------+-----------+

| root| 127.0.0.1 |

| root| ::1 |

| | Mysql |

| root| Mysql |

| | localhost |

| root| localhost |

+------+-----------+

6 rowsin set (0.00 sec)

mysql>delete from mysql.user;

QueryOK, 6 rows affected (0.07 sec)

mysql>select user,host from mysql.user;

Emptyset (0.00 sec)

mysql>grant all privileges on *.* to system@'localhost' identified by '1234' withgrant option;

QueryOK, 0 rows affected (0.00 sec)

mysql>flush privileges;

QueryOK, 0 rows affected (0.00 sec)

mysql>grant all privileges on *.* to system@'127.0.0.1' identified by '1234' withgrant option;

QueryOK, 0 rows affected (0.00 sec)

mysql>select user,host from mysql.user;

+--------+-----------+

|user | host |

+--------+-----------+

|system | 127.0.0.1 |

|system | localhost |

+--------+-----------+

2 rowsin set (0.00 sec)

操作過程：

[root@mysqltools]# cat /etc/redhat-release

CentOSrelease 6.4 (Final)

[root@mysqltools]# uname -r

2.6.32-358.el6.x86_64

[root@mysqltools]# uname -m

x86_64

[root@mysqltools]# tar zxf cmake-2.8.8.tar.gz

[root@mysqltools]# cd cmake-2.8.8

[root@mysqlcmake-2.8.8]# ./configure

CMakehas bootstrapped. Now run gmake.

[root@Mysqlcmake-2.8.8]# gmake

[root@Mysqlcmake-2.8.8]# gmake install

[root@Mysqlapplication]# groupadd mysql

[root@Mysqlapplication]# useradd mysql -s /sbin/nologin -M -g mysql

[root@Mysqltools]# tar zxf mysql-5.5.32.tar.gz

[root@Mysqltools]# cd mysql-5.5.32

[root@Mysqlmysql-5.5.32]# cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32 \

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\

-DDEFAULT_CHARSET=gbk\

-DDEFAULT_COLLATION=gbk_chinese_ci\

-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

#Build files have been written to: /application/tools/mysql-5.5.32 如果顯示這個(gè)表示cmake成功

[root@Mysqlmysql-5.5.32]# make

[root@Mysqlmysql-5.5.32]# make install

[root@Mysqlmysql-5.5.32]# ln -s /application/mysql-5.5.32//application/mysql

[root@Mysqlmysql-5.5.32]# ll support-files/my*.cnf

-rw-r--r--1 root root 4759 Apr 25 18:19support-files/my-huge.cnf

-rw-r--r--1 root root 19809 Apr 25 18:19 support-files/my-innodb-heavy-4G.cnf

-rw-r--r--1 root root 4733 Apr 25 18:19support-files/my-large.cnf

-rw-r--r--1 root root 4744 Apr 25 18:19support-files/my-medium.cnf

-rw-r--r--1 root root 2908 Apr 25 18:19support-files/my-small.cnf

[root@Mysqlmysql-5.5.32]# cp support-files/my-small.cnf /etc/my.cnf

[root@Mysqlmysql-5.5.32]# echo 'export PATH=/application/mysql/bin:$PATH'>>/etc/profile

[root@Mysqlmysql-5.5.32]# tail -1 /etc/profile

exportPATH=/application/mysql/bin:$PATH

[root@Mysqlmysql-5.5.32]# source /etc/profile

[root@Mysqlmysql-5.5.32]# echo $PATH

/application/mysql/bin:/application/mysql/bin/:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

[root@Mysqlmysql-5.5.32]# mkdir -p /application/mysql/data

[root@Mysqlmysql-5.5.32]# chown -R mysql.mysql /application/mysql/*

[root@Mysqlmysql-5.5.32]# chmod -R 1777 /tmp

[root@Mysqlmysql-5.5.32]# /application/mysql/scripts/mysql_install_db--basedir=/application/mysql --datadir=/application/mysql/data--user=mysql

[root@Mysqlmysql-5.5.32]# cp support-files/mysql.server /etc/init.d/mysqld

[root@Mysqlmysql-5.5.32]# chmod 700 /etc/init.d/mysqld

[root@Mysqlmysql-5.5.32]# chkconfig mysqld on

[root@Mysqlmysql-5.5.32]# chkconfig --list mysqld

mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off

root@Mysqlmysql-5.5.32]# mysql

Welcometo the MySQL monitor. Commands end with; or \g.

YourMySQL connection id is 2

Serverversion: 5.5.32 Source distribution

Oracleis a registered trademark of Oracle Corporation and/or its

affiliates.Other names may be trademarks of their respective

owners.

Type'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

簡(jiǎn)單優(yōu)化mysql

a.刪除test庫：

mysql>show databases;

+--------------------+

|Database |

+--------------------+

|information_schema |

|mysql |

|performance_schema |

|test |

+--------------------+

4 rowsin set (0.03 sec)

mysql>drop database test;

QueryOK, 0 rows affected (0.04 sec)

mysql>show databases;

+--------------------+

|Database |

+--------------------+

|information_schema |

|mysql |

|performance_schema |

+--------------------+

3 rowsin set (0.00 sec)

b.清除并修改管理員用戶

mysql>select user,host from mysql.user;

+------+-----------+

| user| host |

+------+-----------+

| root| 127.0.0.1 |

| root| ::1 |

| | Mysql |

| root| Mysql |

| | localhost |

| root| localhost |

+------+-----------+

6 rowsin set (0.00 sec)

mysql>delete from mysql.user;

Query OK, 6 rows affected (0.07 sec)

mysql>select user,host from mysql.user;

Emptyset (0.00 sec)

mysql>grant all privileges on *.* to system@'localhost' identified by '1234' withgrant option;

Query OK, 0 rows affected (0.00 sec)

mysql>flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql>grant all privileges on *.* to system@'127.0.0.1' identified by '1234' withgrant option;

Query OK, 0 rows affected (0.00 sec)

mysql>select user,host from mysql.user;

+--------+-----------+

|user | host |

+--------+-----------+

|system | 127.0.0.1 |

|system | localhost |

+--------+-----------+

2 rowsin set (0.00

1、CMAKE安裝Mysql時(shí)遇到的問題：

--Check size of wint_t - done

--Could NOT find Curses (missing: CURSES_LIBRARY CURSES_INCLUDE_PATH)

CMakeError at cmake/readlineNaNake:83 (MESSAGE):

Curses library not found. Please install appropriate package,

remove CMakeCache.txt and rerun cmake.OnDebian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it isncurses-devel.

CallStack (most recent call first):

cmake/readlineNaNake:127 (FIND_CURSES)

cmake/readlineNaNake:217(MYSQL_USE_BUNDLED_LIBEDIT)

CMakeLists.txt:269 (MYSQL_CHECK_READLINE)

--Configuring incomplete, errors occurred!

解決方法：

rm CMakeCache.txt

yum install ncurses-devel -y

然后再cmake

當(dāng)前標(biāo)題：cmake編譯安裝mysql5.5
分享地址：http://muchs.cn/article38/ghidpp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供自適應(yīng)網(wǎng)站、虛擬主機(jī)、搜索引擎優(yōu)化、App開發(fā)、網(wǎng)站設(shè)計(jì)公司、網(wǎng)站收錄

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容