日本综合一区二区|亚洲中文天堂综合|日韩欧美自拍一区|男女精品天堂一区|欧美自拍第6页亚洲成人精品一区|亚洲黄色天堂一区二区成人|超碰91偷拍第一页|日韩av夜夜嗨中文字幕|久久蜜综合视频官网|精美人妻一区二区三区

RELATEED CONSULTING
相關(guān)咨詢(xún)
選擇下列產(chǎn)品馬上在線(xiàn)溝通
服務(wù)時(shí)間：8:30-17:00
你可能遇到了下面的問(wèn)題
關(guān)閉右側(cè)工具欄

新聞中心

這里有您想知道的互聯(lián)網(wǎng)營(yíng)銷(xiāo)解決方案
MySQL安裝方式-創(chuàng)新互聯(lián)

一、單實(shí)例_rpm
1、上傳安裝包
tar -xf mysql-5.7.24-1.el6.x86_64.rpm-bundle.tar
2、檢查是否安裝

創(chuàng)新互聯(lián)公司主要從事做網(wǎng)站、成都網(wǎng)站制作、網(wǎng)頁(yè)設(shè)計(jì)、企業(yè)做網(wǎng)站、公司建網(wǎng)站等業(yè)務(wù)。立足成都服務(wù)磐石,十載網(wǎng)站建設(shè)經(jīng)驗(yàn),價(jià)格優(yōu)惠、服務(wù)專(zhuān)業(yè),歡迎來(lái)電咨詢(xún)建站服務(wù):028-86922220
rpm -qa | grep -i mysql
rpm -qa | grep -i maria
若有安裝 yum remove -y  包名
rm -fr /usr/lib/mysql
rm -fr /usr/include/mysql
rm -fr /etc/my.cnf
rm -fr /var/lib/mysql
rm -fr /usr/share/mysql
rm -fr /usr/local/mysql
find / -name mysql

3、安裝MySQL

mkdir -p /home/mysql/{3306,3307}/{data,log}
chown -R mysql:mysql /home
chmod -R 755 /home
cd /home/mysql/
rpm -ivh mysql-community-common-5.7.24-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.24-1.el6.x86_64.rpm
rpm -ivh mysql-community-client-5.7.24-1.el6.x86_64.rpm
rpm -ivh mysql-community-server-5.7.24-1.el6.x86_64.rpm

4、my.cnf

vi /etc/my.cnf
修改目錄

5、初始化數(shù)據(jù)庫(kù)

/usr/bin/mysql_install_db --user=mysql  --datadir=/home/mysql/3306/data 
cat /root/.mysql_secret

6、啟動(dòng)MySQL

cd /usr/bin/
/usr/bin/mysqld_safe  --defaults-file=/etc/my.cnf  --user=mysql  &

7、登錄MySQL

mysql -uroot -p -S /home/mysql/3306/mysql.sock
SET PASSWORD=PASSWORD('root');
flush privileges;

8、關(guān)閉MySQL
/usr/bin/mysqladmin -uroot -proot -S /home/mysql/3306/mysql.sock shutdown
二、單實(shí)例_glibc
1、上傳安裝包

tar -xvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.24-linux-glibc2.12-x86_64  /usr/local/mysql
echo 'export PATH=$PATH:/usr/local/mysql/bin' >>  /etc/profile
source /etc/profile

2、創(chuàng)建用戶(hù)/目錄

groupadd mysql
useradd -g mysql mysql
passwd mysql
mkdir -p /home/mysql/{3306,3307}/{data,log}
chown -R mysql:mysql /home
chmod -R 755 /home

3、my.cnf

vi /etc/my.cnf
[mysql]
socket=/home/mysql/3306/data/mysql.sock
port = 3306
[mysqld]
port = 3306
#skip-grant-tables
basedir=/usr/local/mysql 
datadir=/home/mysql/3306/data/
user=mysql 
log-error=/home/mysql/3306/log/resourcepool-0559.err 
pid-file=/home/mysql/3306/data/resourcepool-0559.pid
socket=/home/mysql/3306/data/mysql.sock
symbolic-links=0
server-id=102
log-bin=mysql-bin
binlog-ignore-db = mysql,information_schema
auto-increment-offset = 1
slave-skip-errors = all
#auto-increment-increment = 2
#default-storage-engine=MyISAM
binlog_format="MIXED"
log_bin_trust_function_creators=1
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
expire_logs_days = 7
event_scheduler=1
relay-log=relay-log

