快速准备(复制替换)一套新测试环境,CentOS7 MySQL相关配置
2023-09-11 14:21:28 时间
拿到一个新环境,需要找相关配置,我有一个办法,相对能比较快速地复制一套环境出来。
修改机器配置:
virsh 相关几条命令,已完成,后续我再整理补充...
虚拟化相关,参考:https://www.cnblogs.com/haochuang/p/9540812.html
修改服务配置:
cd /mnt/app/xxjob/WEB-INF/classes sed -i 's/192.168.0.202/192.168.0.212/g' generator.properties sed -i 's/192.168.0.202/192.168.0.212/g' application.yml sed -i 's/192.168.0.202/192.168.0.212/g' jdbc.properties sed -i 's/192.168.0.202/192.168.0.212/g' application.properties sed -i 's/192.168.0.202/192.168.0.212/g' xxl-job-admin.properties cat /mnt/app/xxjob/WEB-INF/classes/* | grep 192.168.0.202
修改MySQL配置:
[root@localhost etc]# which mysql /usr/bin/mysql [root@localhost etc]# /usr/bin/mysql --verbose --help | grep -A 1 'Default options' Default options are read from the following files in the given order: /etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf
其他稍后待续...
相关文章
- Mysql授权允许远程访问解决Navicat for MySQL连接mysql提示客户端不支持服务器请求的身份验证协议;考虑升级MySQL客户端
- centos7下MySQL的配置
- 关于MySQL数据存储,你了解多少?
- MySQL配置文件mysql.ini参数详解、MySQL性能优化
- 一步完成 MySQL 向 Redis 迁移
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (
- 关于mysql临时表、truncate、delete
- MySQL之父、MariaDB CTO Michael Widenius:创立MariaDB,是希望有一个永远保持开源的MySQL替代品
- Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
- spring boot:shardingsphere+druid+mysql主从复制的读写分离(分库分表)(spring boot 2.3.4)
- MySQL MHA详解(一)——基本原理
- Starting MySQL. ERROR! The server quit without updating PID file (/data/mysql/mysql.pid).
- MySQL数据库主从同步实现
- Starting MySQL ERROR! Couldn‘t find MySQL server (/usr/local/mysql/bin/mysqld_safe)
- 详解MySQL information_schema数据库常用的表信息以及各表对应的字段信息;以及如何登录mysql和创建视图
- 解决ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- MySQL之CentOS7环境下mysql5.7解压安装
- 【服务器安装mysql】centos7下使用mysql离线安装包安装mysql5.7
- [MySQL] 解决办法: Error: Transaction test error: file /etc/my.cnf from install of mysql-community-server