5.6.44 二進(jìn)制包安裝部署

解壓到以下目錄

[root@oldboy~]# ll /usr/local/mysql56/drwxr-xr-x.2root root4096Jun311:20bin-rw-r--r--.171613141517987Mar1515:38COPYINGdrwxr-xr-x.3root root18Jun311:19datadrwxr-xr-x.2root root55Jun311:19docsdrwxr-xr-x.3root root4096Jun311:19includedrwxr-xr-x.3root root4096Jun311:19libdrwxr-xr-x.4root root30Jun311:19mandrwxr-xr-x.10root root4096Jun311:19mysql-test-rw-r--r--.17161314152496Mar1515:38READMEdrwxr-xr-x.2root root30Jun311:19scriptsdrwxr-xr-x.28root root4096Jun311:20sharedrwxr-xr-x.4root root4096Jun311:19sql-benchdrwxr-xr-x.2root root136Jun311:19support-files[root@oldboy~]#

修改配置文件

[root@oldboy~]# cat>/data/mysql56/my.cnf<<EOF[mysqld]basedir=/usr/local/mysql56datadir=/data/mysql56/datasocket=/tmp/mysql56.sockuser=mysqllog_error=/tmp/mysql56.logskip_name_resolvelog_bin=/data/mysql56/mysql-binport=5606server_id=5606EOF

準(zhǔn)備啟動(dòng)腳本

cat>/etc/systemd/system/mysqld56.service<<EOF[Unit]Description=MySQLServerDocumentation=man:mysqld(8)Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.htmlAfter=network.targetAfter=syslog.target[Install]WantedBy=multi-user.target[Service]User=mysqlGroup=mysqlExecStart=/usr/local/mysql56/bin/mysqld--defaults-file=/data/mysql56/my.cnfLimitNOFILE=5000EOF

初始化數(shù)據(jù)

[root@oldboy~]# mv/etc/my.cnf/etc/my.cnf.aa[root@oldboy~]#/usr/local/mysql56/scripts/mysql_install_db--user=mysql--datadir=/data/mysql56/data--basedir=/usr/local/mysql56

啟動(dòng)數(shù)據(jù)庫

chown-Rmysql.mysql/data[root@oldboy tmp]# systemctl start mysqld56[root@oldboy tmp]#/usr/local/mysql56/bin/mysql-S/tmp/mysql56.sockWelcometo theMySQLmonitor.Commandsend with;or \g.YourMySQLconnection idis1Serverversion:5.6.44-logMySQLCommunityServer(GPL)

5.7.26 二進(jìn)制包安裝部署

解壓到以下目錄

[root@oldboy~]# ll /usr/local/mysql57/total36drwxr-xr-x.2root root4096Jun311:22bin-rw-r--r--.171613141517987Apr1321:32COPYINGdrwxr-xr-x.2root root55Jun311:22docsdrwxr-xr-x.3root root4096Jun311:21includedrwxr-xr-x.5root root230Jun311:22libdrwxr-xr-x.4root root30Jun311:22man-rw-r--r--.17161314152478Apr1321:32READMEdrwxr-xr-x.28root root4096Jun311:22sharedrwxr-xr-x.2root root90Jun311:22support-files

修改配置文件

[root@oldboy~]# cat>/data/mysql57/my.cnf<<EOF[mysqld]basedir=/usr/local/mysql57datadir=/data/mysql57/datasocket=/tmp/mysql57.sockuser=mysqllog_error=/tmp/mysql57.logskip_name_resolvelog_bin=/data/mysql57/mysql-binport=5706server_id=5706EOF

準(zhǔn)備啟動(dòng)腳本

cat>/etc/systemd/system/mysqld57.service<<EOF[Unit]Description=MySQLServerDocumentation=man:mysqld(8)Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.htmlAfter=network.targetAfter=syslog.target[Install]WantedBy=multi-user.target[Service]User=mysqlGroup=mysqlExecStart=/usr/local/mysql57/bin/mysqld--defaults-file=/data/mysql57/my.cnfLimitNOFILE=5000EOF

初始化數(shù)據(jù)

[root@oldboy ~]#/usr/local/mysql57/bin/mysqld--initialize-insecure--user=mysql--basedir=/usr/local/mysql57/--datadir=/data/mysql57/data

啟動(dòng)數(shù)據(jù)庫

chown-Rmysql.mysql/data[root@oldboy tmp]# systemctl start mysqld57[root@oldboy tmp]#/usr/local/mysql57/bin/mysql-S/tmp/mysql57.sock

8.0.16 二進(jìn)制包安裝部署

解壓到以下目錄

[root@oldboy~]# ll/usr/local/mysql80/drwxr-xr-x.27161314154096Apr1407:06bindrwxr-xr-x.271613141586Apr1407:06docsdrwxr-xr-x.3716131415261Apr1407:06includedrwxr-xr-x.67161314154096Apr1407:06lib-rw-r--r--.1716131415335809Apr1319:46LICENSE-rw-r--r--.1716131415101807Apr1319:46LICENSE.routerdrwxr-xr-x.471613141530Apr1407:06man-rw-r--r--.1716131415687Apr1319:46README-rw-r--r--.1716131415700Apr1319:46README.routerdrwxrwxr-x.27161314156Apr1407:06rundrwxr-xr-x.287161314154096Apr1407:06sharedrwxr-xr-x.271613141577Apr1407:06support-filesdrwxr-xr-x.371613141517Apr1407:06var[root@oldboy~]#

修改配置文件

[root@oldboy~]# cat>/data/mysql80/my.cnf<<EOF[mysqld]basedir=/usr/local/mysql80datadir=/data/mysql80/datasocket=/tmp/mysql80.sockuser=mysqllog_error=/tmp/mysql80.logskip_name_resolvelog_bin=/data/mysql80/mysql-binport=8006server_id=8006EOF

準(zhǔn)備啟動(dòng)腳本

cat>/etc/systemd/system/mysqld80.service<<EOF[Unit]Description=MySQLServerDocumentation=man:mysqld(8)Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.htmlAfter=network.targetAfter=syslog.target[Install]WantedBy=multi-user.target[Service]User=mysqlGroup=mysqlExecStart=/usr/local/mysql80/bin/mysqld--defaults-file=/data/mysql80/my.cnfLimitNOFILE=5000EOF

初始化數(shù)據(jù)

[root@oldboy ~]#/usr/local/mysql80/bin/mysqld--initialize-insecure--user=mysql--basedir=/usr/local/mysql80--datadir=/data/mysql80/data

啟動(dòng)數(shù)據(jù)庫

chown-Rmysql.mysql/data[root@oldboy tmp]# systemctl start mysqld80[root@oldboy tmp]#/usr/local/mysql80/bin/mysql-S/tmp/mysql80.sock

作者：MySQL_oldguo

鏈接：http://www.itdecent.cn/p/6f2cb7874abd

來源：簡(jiǎn)書

著作權(quán)歸作者所有。商業(yè)轉(zhuǎn)載請(qǐng)聯(lián)系作者獲得授權(quán)，非商業(yè)轉(zhuǎn)載請(qǐng)注明出處。