4、初始化數(shù)據(jù)庫(kù)
/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/home/mysql/3306/data
5、啟動(dòng)/關(guān)閉數(shù)據(jù)庫(kù)

/usr/local/mysql/bin/mysqld_safe  --defaults-file=/etc/my.cnf  --user=mysql  &
/usr/local/mysql/bin/mysqladmin -uroot -p -P3306 -S  /data/mysql/data/mysql.sock shutdown

三、多實(shí)例_glibc
1、安裝依賴(lài)

vi /etc/yum.repos.d/yum.repo
文件內(nèi)容改為如下：
[base]
name=Red Hat Enterprise Linux
baseurl=file:///media/Server  
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release
yum install ncurses-devel -y
yum install libail-devel -y
yum install -y gcc

2、創(chuàng)建用戶(hù)/目錄

groupadd mysql
useradd -g mysql mysql
passwd mysql
mkdir -p /home/mysql/{3306,3307}/{data,log}
chown -R mysql:mysql /home
chmod -R 755 /home

3、解壓安裝

tar -xvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.24-linux-glibc2.12-x86_64  /usr/local/mysql
echo 'export PATH=$PATH:/usr/local/mysql/bin' >>  /etc/profile
source /etc/profile
vi /etc/my.cnf
[client]  
port=3306  
socket=/tmp/mysql.sock  

[mysqld_multi]  
mysqld = /usr/local/mysql/bin/mysqld_safe  
mysqladmin = /usr/local/mysql/bin/mysqladmin  
log = /home/mysql/mysqld_multi.log  

[mysqld]  
user=mysql  
basedir = /usr/local/mysql  
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES  

[mysqld3306]  
mysqld=mysqld  
mysqladmin=mysqladmin  
datadir=/home/mysql/3306/data  
port=3306  
server_id=3306  
socket=/tmp/mysql_3306.sock  
log-output=file  
slow_query_log = 1  
long_query_time = 1  
slow_query_log_file = /home/mysql/3306/log/slow.log  
log-error = /home/mysql/3306/log/error_3306.log  
binlog_format = mixed  
log-bin = /home/mysql/3306/data/mysql3306_bin  

[mysqld3307]  
mysqld=mysqld  
mysqladmin=mysqladmin  
datadir=/home/mysql/3307/data  
port=3307  
server_id=3307  
socket=/tmp/mysql_3307.sock  
log-output=file  
slow_query_log = 1  
long_query_time = 1  
slow_query_log_file = /home/mysql/3307/log/slow.log  
log-error = /home/mysql/3307/log/error_3307.log  
binlog_format = mixed  
log-bin = /home/mysql/3306/data/mysql3307_bin

4、初始化數(shù)據(jù)庫(kù)
/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize-insecure --user=mysql
5、啟動(dòng)數(shù)據(jù)庫(kù)
設(shè)置啟動(dòng)文件
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
6、mysqld_multi進(jìn)行多實(shí)例管理

啟動(dòng)全部實(shí)例：/usr/local/mysql/bin/mysqld_multi start
查看全部實(shí)例狀態(tài)：/usr/local/mysql/bin/mysqld_multi report 
啟動(dòng)單個(gè)實(shí)例：/usr/local/mysql/bin/mysqld_multi start 3306 
停止單個(gè)實(shí)例：/usr/local/mysql/bin/mysqladmin -u root -p -S /tmp/mysql_3306.sock shutdown
查看單個(gè)實(shí)例狀態(tài)：/usr/local/mysql/bin/mysqld_multi report 3306
mysql -S /tmp/mysql_3306.sock -p
SET PASSWORD=PASSWORD('root');
flush privileges;

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無(wú)理由+7*72小時(shí)售后在線(xiàn)，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國(guó)服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡(jiǎn)單易用、服務(wù)可用性高、性?xún)r(jià)比高”等特點(diǎn)與優(yōu)勢(shì)，專(zhuān)為企業(yè)上云打造定制，能夠滿(mǎn)足用戶(hù)豐富、多元化的應(yīng)用場(chǎng)景需求。


分享題目：MySQL安裝方式-創(chuàng)新互聯(lián)
當(dāng)前URL：http://www.dlmjj.cn/article/pdssd.html