您好,登錄后才能下訂單哦!
下文我給大家簡單講講關(guān)于mysql數(shù)據(jù)庫采用源碼安裝教程,大家之前了解過相關(guān)類似主題內(nèi)容嗎?感興趣的話就一起來看看這篇文章吧,相信看完mysql數(shù)據(jù)庫采用源碼安裝教程對大家多少有點幫助吧。
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è)置字符校驗集 -DDOWNLOAD_BOOST=1 \ -DWITH_BOOST=/usr/local/boost #指定Boost擴展源碼路徑
---------------------------------------------------------------
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賬號登陸系統(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
進入/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
進入安裝路徑,執(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目錄,可以使用下面這個
#[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 (密碼是隨機產(chǎn)生的,每臺機器產(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隨機密碼啦
接下來,啟動數(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: # 輸入剛剛的隨機密碼鏈接數(shù)據(jù)庫 mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '新密碼';
大家覺得mysql數(shù)據(jù)庫采用源碼安裝教程這篇文章怎么樣,是否有所收獲。如果想要了解更多相關(guān),可以繼續(xù)關(guān)注我們的行業(yè)資訊板塊。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。