我的编程空间，编程开发者的网络收藏夹
学习永远不晚
位置：首页-资讯-数据库

mysql多实例部署实例教程

2022-11-13 13:57

短信预约 -IT技能 免费直播动态提醒
省份

北京

  • 北京
  • 上海
  • 天津
  • 重庆
  • 河北
  • 山东
  • 辽宁
  • 黑龙江
  • 吉林
  • 甘肃
  • 青海
  • 河南
  • 江苏
  • 湖北
  • 湖南
  • 江西
  • 浙江
  • 广东
  • 云南
  • 福建
  • 海南
  • 山西
  • 四川
  • 陕西
  • 贵州
  • 安徽
  • 广西
  • 内蒙
  • 西藏
  • 新疆
  • 宁夏
  • 兵团
手机号
获取短信验证
立即预约

请填写图片验证码后获取短信验证码

看不清楚，换张图片

免费获取短信验证码

mysql多实例部署实例教程

mysql多实例部署

软件下载

[root@lnh ~]# rpm -qa |grep mysql
[root@lnh ~]# ss -antl
State    Recv-Q   Send-Q     Local Address:Port      Peer Address:Port   Process   
LISTEN   0        128              0.0.0.0:22             0.0.0.0:*                
LISTEN   0        128                 [::]:22                [::]:*                
//验证一下是否有mysql
[root@lnh ~]# cd /usr/class="lazy" data-src/
[root@lnh class="lazy" data-src]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz
--2022-07-31 14:25:22--  https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz
Resolving downloads.mysql.com (downloads.mysql.com)... 23.10.6.175, 2600:1405:1800:19c::2e31, 2600:1405:1800:184::2e31
Connecting to downloads.mysql.com (downloads.mysql.com)|23.10.6.175|:443... connected.
HTTP request sent, awaiting response... 302 Moved Temporarily
Location: https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz [following]
--2022-07-31 14:25:23--  https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz
Resolving cdn.mysql.com (cdn.mysql.com)... 23.212.157.5
Connecting to cdn.mysql.com (cdn.mysql.com)|23.212.157.5|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 674830866 (644M) [application/x-tar-gz]
Saving to: ‘mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz'

mysql-5.7.38-linux-g 100%[=====================>] 643.57M  1.88MB/s    in 8m 54s  

2022-07-31 14:34:17 (1.21 MB/s) - ‘mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz' saved [674830866/674830866]
//在www.mysql.com里面进行复制下载地址
[root@lnh class="lazy" data-src]# ls
debug  kernels  mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz

配置用户并解压二进制程序至/usr/local下

