mysql多实例部署实例教程

2024-07-28 16:13:11

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/src/
[root@lnh 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 src]# ls
debug  kernels  mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz

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

[root@lnh src]# useradd -r -M -s /sbin/nologin mysql
[root@lnh src]# id mysql
uid=993(mysql) gid=990(mysql) groups=990(mysql)
[root@lnh src]# tar -xf mysql-5.7.38-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
[root@lnh 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 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 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 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  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/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多实例部署内容请搜索我们以前的文章或继续浏览下面的相关文章希望大家以后多多支持我们！

CentOS6.5 上部署 MySQL5.7.17 二进制安装以及多实例配置

1.建用户.下载.解压 groupadd mysql useradd -r -g mysql mysql wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz tar xvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz -C /usr/local/ ln -sv /usr/local/mysql-5.7.17-linux-gli
MySQL8.0.20单机多实例部署步骤

目录 0.环境需要 1.安装步骤 1.下载解压安装的mysql安装包文件 2.上传解压缩(我这里的上传为:xhell,当然也可使用其他方式) 3.在mysql目录创建创建数据文件存放路径并赋权 4.配置my.cnf文件 5.初始化各实例数据库 6.设置msyql环境变量 7.启动与查看 mysql 服务(需指定配置文件) 8.设置远程访问密码 9.防火墙开启访问端口(获取关闭防火墙) 0.环境需要 1.准备Linux环境(系统:CentOS7)2.准备MySQL安装包(版本:8.0.20)3.安
快速实现MySQL的部署以及一机多实例部署

MySQL有三个版本:二进制,源码包,RPM. 下面讲讲二进制包的安装过程下载地址:http://dev.mysql.com/downloads/mysql/ 选择Linux-Generic 我这里选择的是mysql-5.6.28-linux-glibc2.5-x86_64.tar.gz 解压后,里面有个文件INSTALL-BINARY,其实给出了二进制包的部署过程 shell> groupadd mysql shell> useradd -r -g mysql -s /bin/false
mysql使用mysqld_multi部署单机多实例的方法教程

前言大家应该都有所体会,随着硬件层面的发展,linux系统多核已经是普通趋势,而mysql是单进程多线程,所以先天上对多进程的利用不是很高,虽然5.6版本已经在这方面改进很多,但是也没有达到100%,所以为了充分的利用系统资源,mysql有自己的补充,那就是可以部署多实例,一个实例一个端口. mysqld_multi设计用于管理在同一台机器上运行的多个mysqld进程,这些进程使用不同的socket文件并监听在不同的端口上.mysqld_multi可以批量启动.关闭.或者报告这些mysqld进
Linux下MySQL多实例部署及安装指南

什么是MySQL多实例简单地说,Mysql多实例就是在一台服务器上同时开启多个不同的服务端口(3306.3307),同时运行多个Mysql服务进程,这些服务进程通过不同的socket监听不同的服务端口来提供服务. 这些Mysql多实例公用一套Mysql安装程序,使用不同的my.cnf(也可以相同)配置文件,启动程序(也可以相同)和数据文件.在提供服务时,多实例 Mysql在逻辑上看来是各自独立的,它们根据配置文件的对应设定值,获得服务器相应数量的硬件资源. 打个比方,Mysql多实例就相当于房
mysql多实例部署实例教程

目录 mysql多实例部署软件下载配置用户并解压二进制程序至/usr/local下创建各实例数据存放的目录初始化各实例安装perl 配置配置文件/etc/my.cnf 启动各实例加入system服务里面初始化密码报错解决 mysql多实例部署软件下载 [root@lnh ~]# rpm -qa |grep mysql [root@lnh ~]# ss -antl State Recv-Q Send-Q Local Address:Port Peer Address:Port P
shell脚本多实例部署nginx的详细教程

1. 创建一个目录,用来存放脚本和安装包 [root@localhost nginx]# tree . ├── install.sh └── packages └── nginx-1.20.1.tar.gz 1 directory, 2 files [root@localhost nginx]# 2. 下载好对应的安装包 [root@localhost packages]# wget https://nginx.org/download/nginx-1.20.1.tar.gz [root@loc
windows下Mysql多实例部署的操作方法

当存在多个项目的时候,需要同时部署时,且只有一台服务器时,哪么就需要部署Mysql多个实例,原理很简单,多个mysql服务运行使用不同的配置及数据管理. 具体操作如下: 1.找到mysql.ini配置并复制为一个新的文件,如mysql_dev.ini 2.修改如下配置 [mysqld] port=3308 basedir=D:/phpstudy_pro/Extensions/MySQL5.7.26/ datadir=D:/phpstudy_pro/Extensions/MySQL5.7.26/d
MySQL事务与锁实例教程详解

目录 MySQL事务和锁事务事务的控制语句事务隔离级别设置脏读不可重复读幻读锁机制 InnoDB的行级锁锁实战死锁总结 MySQL事务和锁事务说到关系型的数据库的事务,相信大家对四大特性都不陌生,分别是原子性.一致性.隔离性.持久性,简称为ACID特性. MySQL中支持3种不同的存储引擎: MyISAM存储引擎.Memory存储引擎.和InnoDB存储引擎注:只有InnoDB才支持事务. 事务的控制语句控制语句作用 begin或者start transaction
centos7安装mysql并jdbc测试实例详解

centos7安装mysql并jdbc测试实例详解前言: 之前用rpm安装方式安装不成功,换成yum安装之后安装ok了,在网上搜索到很多的rmp安装和tar包安装的方式,但是是centos7.x与centos6.x做了很大的改变,可能别人的6.x不适合7.x的安装,尤其是对于像博主一样的新人来说,照搬教程可能导致安装不成功,如果你rmp安装失败,那么尝试跟着本教程来吧. 先卸载已经存在的MySQL. [root@shizongger bin]# rpm -qa|grep mysql [root
C#调用WebService实例与开发教程(推荐)

1.1.Web Service基本概念 Web Service也叫XML Web Service WebService是一种可以接收从Internet或者Intranet上的其它系统中传递过来的请求,轻量级的独立的通讯技术.是:通过SOAP在Web上提供的软件服务,使用WSDL文件进行说明,并通过UDDI进行注册. XML:(Extensible Markup Language)扩展型可标记语言.面向短期的临时数据处理.面向万维网络,是Soap的基础. Soap:(Simple Object A
docker在linux上的安装部署实例讲解

以下文章了解之后你可以在服务器上部署项目,本地不需要安装 tomcat,jdk,mysql等服务器,通过docker可以一键解决安装docker $ apt install docker.io -y 若找不到资源,需要更新资源库,命令为: $ sudo apt-get update && sudo apt-get upgrade 查看docker版本 $ docker -v 更多的docker相关知识请关注:https://www.docker.com/ docker安装mysql $