2022
我们一起努力

怎么使用OEL7.2系统system管理源码安装的mysql5.7 - MySQL数据库

这篇文章主要讲解了“怎么使用OEL7.2系统system管理源码安装的mysql5.7”,文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习“怎么使用OEL7.2系统system管理源码安装的mysql5.7”吧!

1描述
使用OEL7.2系统 system 管理源码安装的mysql5.7多实例.
2操作环境
2.1OS info
OEL7.2 x64
3过程设计
编辑/etc/my.cnf ,本文创建mysqld@3307.service与mysqld@3308.service两个实例,分别对应3307与3308端口。创建相应实例目录。
复制systemd 服务文件,复制mysql base目录下/usr/local/mysql/usr/lib/systemd/system/的mysqld@.service文件到系统/usr/lib/systemd/system目录下,并重命名成与多实例名一致的文件。
systemctl daemon-reload
systemctl start mysqld@3307.service
systemctl start mysqld@.service3308
4详细步骤操作
[root@localhost ~]# vi /etc/my.cnf
[root@localhost ~]# cat !$
cat /etc/my.cnf
[mysqld@3307]
datadir=/usr/local/mysql/data/3307
socket=/usr/local/mysql/data/3307/mysql.sock
port=3307
log-error=/var/log/mysqld-service3307.log
[mysqld@3308]
datadir=/usr/local/mysql/data/3308
socket=/usr/local/mysql/data/3308/mysql.sock
port=3308
log-error=/var/log/mysqld-service3308.log
[root@localhost ~]# mkdir -p /usr/local/mysql/data/3307
[root@localhost ~]# mkdir -p /usr/local/mysql/data/3308
[root@localhost ~]# chown -R mysql.mysql /usr/local/mysql/data/
[root@localhost ~]# cd /usr/lib/systemd/system
[root@localhost system]# ls -l mysqld*
-rw-r–r–. 1 root root 1637 May  3 03:07 mysqld.service
-rw-r–r–. 1 root root 1668 May  3 03:07 mysqld@.service
[root@localhost system]# cp mysqld@.service mysqld@3307
[root@localhost system]# cp mysqld@.service mysqld@3308
[root@localhost system]# systemctl daemon-reload
[root@localhost system]# mkdir /var/run/mysqld/
[root@localhost system]# chown -R mysql.mysql /var/run/mysqld
[root@localhost system]# cd /var/log/
[root@localhost log]# ls -lrt|tail
-rw-r–r–. 1 root  root    8460 May  8 01:20 boot.log
-rw——-. 1 root  root    1739 May  8 01:20 cron
-rw-r–r–. 1 root  root     360 May  8 01:20 wpa_supplicant.log
-rw——-. 1 root  root     594 May  8 01:20 maillog
-rw-rw-r–. 1 root  utmp   22656 May  8 01:21 wtmp
-rw-r–r–. 1 root  root  291416 May  8 01:21 lastlog
-rw-r—–. 1 mysql mysql   4377 May  8 01:24 mysqld-service3307.log
-rw-r—–. 1 mysql mysql   4449 May  8 01:24 mysqld-service3308.log
-rw——-. 1 root  root  540273 May  8 01:24 messages
-rw——-. 1 root  root    7764 May  8 01:24 secure
[root@localhost log]# grep password mysqld-service3307.log
2018-05-07T17:24:01.123362Z 1 [Note] A temporary password is generated for root@localhost: x&aQ/IT&p5%u
[root@localhost log]# grep password mysqld-service3308.log
2018-05-07T17:24:17.635837Z 1 [Note] A temporary password is generated for root@localhost: xt2aq-KYGWnt
[root@localhost log]# /usr/local/mysql/bin/mysql -uroot -p'x&aQ/IT&p5%u' -S /usr/local/mysql/data/3307/mysql.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.22
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
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> exit
Bye
[root@localhost log]# /usr/local/mysql/bin/mysql -uroot -p'xt2aq-KYGWnt' -S /usr/local/mysql/data/3308/mysql.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.22
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
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> exit
Bye
[root@localhost log]#
[root@localhost log]# systemctl stop mysqld@330*
[root@localhost log]# ps -ef |grep mysql
root       3328   2861  0 01:32 pts/0    00:00:00 grep –color=auto mysql
[root@localhost log]# systemctl start mysqld@330*
[root@localhost log]# ps -ef |grep mysql
root       3335   2861  0 01:32 pts/0    00:00:00 grep –color=auto mysql
[root@localhost log]# systemctl start mysqld@330*
[root@localhost log]# systemctl start mysqld@3307
[root@localhost log]# systemctl start mysqld@3308
[root@localhost log]# ps -ef |grep mysql
mysql      3367      1  5 01:32 ?        00:00:00 /usr/local/mysql/bin/mysqld –defaults-group-suffix=@3307 –daemonize –pid-file=/var/run/mysqld/mysqld-3307.pid
mysql      3420      1 10 01:32 ?        00:00:00 /usr/local/mysql/bin/mysqld –defaults-group-suffix=@3308 –daemonize –pid-file=/var/run/mysqld/mysqld-3308.pid
root       3449   2861  0 01:32 pts/0    00:00:00 grep –color=auto mysql
[root@localhost log]# systemctl stop mysqld@330*
[root@localhost log]# ps -ef |grep mysql
root       3459   2861  0 01:32 pts/0    00:00:00 grep –color=auto mysql
[root@localhost log]# systemctl start mysqld@330*
[root@localhost log]# ps -ef |grep mysql
root       3466   2861  0 01:33 pts/0    00:00:00 grep –color=auto mysql
[root@localhost log]#

感谢各位的阅读,以上就是“怎么使用OEL7.2系统system管理源码安装的mysql5.7”的内容了,经过本文的学习后,相信大家对怎么使用OEL7.2系统system管理源码安装的mysql5.7这一问题有了更深刻的体会,具体使用情况还需要大家实践验证。这里是云,小编将为大家推送更多相关知识点的文章,欢迎关注!

怎么使用OEL7.2系统system管理源码安装的mysql5.7 - MySQL数据库

赞(0)
文章名称:《怎么使用OEL7.2系统system管理源码安装的mysql5.7 - MySQL数据库》
文章链接:https://www.fzvps.com/93632.html
本站文章来源于互联网,如有侵权,请联系管理删除,本站资源仅供个人学习交流,请于下载后24小时内删除,不允许用于商业用途,否则法律问题自行承担。
图片版权归属各自创作者所有,图片水印出于防止被无耻之徒盗取劳动成果的目的。

评论 抢沙发

评论前必须登录!