[root@lnh class="lazy" data-src]# useradd -r -M -s /sbin/nologin mysql
[root@lnh class="lazy" data-src]# id mysql
uid=993(mysql) gid=990(mysql) groups=990(mysql)
[root@lnh class="lazy" data-src]# tar -xf mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
[root@lnh class="lazy" data-src]# cd /usr/local/
[root@lnh local]# ll    //查看解压的东西
total 0
drwxr-xr-x. 14 root root 164 Jul 21 21:32 apache
drwxr-xr-x.  6 root root  58 Jul 21 21:12 apr
drwxr-xr-x.  5 root root  43 Jul 21 21:17 apr-util
drwxr-xr-x.  2 root root   6 May 19  2020 bin
drwxr-xr-x.  2 root root   6 May 19  2020 etc
drwxr-xr-x.  2 root root   6 May 19  2020 games
drwxr-xr-x.  2 root root   6 May 19  2020 include
drwxr-xr-x.  2 root root   6 May 19  2020 lib
drwxr-xr-x.  3 root root  17 Jul 19 16:13 lib64
drwxr-xr-x.  2 root root   6 May 19  2020 libexec
drwxr-xr-x.  9 root root 129 Jul 31 14:56 mysql-5.7.38-linux-glibc2.12-x86_64
drwxr-xr-x.  2 root root   6 May 19  2020 sbin
drwxr-xr-x.  5 root root  49 Jul 19 16:13 share
drwxr-xr-x.  5 root root 145 Jul 21 21:19 class="lazy" data-src
[root@lnh local]# ln -sv mysql-5.7.38-linux-glibc2.12-x86_64 mysql     //做一个软链接              //-v是将结果打印出来   
'mysql' -> 'mysql-5.7.38-linux-glibc2.12-x86_64'
[root@lnh local]# ll   //查看
total 0
drwxr-xr-x. 14 root root 164 Jul 21 21:32 apache
drwxr-xr-x.  6 root root  58 Jul 21 21:12 apr
drwxr-xr-x.  5 root root  43 Jul 21 21:17 apr-util
drwxr-xr-x.  2 root root   6 May 19  2020 bin
drwxr-xr-x.  2 root root   6 May 19  2020 etc
drwxr-xr-x.  2 root root   6 May 19  2020 games
drwxr-xr-x.  2 root root   6 May 19  2020 include
drwxr-xr-x.  2 root root   6 May 19  2020 lib
drwxr-xr-x.  3 root root  17 Jul 19 16:13 lib64
drwxr-xr-x.  2 root root   6 May 19  2020 libexec
lrwxrwxrwx.  1 root root  35 Jul 31 14:58 mysql -> mysql-5.7.38-linux-glibc2.12-x86_64
drwxr-xr-x.  9 root root 129 Jul 31 14:56 mysql-5.7.38-linux-glibc2.12-x86_64
drwxr-xr-x.  2 root root   6 May 19  2020 sbin
drwxr-xr-x.  5 root root  49 Jul 19 16:13 share
drwxr-xr-x.  5 root root 145 Jul 21 21:19 class="lazy" data-src
[root@lnh local]# chown -R mysql.mysql mysql*  //将软链接的属主属组改成mysql的
[root@lnh local]# ll
total 0
drwxr-xr-x. 14 root  root  164 Jul 21 21:32 apache
drwxr-xr-x.  6 root  root   58 Jul 21 21:12 apr
drwxr-xr-x.  5 root  root   43 Jul 21 21:17 apr-util
drwxr-xr-x.  2 root  root    6 May 19  2020 bin
drwxr-xr-x.  2 root  root    6 May 19  2020 etc
drwxr-xr-x.  2 root  root    6 May 19  2020 games
drwxr-xr-x.  2 root  root    6 May 19  2020 include
drwxr-xr-x.  2 root  root    6 May 19  2020 lib
drwxr-xr-x.  3 root  root   17 Jul 19 16:13 lib64
drwxr-xr-x.  2 root  root    6 May 19  2020 libexec
lrwxrwxrwx.  1 mysql mysql  35 Jul 31 14:58 mysql -> mysql-5.7.38-linux-glibc2.12-x86_64
drwxr-xr-x.  9 mysql mysql 129 Jul 31 14:56 mysql-5.7.38-linux-glibc2.12-x86_64
drwxr-xr-x.  2 root  root    6 May 19  2020 sbin
drwxr-xr-x.  5 root  root   49 Jul 19 16:13 share
drwxr-xr-x.  5 root  root  145 Jul 21 21:19 class="lazy" data-src
[root@lnh local]# ls  //编译三部曲已经完成
apache    bin    include  libexec                              sbin
apr       etc    lib      mysql                                share
apr-util  games  lib64    mysql-5.7.38-linux-glibc2.12-x86_64  class="lazy" data-src
[root@lnh local]# cd mysql
[root@lnh mysql]# ls
bin  docs  include  lib  LICENSE  man  README  share  support-files
[root@lnh mysql]# echo 'export PATH=$PATH:/usr/local/mysql/bin' > /etc/profile.d/mysql.sh   
//配置环境变量
[root@lnh mysql]# source /etc/profile.d/mysql.sh 
//使环境生效
[root@lnh mysql]# ln -sv /usr/local/mysql/include/ /usr/include/mysql
'/usr/include/mysql' -> '/usr/local/mysql/include/'
//做include的头文件让系统可以识别
[root@lnh mysql]# chown -R mysql.mysql /usr/include/mysql
//将软链接的属主属组改成mysql的
[root@lnh mysql]# ll -d /usr/include/mysql/
drwxr-xr-x. 3 mysql mysql 4096 Jul 31 14:56 /usr/include/mysql/
[root@lnh mysql]# vim /etc/ld.so.conf.d/mysql.conf
[root@lnh mysql]# cat /etc/ld.so.conf.d/mysql.conf
/usr/local/mysql/lib
//配置lib
[root@lnh mysql]# ldconfig 
//刷新配置
[root@lnh mysql]# vim /etc/man_db.conf 
#MANDATORY_MANPATH                      /usr/class="lazy" data-src/pvm3/man
#
MANDATORY_MANPATH                       /usr/man
MANDATORY_MANPATH                       /usr/share/man
MANDATORY_MANPATH                       /usr/local/share/man
MANDATORY_MANPATH                       /usr/local/mysql/man//添加这一行

