下文我給大家簡(jiǎn)單講講關(guān)于mysql數(shù)據(jù)庫采用源碼安裝教程,大家之前了解過相關(guān)類似主題內(nèi)容嗎?感興趣的話就一起來看看這篇文章吧,相信看完mysql數(shù)據(jù)庫采用源碼安裝教程對(duì)大家多少有點(diǎn)幫助吧。
Mysql數(shù)據(jù)庫采用源碼安裝
[root@server ~]# wget -c http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.17.tar.gz [root@server ~]# tar -zxf mysql-5.7.17.tar.gz [root@server ~]# cd mysql-5.7.17 [root@server mysql-5.7.17]# yum install cmake ncurses-devel -y [root@server mysql-5.7.17]# cmake \ -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ -DMYSQL_DATADIR=/usr/local/mysql/data \ -DSYSCONFDIR=/etc \ -DWITH_MYISAM_STORAGE_ENGINE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_MEMORY_STORAGE_ENGINE=1 \ -DWITH_READLINE=1 \ -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \ #指定套間字路徑 -DMYSQL_TCP_PORT=3306 \ -DENABLED_LOCAL_INFILE=1 \ -DWITH_PARTITION_STORAGE_ENGINE=1 \ -DEXTRA_CHARSETS=all \ -DDEFAULT_CHARSET=utf8 \ #設(shè)置字符集 -DDEFAULT_COLLATION=utf8_general_ci \ #設(shè)置字符校驗(yàn)集 -DDOWNLOAD_BOOST=1 \ -DWITH_BOOST=/usr/local/boost #指定Boost擴(kuò)展源碼路徑
---------------------------------------------------------------
CMake Warning:
Manually-specified variables were not used by the project:
WITH_MEMORY_STORAGE_ENGINE
WITH_READLINE
-- Build files have been written to: /root/mysql-5.7.17
---------------------------------------------------------------
出現(xiàn)上面的結(jié)果表示預(yù)編譯成功!
[root@server mysql-5.7.17]# make -j grep 'processor' /proc/cpuinfo | wc -l [root@server mysql-5.7.17]# make -j grep 'processor' /proc/cpuinfo | wc -l install
檢查系統(tǒng)是否已經(jīng)有mysql用戶,如果沒有則創(chuàng)建
[root@server mysql-5.7.17]# cat /etc/passwd | grep mysql [root@server mysql-5.7.17]# cat /etc/group | grep mysql
創(chuàng)建mysql用戶(但是不能使用mysql賬號(hào)登陸系統(tǒng))
[root@server mysql-5.7.17]# groupadd mysql [root@server mysql-5.7.17]# useradd -g mysql -s /sbin/nologin mysql
修改權(quán)限
[root@server mysql-5.7.17]# chown -R mysql:mysql /usr/local/mysql
[root@server mysql-5.7.17]# cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf [root@server mysql-5.7.17]# vim /etc/my.cnf ################### [mysqld] basedir=/usr/local/mysql datadir=/usr/local/mysql/data socket=/usr/local/mysql/mysql.sock user=mysql #innodb_force_recovery=6 # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 log-bin=mysql-bin server-id = 1 auto_increment_offset=1 auto_increment_increment=2 # Settings user and group are ignored when systemd is used. # If you need to run mysqld under a different user or group, # customize your systemd unit file for mariadb according to the # instructions in http://fedoraproject.org/wiki/Systemd [mysqld_safe] log-error=/usr/local/mysql/mysqld.log pid-file=/usr/local/mysql/mysqld.pid # # include all files from the config directory # !includedir /etc/my.cnf.d
[root@server mysql-5.7.17]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld [root@server mysql-5.7.17]# vim /etc/init.d/mysqld #####添加安裝目錄及數(shù)據(jù)目錄 basedir=/usr/local/mysql datadir=/usr/local/mysql/data
[root@server mysql-5.7.17]# chkconfig --add mysqld [root@server mysql-5.7.17]# chkconfig --level 35 mysqld on
進(jìn)入/etc/profile設(shè)置環(huán)境變量
[root@server mysql-5.7.17]# vim /etc/profile export PATH=/usr/local/mysql/bin:$PATH #在末尾添加 [root@server mysql-5.7.17]# source /etc/profile
進(jìn)入安裝路徑,執(zhí)行初始化配置腳本,創(chuàng)建系統(tǒng)自帶的數(shù)據(jù)庫和表
#mysql5.7之前版本初始化配置表命令:
#script/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql/
#mysql5.7已經(jīng)放棄使用了,而且也沒有script目錄,可以使用下面這個(gè)
#[root@server mysql-5.7.17]# /usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql/
生成的初始密碼位于:
方法一:
[root@server mysql-5.7.17]# grep 'temporary password' /var/log/mysqld.log 2016-07-08T02:25:46.311098Z 1 [Note] A temporary password is generated for root@localhost: MtPqF0/oN5zo
即初始密碼為 MtPqF0/oN5zo (密碼是隨機(jī)產(chǎn)生的,每臺(tái)機(jī)器產(chǎn)生的都不一樣哦)
方法二:
[root@server mysql-5.7.17]# cat /root/.mysql_secret # The random password set for the root userat Fri Jan 10 20:00:34 2014 (local time): aJqZsA2m
這里的aJqZsA2m就是生成的root隨機(jī)密碼啦
接下來,啟動(dòng)數(shù)據(jù)庫,重設(shè)root密碼
[root@server mysql-5.7.17]# /etc/init.d/mysqld start
[root@server mysql-5.7.17]# mysql -uroot -p Enter password: # 輸入剛剛的隨機(jī)密碼鏈接數(shù)據(jù)庫 mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '新密碼';
大家覺得mysql數(shù)據(jù)庫采用源碼安裝教程這篇文章怎么樣,是否有所收獲。如果想要了解更多相關(guān),可以繼續(xù)關(guān)注我們的行業(yè)資訊板塊。
另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn,海內(nèi)外云服務(wù)器15元起步,三天無理由+7*72小時(shí)售后在線,公司持有idc許可證,提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案,具有“安全穩(wěn)定、簡(jiǎn)單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢(shì),專為企業(yè)上云打造定制,能夠滿足用戶豐富、多元化的應(yīng)用場(chǎng)景需求。
網(wǎng)頁標(biāo)題:mysql數(shù)據(jù)庫采用源碼安裝教程-創(chuàng)新互聯(lián)
分享路徑:http://www.chinadenli.net/article12/ccicdc.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供網(wǎng)站制作、電子商務(wù)、云服務(wù)器、品牌網(wǎng)站設(shè)計(jì)、移動(dòng)網(wǎng)站建設(shè)、Google
聲明:本網(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)容