mysql存储过程、函数，业务编写、启动、停止命令，linux环境下，新增用户，授权，binlog传输数据

=========================================================================================================================================================== IP：192.168.40.4 user：bx/root pwd: bx ssh root@192.168.40.4 uname -a df -h free -g top cat /etc/redhat-release cat /proc/version curl cip.cc curl -v www.baidu.com ----------------安装jdk--------------- yum -y install java-1.8.0-openjdk-devel.x86_64 vi /etc/profile JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.312.b07-1.el7_9.x86_64 JRE_HOME=$JAVA_HOME/jre PATH=$PATH:$JAVA_HOME/bin CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar export JAVA_HOME export JRE_HOME export PATH export CLASSPATH source /etc/profile -----------------安装maven-------------- cd /usr/local/ 创建目录：mkdir maven 进入目录：cd maven/ 下载：wget http://repos.fedorapeople.org/repos/dchen/apache-maven/epel-apache-maven.repo -O /etc/yum.repos.d/epel-apache-maven.repo yum -y install apache-maven 配置环境变量 vi /etc/profile MAVEN_HOME=/usr/share/apache-maven PATH=$PATH:$MAVEN_HOME/bin export MAVEN_HOME source /etc/profile mvn -v ----------------安装redis--------------- yum install -y gcc wget http://download.redis.io/releases/redis-5.0.3.tar.gz tar -zxvf redis-5.0.3.tar.gz cd redis-5.0.3 make make install PREFIX=/home/datadisk/redis 后台启动 cd /home/datadisk/redis/bin/ ./redis-server ./redis.conf 查看redis进程 ps -aux | grep redis cp /usr/local/redis-5.0.3/redis.conf /usr/local/redis/bin/ vi redis.conf 修改 redis.conf 文件，把 daemonize no 改为 daemonize yes bind 0.0.0.0 protected-mode no daemonize yes ps ef|grep redis 确认防火墙是否开启了6379端口 添加端口：firewall-cmd --zone=public --add-port=6379/tcp --permanent 刷新防火墙：firewall-cmd --reload 添加开机启动服务 vi /etc/systemd/system/redis.service 设置开机启动 systemctl daemon-reload systemctl start redis.service systemctl restart redis.service systemctl enable redis.service 创建 redis 命令软链接 ln -s /usr/local/redis/bin/redis-cli /usr/bin/redis 测试 redis ----------------安装nacos--------------- tar -zxvf nacos-server-2.0.3.tar.gz cd /home/datadisk/nacos/bin nohup sh startup.sh -m standalone & sh shutdown.sh http://localhost:8848/nacos/index.htm firewall-cmd --zone=public --add-port=8848/tcp --permanent firewall-cmd --reload http://192.168.10.199:8848/nacos/index.htm ----------------安装nodeJs--------------- xz -d node-v12.22.7-linux-x64.tar.xz tar -xvf node-v12.22.7-linux-x64.tar ln -s /home/datadisk/node-v12.22.7-linux-x64/bin/node /usr/bin/node ln -s /home/datadisk/node-v12.22.7-linux-x64/bin/npm /usr/bin/npm ln -s /home/datadisk/node-v12.22.7-linux-x64/bin/npm /usr/bin/npx npm config set prefix "/home/datadisk/node-v12.22.7-linux-x64/node_global" npm config set cache "/home/datadisk/node-v12.22.7-linux-x64/node_cache" npm install -g yarn --registry=https://registry.npm.taobao.org 安装yarn sudo wget https://dl.yarnpkg.com/rpm/yarn.repo -O /etc/yum.repos.d/yarn.repo sudo yum install yarn ----- mkdir -p /usr/local/yarn wget https://github.com/yarnpkg/yarn/releases/download/v1.12.0/yarn-v1.12.0.tar.gz tar -zxvf yarn-v1.12.0.tar.gz -C /usr/local/yarn vi /etc/profile export PATH=$PATH:/usr/local/yarn/yarn-v1.12.0/bin source /etc/profile ---- chmod -R 777 * node -v ----------------------部署后端和前端工程--------------- cd /home/datadisk nohup java -Dfile.encoding=UTF-8 -jar blade-api.jar & nohup java -Dfile.encoding=UTF-8 -jar blade-api.jar > /home/datadisk/blade-api.log 2>&1 & tail -f blade-api.log ps -ef|grep java netstat -anp | grep 8089 kill jmap -dump:format=b,file=f1 PID http://192.168.10.199/doc.html cd /home/datadisk/saber cd /home/datadisk/saberUI yarn install yarn run serve nohup yarn run serve & firewall-cmd --zone=public --add-port=1888/tcp --permanent firewall-cmd --reload http://192.168.40.4:1888/ http://192.168.10.199:1888/ 获取token Authorization Basic c2FiZXI6c2FiZXJfc2VjcmV0 Blade-Auth 1 Tenant-Id 000000 password 21232f297a57a5a743894a0e4a801fc3 tenantId 000000 username admin ----------------安装mysql------------------------------------------ https://www.cnblogs.com/moonlightL/p/7265595.html https://www.cnblogs.com/zymnstlm/p/12381627.html ps aux | grep mysqld wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm yum -y install mysql57-community-release-el7-10.noarch.rpm yum -y install mysql-community-server yum -y remove mariadb-libs-1:5.5.68-1.el7.x86_64 yum -y remove mariadb-libs-5.5.68-1.el7.x86_64 rpm -e mariadb-libs-5.5.68-1.el7.x86_64 --nodeps 初始化数据库 mysqld --initialize chown mysql:mysql /var/lib/mysql -R 启动数据库 systemctl start mysqld.service 重启服务 service mysqld restart 查看服务状态 systemctl status mysqld.service 查看初始密码 mysql -uroot -p TiCoq2D2kT!b grep "password" /var/log/mysqld.log cat /var/log/mysqld.log | grep 'password' mysql -uroot -p!0QoG5qqmgV8 set password=password('root'); mysql -uroot -proot pager less -SFX; ALTER USER 'root'@'localhost' IDENTIFIED BY 'root'; use mysql; select host,user from user; #多条数据就删除，留一条记录即可 delete from user where host !="localhost"; update user set host='%'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION; flush privileges; firewall-cmd --zone=public --add-port=3306/tcp --permanent firewall-cmd --reload 设置不区分大小写 vi /etc/my.cnf 在[mysqld]节点下增加 lower_case_table_names = 1 :wq 退出 修改字符集 , SHOW VARIABLES LIKE 'character%'; 修改配置文件 my.cnf [client] default-character-set=utf8 [mysqld] character_set_server=utf8 collation-server=utf8_general_ci lower_case_table_names=1 新建用户，赋权 create user 'zbzf_dsj_user1'@'%' identified by 'Zbzfast!@367'; grant select,insert,update,delete,create on zbzf_data_bak.* to zbzf_dsj_user1; grant all privileges on zbzf_data_bak.* to zbzf_dsj_user1@'%'identified by 'Zbzfast!@367'; FLUSH PRIVILEGES; ----------------安装docker--------------- https://www.cnblogs.com/xiaocy66/p/10802614.html yum 包更新到最新 sudo yum update 卸载旧版本(如果安装过旧版本的话) sudo yum remove docker docker-common docker-selinux docker-engine 安装需要的软件包， yum-util 提供yum-config-manager功能，另外两个是devicemapper驱动依赖的 sudo yum install -y yum-utils device-mapper-persistent-data lvm2 设置yum源 sudo yum-config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo sudo yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo 安装最新版本的 Docker sudo yum install docker-ce #由于repo中默认只开启stable仓库，故这里安装的是最新稳定版18.09.5 启动docker sudo systemctl start docker service docker start 查看状态 systemctl status docker 关闭docker sudo systemctl stop docker 重启 systemctl daemon-reload systemctl restart docker systemctl status docker 加入开机启动 sudo systemctl enable docker 执行以下命令，验证安装是否正确 sudo docker run hello-world 查看 Docker 版本 docker version 卸载 Docker 软件包 sudo yum remove docker-ce 如需删除镜像、容器、卷以及自定义的配置文件，可执行以下命令 sudo rm -rf /var/lib/docker 迁移docker目录 mkdir -p /home/datadisk/docker/lib rsync -avzP /var/lib/docker /home/datadisk/docker/lib/ vi /etc/docker/daemon.json { "registry-mirrors": [ "https://registry.docker-cn.com", "http://hub-mirror.c.163.com", "https://docker.mirrors.ustc.edu.cn" ], "insecure-registries":["192.168.10.199:85"], "graph": "/home/datadisk/docker/lib", "storage-driver": "overl