创建各实例数据存放的目录

[root@lnh ~]# mkdir -p /opt/data/{3306,3307,3308}  //创建存放目录
[root@lnh ~]# chown -R mysql.mysql /opt/data/  
[root@lnh ~]# ll -d /opt/data/
drwxr-xr-x. 5 mysql mysql 42 Jul 31 15:24 /opt/data/
//修改其所属主所属组
[root@lnh ~]# tree /opt/data/
/opt/data/
├── 3306
├── 3307
└── 3308

3 directories, 0 files
//查看其结构

初始化各实例

[root@lnh ~]# mysqld --initialize --user mysql --datadir /opt/data/3306 //初始化实例   --user指定用户 --datadir指定数据目录
2022-07-31T07:29:37.154689Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-07-31T07:29:37.346729Z 0 [Warning] InnoDB: New log files created, LSN=45790
2022-07-31T07:29:37.389866Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2022-07-31T07:29:37.450981Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 88389665-10a2-11ed-9840-000c2905f428.
2022-07-31T07:29:37.452192Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-07-31T07:29:37.758320Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-07-31T07:29:37.758378Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-07-31T07:29:37.759177Z 0 [Warning] CA certificate ca.pem is self signed.
2022-07-31T07:29:37.780720Z 1 [Note] A temporary password is generated for root@localhost: AqldE*a:O8FR
[root@lnh ~]# echo 'AqldE*a:O8FR' > 3306
[root@lnh ~]# cat 3306 
AqldE*a:O8FR
//将这个格式化的随机密码生成到一个文件里面
[root@lnh ~]# mysqld --initialize --user mysql --datadir /opt/data/3307   //格式化3307
2022-07-31T07:33:29.214978Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-07-31T07:33:29.491805Z 0 [Warning] InnoDB: New log files created, LSN=45790
2022-07-31T07:33:29.524728Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2022-07-31T07:33:29.598226Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 12977170-10a3-11ed-9d3d-000c2905f428.
2022-07-31T07:33:29.599323Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-07-31T07:33:29.932320Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-07-31T07:33:29.932367Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-07-31T07:33:29.932766Z 0 [Warning] CA certificate ca.pem is self signed.
2022-07-31T07:33:30.095306Z 1 [Note] A temporary password is generated for root@localhost: PAJBo+Gxg19I
[root@lnh ~]# echo ' PAJBo+Gxg19I' > 3307
[root@lnh ~]# cat 3307 
 PAJBo+Gxg19I
[root@lnh ~]# mysqld --initialize --user mysql --datadir /opt/data/3308   //格式化3308
2022-07-31T07:34:23.861697Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-07-31T07:34:24.082852Z 0 [Warning] InnoDB: New log files created, LSN=45790
2022-07-31T07:34:24.112764Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2022-07-31T07:34:24.173299Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 331ef070-10a3-11ed-a122-000c2905f428.
2022-07-31T07:34:24.175009Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-07-31T07:34:24.374707Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-07-31T07:34:24.374737Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-07-31T07:34:24.375103Z 0 [Warning] CA certificate ca.pem is self signed.
2022-07-31T07:34:24.471521Z 1 [Note] A temporary password is generated for root@localhost: =w&lnU)d-7kK
[root@lnh ~]# echo ' =w&lnU)d-7kK' > 3308
[root@lnh ~]# cat 3308
 =w&lnU)d-7kK
[root@lnh ~]# ls
3306  3307  3308  anaconda-ks.cfg

安装perl

[root@lnh ~]# dnf -y install perl
Last metadata expiration check: 1:24:50 ago on Sun 31 Jul 2022 02:13:54 PM CST.
Dependencies resolved.
===================================================================================
 Package                      Arch   Version                       Repo       Size
