MySql單機(jī)安裝-創(chuàng)新互聯(lián)

下載mysql

mysql-5.7.11-linux-glibc2.5-x86_64.tar.gz
湘橋網(wǎng)站建設(shè)公司創(chuàng)新互聯(lián)建站,湘橋網(wǎng)站設(shè)計(jì)制作，有大型網(wǎng)站制作公司豐富經(jīng)驗(yàn)。已為湘橋近1000家提供企業(yè)網(wǎng)站建設(shè)服務(wù)。企業(yè)網(wǎng)站搭建\外貿(mào)營(yíng)銷網(wǎng)站建設(shè)要多少錢，請(qǐng)找那個(gè)售后服務(wù)好的湘橋做網(wǎng)站的公司定做！

初始操作

# 解壓
tar xzvf mysql-5.7.11-linux-glibc2.5-x86_64.tar.gz

# 遷移到指定目錄
mv mysql-5.7.11-linux-glibc2.5-x86_64 /data/mysql

# 根目錄創(chuàng)建文件夾
cd /data/mysql
mkdir arch data tmp

創(chuàng)建mysql的配置文件

vi /etc/my.cnf

[client]
port            = 3306
socket          = /data/mysql/data/mysql.sock

[mysqld]
port            = 3306
socket          = /data/mysql/data/mysql.sock

skip-external-locking
key_buffer_size = 256M
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 4M
query_cache_size= 32M
max_allowed_packet = 16M
myisam_sort_buffer_size=128M
tmp_table_size=32M

table_open_cache = 512
thread_cache_size = 8
wait_timeout = 86400
interactive_timeout = 86400
max_connections = 600

# Try number of CPU's*2 for thread_concurrency
#thread_concurrency = 32

#isolation level and default engine 
default-storage-engine = INNODB
transaction-isolation = READ-COMMITTED

server-id  = 1
basedir     = /data/mysql
datadir     = /data/mysql/data
pid-file     = /data/mysql/data/hostname.pid

#open performance schema
log-warnings
sysdate-is-now

binlog_format = MIXED
log_bin_trust_function_creators=1
log-error  = /data/mysql/data/hostname.err
log-bin=/data/mysql/arch/mysql-bin
#other logs
#general_log =1
#general_log_file  = /data/mysql/data/general_log.err
#slow_query_log=1
#slow_query_log_file=/data/mysql/data/slow_log.err

#for replication slave
#log-slave-updates 
#sync_binlog = 1

#for innodb options 
innodb_data_home_dir =/data/mysql/data/
innodb_data_file_path = ibdata1:500M:autoextend
innodb_log_group_home_dir = /data/mysql/arch
innodb_log_files_in_group = 4
innodb_log_file_size = 1G

#生產(chǎn)上 機(jī)械硬盤 sata盤 5000r轉(zhuǎn) 7200 10000 15000 ==>ssd 生產(chǎn)
# innodb_buffer_pool_size 調(diào)大 16G,一般是8G （調(diào)優(yōu)的時(shí)候一般是這個(gè)地方）

innodb_buffer_pool_size = 16G 
#innodb_additional_mem_pool_size = 50M
innodb_log_buffer_size = 200M


innodb_lock_wait_timeout = 100
#innodb_thread_concurrency = 0
innodb_flush_log_at_trx_commit = 1
innodb_locks_unsafe_for_binlog=1

#innodb io features: add for mysql5.5.8
performance_schema
innodb_read_io_threads=4
innodb-write-io-threads=4
innodb-io-capacity=200
#purge threads change default(0) to 1 for purge
innodb_purge_threads=1
innodb_use_native_aio=on

#case-sensitive file names and separate tablespace
innodb_file_per_table = 1
lower_case_table_names=1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[mysqlhotcopy]
interactive-timeout

[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

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

# 創(chuàng)建用戶組和用戶
groupadd -g 101 dba
useradd -u 514 -g dba -G root -d /data/mysql mysqladmin

# copy環(huán)境變量配置文件至mysqladmin用戶的home目錄中，為以下步驟配置個(gè)人環(huán)境變量
cp /etc/skel/.* /data/mysql

su - mysqladmin (這樣進(jìn)去的環(huán)境開頭不是-bash這些)

# 配置環(huán)境變量及切換mysqladmin用戶后的路徑
vi /data/mysql/.bash_profile
替換為
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
  . ~/.bashrc
fi

# User specific environment and startup programs

#PATH=$PATH:$HOME/.local/bin:$HOME/bin

#export PATH
         
export MYSQL_BASE=/data/mysql
export PATH=${MYSQL_BASE}/bin:$PATH   

unset UAERNAME
set umask to 022
umask 022
PS1=`uname -n`":"'$USER'":"'$PWD'":>"; export PS1


# 賦予權(quán)限
chown mysqladmin:dba /etc/my.cnf
chmod 640 /etc/my.cnf
chown -R mysqladmin:dba /data/mysql
chmod -R 755 /data/mysql

配置服務(wù)及開機(jī)自啟動(dòng)

cd /data/mysql
# 將服務(wù)名拷貝到init.d下，并重命名mysql
cp support-files/mysql.server /etc/rc.d/init.d/mysql
# 賦予可執(zhí)行權(quán)限
chmod +x /etc/rc.d/init.d/mysql
# 刪除服務(wù)
chkconfig --del mysql
# 添加服務(wù)
chkconfig --add mysql
chkconfig --level 345 mysql on

# 安裝libaio及安裝mysql的初始db
yum -y install libaio
su - mysqladmin

# 初始化mysql
bin/mysqld --defaults-file=/etc/my.cnf --user=mysqladmin --basedir=/data/mysql/ --datadir=/data/mysql/data/ --initialize

修改密碼

# 查看臨時(shí)密碼(把零食密碼記錄一下)
cd data
ll
cat hostname.err |grep password

>>>JI8gWBlKbs,&

# 啟動(dòng)(到mysql主目錄下)
/data/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf &

# 測(cè)試mysql
service mysql status
service mysql restart


# 登錄及修改臨時(shí)用戶密碼(-p后面千萬別有空格)
mysql -uroot -p'前面的臨時(shí)密碼'
show databases; (報(bào)錯(cuò)說需要重置密碼)
# 重置密碼
alter user root@localhost identified by 'mysql!@#';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql!@#';

你是否還在尋找穩(wěn)定的海外服務(wù)器提供商？創(chuàng)新互聯(lián)www.cdcxhl.cn海外機(jī)房具備T級(jí)流量清洗系統(tǒng)配攻擊溯源，準(zhǔn)確流量調(diào)度確保服務(wù)器高可用性，企業(yè)級(jí)服務(wù)器適合批量采購(gòu)，新人活動(dòng)首月15元起，快前往官網(wǎng)查看詳情吧

網(wǎng)頁(yè)標(biāo)題：MySql單機(jī)安裝-創(chuàng)新互聯(lián)
URL分享：http://www.muchs.cn/article44/dsssee.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站設(shè)計(jì)、外貿(mào)網(wǎng)站建設(shè)、微信公眾號(hào)、品牌網(wǎng)站設(shè)計(jì)、網(wǎng)站內(nèi)鏈、企業(yè)網(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)容