Centos編譯安裝mysql5.6.21_MySQL

來源：懂視網責編：小采時間：2020-11-09 19:47:40

Centos編譯安裝mysql5.6.21_MySQL

Centos編譯安裝mysql5.6.21_MySQL:1.yum安裝各個依賴包 [root@WebServer ~]# yum -y install gcc gcc-devel gcc-c++ gcc-c++-devel autoconf* automake* zlib* libxml* ncurses-devel ncurses libgcrypt* libtool* cmake openssl op

推薦度：

點擊下載本文 文檔為doc格式

導讀Centos編譯安裝mysql5.6.21_MySQL:1.yum安裝各個依賴包 [root@WebServer ~]# yum -y install gcc gcc-devel gcc-c++ gcc-c++-devel autoconf* automake* zlib* libxml* ncurses-devel ncurses libgcrypt* libtool* cmake openssl op

1.yum安裝各個依賴包

[root@WebServer ~]# 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

mkdir -p /opt/mysql/data

mkdir -p /opt/mysql/etc

mkdir -p /opt/mysql/log

3.更改mysql目錄的權限為自己當前用戶（我的用戶名是mysql）

chown mysql.mysql /opt/mysql

chown mysql.mysql /opt/mysql/data -

4.解壓mysql-5.6.21.tar.gz源碼包

tar zxvf ~/下載/mysql-5.6.21.tar.gz -C /usr/local/src/

chown mysql.mysql /usr/share/src/mysql-5.6.21

hown mysql.mysql /usr/share/src/mysql-5.6.21/ -R

5.下載gmock-1.6.0.zip，解壓至源碼中的source_downloads目錄下

http://bbs.ithome.com/forum.php?mod=attachment&aid=NTk1MjYwfGNkYzNjZDM0fDE0MTM4NTU1MzR8MjA5NDI5Nnw2Mzg1NTA%3D

unzip ~/下載/gmock-1.6.0.zip

mv gmock-1.6.0 /usr/local/src/mysql-5.6.21/source_downloads/

cd /usr/local/src/mysql-5.6.21/source_downloads/gmock-1.6.0

./configure

make

cd ../../

6.編譯安裝

cmake \-DCMAKE_INSTALL_PREFIX=/opt/mysql \-DMYSQL_DATADIR=/opt/mysql/database \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_MEMORY_STORAGE_ENGINE=1 \-DWITH_ARCHIVE_STORAGE_ENGINE=1 \-DWITH_PARTITION_STORAGE_ENGINE=1 \-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \-DWITH_READLINE=1 \-DENABLE_DOWNLOADS=1 \-DENABLED_LOCAL_INFILE=1 \-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \-DMYSQL_TCP_PORT=3306 \-DEXTRA_CHARSETS=all \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci
make

make install

7.創建配置文件

cp /opt/mysql/support-files/my-default.cnf /opt/mysql/etc/my.cnf

[root@master support-files]# cat /opt/mysql/etc/my.cnf

[mysqld]

datadir = /opt/mysql

datadir = /opt/mysql/data

#socket = /tmp/mysql.sock

socket = /opt/mysql/data/mysql.sock

#log = /opt/mysql/log/mysql.log

pid-file = /opt/mysql/data/mysql.pid

user = mysql

port = 3306

#tmpdir = /tmp

log-error = /opt/mysql/log/mysql.err

[client]

socket = /opt/mysql/data/mysql.sock

8.初始化數據庫

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

9.創建管理MySQL數據庫的shell腳本

root@master support-files]# cp mysql.server /etc/init.d/mysql

[root@master support-files]# chmod +x /etc/init.d/mysql

[root@master support-files]# service mysql start

Starting MySQL.. [確定]

[root@master support-files]#

10.設置MySQL root用戶的密碼

/opt/msql/bin/mysqladmin -u root password 123123 #修改mysql數據庫的root賬戶密碼是123123

11.登錄mysql

[root@master support-files]# mysql -uroot -p123123

Warning: Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.6.21 Source distribution

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is 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.

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com

Centos編譯安裝mysql5.6.21_MySQL

推薦度：

點擊下載本文 文檔為doc格式

標簽： 21 mysql centos

熱門焦點

国产99久久精品_欧美日本韩国一区二区_激情小说综合网_欧美一级二级视频_午夜av电影_日本久久精品视频

Centos編譯安裝mysql5.6.21_MySQL

Centos編譯安裝mysql5.6.21_MySQL

Centos編譯安裝mysql5.6.21_MySQL

最新推薦

猜你喜歡

熱門推薦