===================================================================================
Installing:
 perl                         x86_64 4:5.26.3-420.el8              AppStream  73 k
Installing dependencies:
 perl-Algorithm-Diff          noarch 1.1903-9.el8                  base       52 k
 perl-Archive-Tar             noarch 2.30-1.el8                    base       79 k
 perl-Archive-Zip             noarch 1.60-3.el8                    AppStream 108 k
 perl-Attribute-Handlers      noarch 0.99-420.el8                  AppStream  89 k
 perl-B-Debug                 noarch 1.26-2.el8                    AppStream  26 k
 perl-CPAN                    noarch 2.18-397.el8                  AppStream 554 k
 perl-CPAN-Meta               noarch 2.150010-396.el8              AppStream 191 k
 perl-CPAN-Meta-Requirements  noarch 2.140-396.el8                 AppStream  37 k
 perl-CPAN-Meta-YAML          noarch 0.018-397.el8                 AppStream  34 k
 perl-Compress-Bzip2          x86_64 2.26-6.el8                    AppStream  72 k
 perl-Compress-Raw-Bzip2      x86_64 2.081-1.el8                   base       40 k
 perl-Compress-Raw-Zlib       x86_64 2.081-1.el8                   base       68 k
 perl-Config-Perl-V           noarch 0.30-1.el8                    AppStream  22 k
 perl-DB_File                 x86_64 1.842-1.el8                   AppStream  83 k
 perl-Data-OptList            noarch 0.110-6.el8                   AppStream  31 k
 perl-Data-Section            noarch 0.200007-3.el8                AppStream  30 k
 perl-Devel-PPPort            x86_64 3.36-5.el8                    AppStream 118 k
 perl-Devel-Peek              x86_64 1.26-420.el8                  AppStream  94 k
 perl-Devel-SelfStubber       noarch 1.06-420.el8                  AppStream  76 k
 perl-Devel-Size              x86_64 0.81-2.el8                    AppStream  34 k
 perl-Digest-SHA              x86_64 1:6.02-1.el8                  AppStream  66 k
 perl-Encode-devel            x86_64 4:2.97-3.el8                  AppStream  39 k
 perl-Env                     noarch 1.04-395.el8                  AppStream  21 k
 perl-ExtUtils-CBuilder       noarch 1:0.280230-2.el8              AppStream  48 k
 perl-ExtUtils-Command        noarch 1:7.34-1.el8                  AppStream  19 k
 perl-ExtUtils-Embed          noarch 1.34-420.el8                  AppStream  79 k
....

配置配置文件/etc/my.cnf

[root@lnh ~]# vim /etc/my.cnf
[root@lnh ~]# cat /etc/my.cnf
[mysqld_multi]  //程序命令
mysqld = /usr/local/mysql/bin/mysqld_safe //命令执行的路径
mysqladmin = /usr/local/mysql/bin/mysqladmin //命令执行的路径

[mysqld3306]   
datadir = /opt/data/3306   //数据目录
port = 3306  //端口
socket = /tmp/mysql3306.sock  //套接字
pid-file = /opt/data/3306/mysql_3306.pid   //pid进程文件
log-error=/var/log/3306.log   //错误日志

[mysqld3307]
datadir = /opt/data/3307
port = 3307
socket = /tmp/mysql3307.sock
pid-file = /opt/data/3307/mysql_3307.pid
log-error=/var/log/3307.log

[mysqld3308]
datadir = /opt/data/3308
port = 3308
socket = /tmp/mysql3308.sock
pid-file = /opt/data/3308/mysql_3308.pid
log-error=/var/log/3308.log

启动各实例

