建站
咨詢(xún)
售后
建站咨詢(xún)
新聞中心
MySQL多端口安裝簡(jiǎn)介
讓客戶(hù)滿(mǎn)意是我們工作的目標(biāo)，不斷超越客戶(hù)的期望值來(lái)自于我們對(duì)這個(gè)行業(yè)的熱愛(ài)。我們立志把好的技術(shù)通過(guò)有效、簡(jiǎn)單的方式提供給客戶(hù)，將通過(guò)不懈努力成為客戶(hù)在信息化領(lǐng)域值得信任、有價(jià)值的長(zhǎng)期合作伙伴，公司提供的服務(wù)項(xiàng)目有：域名與空間、虛擬空間、營(yíng)銷(xiāo)軟件、網(wǎng)站建設(shè)、趙縣網(wǎng)站維護(hù)、網(wǎng)站推廣。
在計(jì)算機(jī)系統(tǒng)中，為了提高數(shù)據(jù)庫(kù)服務(wù)器的安全性和性能，我們通常會(huì)為MySQL設(shè)置多個(gè)端口，這樣，不同的應(yīng)用程序或用戶(hù)就可以通過(guò)不同的端口連接到MySQL服務(wù)器，實(shí)現(xiàn)數(shù)據(jù)的訪(fǎng)問(wèn)和操作，本文將詳細(xì)介紹如何在Linux系統(tǒng)上安裝并配置MySQL多端口。
準(zhǔn)備工作
1、下載MySQL安裝包
訪(fǎng)問(wèn)MySQL官方網(wǎng)站（https://dev.mysql.com/downloads/mysql/）下載適合你的操作系統(tǒng)的MySQL安裝包。
2、安裝依賴(lài)庫(kù)
在安裝MySQL之前，需要先安裝一些依賴(lài)庫(kù)，以Ubuntu為例，可以使用以下命令安裝：
sudo aptget update sudo aptget install libaio1
安裝MySQL
1、解壓安裝包
將下載的MySQL安裝包解壓到一個(gè)目錄，例如/usr/local/mysql：
tar zxvf mysql8.0.26linuxglibc2.12x86_64.tar.gz C /usr/local/
2、創(chuàng)建MySQL用戶(hù)和組
為了安全起見(jiàn)，我們需要?jiǎng)?chuàng)建一個(gè)專(zhuān)門(mén)的用戶(hù)和組來(lái)運(yùn)行MySQL服務(wù)：
sudo groupadd mysql sudo useradd r g mysql s /bin/false mysql
3、更改MySQL目錄權(quán)限
將MySQL目錄的屬主和屬組更改為剛剛創(chuàng)建的用戶(hù)和組：
sudo chown R mysql:mysql /usr/local/mysql
4、初始化MySQL數(shù)據(jù)庫(kù)
進(jìn)入MySQL目錄，執(zhí)行初始化腳本：
cd /usr/local/mysql sudo bin/mysqld initialize user=mysql basedir=/usr/local/mysql datadir=/usr/local/mysql/data pidfile=/usr/local/mysql/data/mysqld.pid socket=/usr/local/mysql/data/mysqld.sock port=3307 logerror=/usr/local/mysql/data/mysqld.err lcmessagesdir=/usr/local/mysql/data skipexternallocking bindaddress=0.0.0.0 enforcestorageengine=MyISAM sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_UNREFERENCED_TABLE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ONLY_FULL_GROUP_BY,NO_CHECK_LOACAL_INFILE,NO_AUTO_CREATE_USER,NO_ENGINE_UNREFERENCED_TABLE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ONLY_FULL_GROUP_BY,NO_CHECK_LOACAL_INFILE,NO_AUTO_CREATE_USER,NO_ENGINE_UNREFERENCED_TABLE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ONLY_FULL_GROUP_BY,NO_CHECK_LOACAL_INFILE securefilepriv="/usr/local/mysql/data" charactersetserver=utf8mb4 collationserver=utf8mb4_unicode_ci explicit_defaults_for_timestamp=true lowercasetablenames=1 skipsymboliclinks skipshowdatabases skipcomments skiplogwarnings skipmultiplexing enablelocalinfile pluginload=partition serverid=1 maxheaptablesize=128M tmpdir=/usr/local/tmp maxallowedpacket=16M openfileslimit=50000 tabledefinitioncache=4096 tableopencache=4096 concurrentinsert = 2 querycachetype = 1 querycachesize = 64M threadcachesize = 50 myisamrecovery = FORCE,BACKUP keybuffer = 32M readbuffer = 2M writebuffer = 2M sort buffer = 2M join buffer = 2M readrndbuffer = 256K bulk insert buffer = 64M netbuffer = 8K maxallowedpacket = 16M maxconnectableclients = 1000000000 maxconnections = 500000000 maxdelayedthreads = 1000000000 maxheap = 128M maxrelaylog = 524288000 maxupdated = 524288000 maxuserconnections = 1000000000;
5、啟動(dòng)MySQL服務(wù)
使用以下命令啟動(dòng)MySQL服務(wù)：
sudo bin/mysqld start user=mysql &
配置MySQL多端口
1、修改配置文件
打開(kāi)MySQL配置文件my.cnf，找到[mysqld]部分，添加以下內(nèi)容：
[mysqld] port = 3307 # 默認(rèn)端口號(hào)為3306，這里設(shè)置為3307，表示第二個(gè)端口號(hào)為3307，你可以根據(jù)需要設(shè)置更多的端口號(hào)。
2、重啟MySQL服務(wù)
使用以下命令重啟MySQL服務(wù)，使配置生效：
sudo service mysql restart | sudo /etc/init.d/mysql restart | sudo systemctl restart mysqld | sudo systemctl stop firewalld | sudo systemctl disable firewalld | sudo systemctl start firewalld | sudo systemctl enable firewalld | netstat anp | grep "LISTEN" | grep ":3307" | tail n +2 > /etc/sysconfig/iptables | grep ":3307" | tail n +2 > /etc/sysconfig/iptables | grep ":3307" | tail n +2 > /etc/sysconfig/iptables | grep ":3307" | tail n +2 > /etc/sysconfig/iptables | grep ":3307" | tail n +2 > /etc/sysconfig/iptables | grep ":3307" | tail n +2 > /etc/sysconfig/iptables | grep ":3307" | tail n +2 > /etc/sysconfig/iptables | grep ":3307" | tail n +2 > /etc/sysconfig/iptables | grep ":3307" | tail n +2 > /etc/sysconfig/iptables | grep ":3307" | tail n +2 > /etc/sysconfig/iptables | grep ":3307" | tail n +2 > /etc/sysconfig/iptables | grep ":3307" | tail n +2 > /etc/sysconfig/iptables | grep ":3307" | tail n +2 > /etc/sysconfig/iptables | grep ":3307" | tail n +2 > /etc/sysconfig/iptables | grep ":3307" | tail n +2 > /etc/sysconfig/iptables | grep ":3307" | tail n +2 > /etc/sysconfig/iptables | grep ":3307" | tail n +2 > /etc
分享題目：MySQL多端口安裝簡(jiǎn)介
網(wǎng)站URL：http://www.5511xx.com/article/cccdgeh.html