[root@lnh ~]# mysqld_multi start 3306
[root@lnh ~]# mysqld_multi start 3307
[root@lnh ~]# mysqld_multi start 3308
[root@lnh ~]# ss -antl 
State    Recv-Q   Send-Q     Local Address:Port      Peer Address:Port   Process   
LISTEN   0        128              0.0.0.0:22             0.0.0.0:*                
LISTEN   0        128                 [::]:22                [::]:*                
LISTEN   0        80                     *:3306                 *:*                
LISTEN   0        80                     *:3307                 *:*                
LISTEN   0        80                     *:3308                 *:*            
//这种方式启动不建议
[root@lnh ~]# mysqld_multi stop 3308
[root@lnh ~]# ss -antl 
State    Recv-Q   Send-Q     Local Address:Port      Peer Address:Port   Process   
LISTEN   0        128              0.0.0.0:22             0.0.0.0:*                
LISTEN   0        128                 [::]:22                [::]:*                
LISTEN   0        80                     *:3306                 *:*                
LISTEN   0        80                     *:3307                 *:*                
LISTEN   0        80                     *:3308                 *:*               
//可以发现这种方式启动程序后关闭不了
[root@lnh ~]# ps -ef |grep 3306
root       71742       1  0 15:49 pts/1    00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/opt/data/3306 --port=3306 --socket=/tmp/mysql3306.sock --pid-file=/opt/data/3306/mysql_3306.pid --log-error=/var/log/3306.log
mysql      71878   71742  0 15:49 pts/1    00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/opt/data/3306 --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/var/log/3306.log --pid-file=/opt/data/3306/mysql_3306.pid --socket=/tmp/mysql3306.sock --port=3306
root       72257   66880  0 15:53 pts/1    00:00:00 grep --color=auto 3306
//查看3306进程
[root@lnh ~]# ps -ef |grep 3306 |grep -v grep
root       71742       1  0 15:49 pts/1    00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/opt/data/3306 --port=3306 --socket=/tmp/mysql3306.sock --pid-file=/opt/data/3306/mysql_3306.pid --log-error=/var/log/3306.log
mysql      71878   71742  0 15:49 pts/1    00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/opt/data/3306 --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/var/log/3306.log --pid-file=/opt/data/3306/mysql_3306.pid --socket=/tmp/mysql3306.sock --port=3306
//取反
[root@lnh ~]# ps -ef |grep 3306 |grep -v grep |awk '{print$2}'
71742
71878
//取出端口号
[root@lnh ~]# ps -ef |grep 3306 |grep -v grep |awk '{print$2}'|xargs kill -9   
//xargs将前面的结果交给后面的来处理
//杀死了端口号,相当于这个命令可以控制服务停止
[root@lnh ~]# ps -ef |grep 3307 |grep -v grep |awk '{print$2}'|xargs kill -9
[root@lnh ~]# ps -ef |grep 3308 |grep -v grep |awk '{print$2}'|xargs kill -9
[root@lnh ~]# ss -antl
State    Recv-Q   Send-Q     Local Address:Port      Peer Address:Port   Process   
LISTEN   0        128              0.0.0.0:22             0.0.0.0:*                
LISTEN   0        128                 [::]:22                [::]:*                
//端口号都被杀死

加入system服务里面

[root@lnh system]# cd
[root@lnh ~]# cd /usr/lib/systemd/system
[root@lnh system]# cp sshd.service 3306.service
[root@lnh system]# cp sshd.service 3307.service
[root@lnh system]# cp sshd.service 3308.service
[root@lnh system]# vim 3306.service 
[Unit]
Description=3306 server daemon
After=network.target sshd-keygen.target

[Service]
Type=forking
ExecStart=/usr/local/mysql/bin/mysqld_multi start 3306 //开启的位置
ExecStop=ps -ef |grep 3306 |grep -v grep |awk '{print$2}'|xargs kill -9   //关闭的命令
ExecReload=/bin/kill -HUP $MAINPID

[Install]
WantedBy=multi-user.target
[root@lnh system]# cp 3306.service 3307.service 
cp: overwrite '3307.service'? y
[root@lnh system]# vim 3307.service 
[Unit]
Description=3307 server daemon
After=network.target sshd-keygen.target

[Service]
Type=forking
ExecStart=/usr/local/mysql/bin/mysqld_multi start 3307
ExecStop=ps -ef |grep 3307 |grep -v grep |awk '{print$2}'|xargs kill -9
ExecReload=/bin/kill -HUP $MAINPID

[Install]
WantedBy=multi-user.target
//快捷键 :% s/6/7/g 直接将6变成7
[root@lnh system]# cp 3306.service 3308.service 
cp: overwrite '3308.service'? y
[root@lnh system]# vim 3308.service 
[Unit]
Description=3308 server daemon
After=network.target sshd-keygen.target

[Service]
Type=forking
ExecStart=/usr/local/mysql/bin/mysqld_multi start 3308
ExecStop=ps -ef |grep 3308 |grep -v grep |awk '{print$2}'|xargs kill -9
ExecReload=/bin/kill -HUP $MAINPID

[Install]
WantedBy=multi-user.target
//快捷键 :% s/6/8/g 直接将6变成8
[root@lnh system]# systemctl daemon-reload 
//加载一下
[root@lnh system]# systemctl stop firewalld
[root@lnh system]# systemctl disable firewalld.service 
Removed /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
[root@lnh system]# vim /etc/selinux/config 
SELINUX=disabled   //修改
[root@lnh system]# setenforce 0
//关闭防火墙
[root@lnh system]# systemctl start 3306
[root@lnh system]# systemctl start 3307
[root@lnh system]# systemctl start 3308
[root@lnh system]# ss -antl
State    Recv-Q   Send-Q     Local Address:Port      Peer Address:Port   Process   
LISTEN   0        128              0.0.0.0:22             0.0.0.0:*                
LISTEN   0        128                 [::]:22                [::]:*                
LISTEN   0        80                     *:3306                 *:*                
LISTEN   0        80                     *:3307                 *:*                
LISTEN   0        80                     *:3308                 *:*                
//可以发现全部启动成功
//如果启动失败就在这个里面journalctl -xe找出错误点

初始化密码

[root@lnh ~]# cat 3306
AqldE*a:O8FR   //查看之前放置的密码
[root@lnh ~]# mysql -uroot -p'AqldE*a:O8FR' -S  /tmp/mysql3306.sock 
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.38

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set password=password('3306');   //修改密码
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> quit
Bye
[root@lnh ~]# mysql -uroot -p'3306' -S  /tmp/mysql3306.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.38 MySQL Community Server (GPL)

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 
//登录成功
[root@lnh ~]# cat 3307
 PAJBo+Gxg19I
[root@lnh ~]# mysql -uroot -p'PAJBo+Gxg19I' -S  /tmp/mysql3307.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.38

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set password=password('3307');   //修改密码
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> quit
Bye
[root@lnh ~]# mysql -uroot -p'3307' -S  /tmp/mysql3307.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.38 MySQL Community Server (GPL)

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 
//登录成功
[root@lnh ~]# cat 3308
 =w&lnU)d-7kK
[root@lnh ~]# mysql -uroot -p'=w&lnU)d-7kK' -S  /tmp/mysql3308.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.38

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set password=password('3308');   //修改密码
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> quit
Bye
[root@lnh ~]# mysql -uroot -p'3308' -S  /tmp/mysql3308.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.38 MySQL Community Server (GPL)

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 
//登录成功

报错解决

报错1：
[root@lnh ~]# mysql -uroot -p'AqldE*a:O8FR'
mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory
//没有这个包
解决：
[root@lnh ~]# dnf provides libncurses.so.5
Last metadata expiration check: 2:39:05 ago on Sun 31 Jul 2022 02:13:54 PM CST.
ncurses-compat-libs-6.1-9.20180224.el8.i686 : Ncurses compatibility libraries
Repo        : base
Matched from:
Provide    : libncurses.so.5

[root@lnh ~]# dnf -y install ncurses-compat-libs-6.1-9.20180224.el8.
报错2：
[root@lnh ~]# mysql -uroot -p'AqldE*a:O8FR'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)   //没有访问到套接字
解决：[root@lnh ~]# mysql -uroot -p'AqldE*a:O8FR' -S  /tmp/mysql3306.sock 

到此这篇关于mysql多实例部署的文章就介绍到这了,更多相关mysql多实例部署内容请搜索编程网以前的文章或继续浏览下面的相关文章希望大家以后多多支持编程网！

免责声明：

① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的，并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据，供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。

② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

mysql多实例部署mysql多实例
阅读原文内容投诉

mysql多实例部署实例教程

下载Word文档到电脑，方便收藏和打印～

下载Word文档

相关文章

猜你喜欢

mysql多实例部署实例教程

这篇文章主要介绍了mysql多实例部署,主要包括软件下载、配置用户并解压二进制程序至/usr/local下及创建各实例数据存放的目录，本文给大家介绍的非常详细，需要的朋友可以参考下
2022-11-13

mysql多实例部署

2024-04-02

MySQL单机多实例部署

2024-04-02

MYSQL的单机多实例部署

2024-04-02

MySQL5.6多实例部署

2024-04-02

springboot + devtools（热部署）实例教程

技术介绍devtools：是boot的一个热部署工具，当我们修改了classpath下的文件（包括类文件、属性文件、页面等）时，会重新启动应用（由于其采用的双类加载器机制，这个启动会非常快，如果发现这个启动比较慢，可以选择使用jrebel）
2023-05-31

MySQL--------多版本多实例混合部署

2024-04-02

shell脚本多实例部署nginx的详细教程

1. 创建一个目录，用来存放脚本和安装包[root@localhost nginx]# tree . ├── install.sh └── packages└── nginx-1.20.1.tar.gz1 directory, 2 file
2022-06-04

mysql5.5中怎么实现多实例部署

2024-04-02

Linux下MySQL多实例部署及安装指南

什么是MySQL多实例简单地说，Mysql多实例就是在一台服务器上同时开启多个不同的服务端口（3306、3307），同时运行多个Mysql服务进程，这些服务进程通过不同的socket监听不同的服务端口来提供服务。这些Mysql多实例公用一套
2022-06-03

windows下Mysql多实例部署的操作方法

2024-04-02

MySQL8.0.20单机多实例部署步骤

2024-04-02

mysql 5.5 .17 配置多实例教程

2024-04-02

Tomcat多实例部署及配置原理

2024-04-02

通过 MySQL 8.0 二进制安装包部署多实例

2024-04-02

node.js实例部署分析

这篇文章主要介绍了node.js实例部署分析的相关知识，内容详细易懂，操作简单快捷，具有一定借鉴价值，相信大家阅读完这篇node.js实例部署分析文章都会有所收获，下面我们一起来看看吧。服务器服务器选择了：9.92一个月，适合用来个人开发测
2023-06-17

mysql多实例

2024-04-02

Python+Pika+RabbitMQ环境部署及实现工作队列的实例教程

rabbitmq中文翻译的话，主要还是mq字母上：Message Queue，即消息队列的意思。前面还有个rabbit单词，就是兔子的意思，和python语言叫python一样，老外还是蛮幽默的。rabbitmq服务类似于mysql、apa
2022-06-04

Dockerrocketmq部署的实现示例

2024-04-02

原有MySQL数据库 ，安装多实例教程

2024-04-02

热门标签

Linux(148)PHP(127)Java(102)正则表达式(101)JavaScript(69)最佳实践(67)jQuery(44)MySQL(39)Docker(37)C语言(36)性能优化(34)Python(34)XML(28)string(27)第三方库(23)回调函数(23)ZIP(22)数组(22)可扩展性(22)字符串比较(21)find(20)RPM(20)Go(20)grep(19)ASP.NETCore(19)XML解析器(19)事件(19)事件处理程序(19)StringBuilder(18)Nginx(18)

编程热搜

查看更多

编程资源站

  • 资料下载
  • 历年试题
2021年下半年软考高级信息系统项目管理师高频考点精选资料
2021下半年软考高级信息系统技术知识点记忆口诀精选资料
2021下半年软考《信息系统项目管理师》考试真题及答案精选资料
2021下半年软考高级考试备考攻略精选资料
2021年软考高级《信息系统项目管理师》巩固练习题汇总精选资料
2021下半年软考高级信息系统项目管理师30个易考知识点汇总精选资料
2021下半年软考高级知识点这样记，还担心记不住吗精选资料
2021年下半年软考高级考试重点汇总精选资料
2021下半年软考高级信息系统项目管理师计算公式汇总精选资料
2021年下半年软考高级《信息系统项目管理师》模拟试题精选资料
查看更多
信息系统项目管理师选择题每日一练（2024）历年试题
2023年下半年信息系统项目管理师综合知识真题演练历年试题
查看更多

目录

本网页已闲置超过3分钟，按键盘任意键或点击空白处，即可回到网页
最新资讯更多
    友情链接编程网

    反馈

    我要
    反馈