羿工数据库环境更新

sudo apt-get update
sudo apt-get upgrade
apt-get install libaio1
sudo dpkg -i *.deb

GRANT ALL ON *.* TO ‘ig’@’%’ IDENTIFIED BY ‘*******’ WITH GRANT OPTION;
GRANT ALL ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘******’ WITH GRANT OPTION;
flush privileges;

用有效的配制文件替换/etc/mysql/mysql.conf.d/mysqld.cnf文件
service mysql restart

复制表
SET SESSION innodb_strict_mode = OFF;
导入ms_mdate表

ms_batchpropertyv
ms_batchpropertyv1
ms_batchdetailv1
ms_myorderdetailv
nw_arbegin_l
nw_arre_l
nw_arlast_date
nw_arlast_dateam

chmod 755 /etc/rc.local
sudo echo ‘#!/bin/bash’ > /etc/rc.local

export JAVA_HOME=/opt/java/jdk1.8.0_181
export JRE_HOME=$JAVA_HOME/jre
export CLASSPATH=.:$CLASSPATH:$JAVA_HOME/lib:$JRE_HOME/lib
export PATH=$PATH:$JAVA_HOME/bin:$JRE_HOME/bin
source /etc/profile
注意：
mysqld.cnf
innodb_buffer_pool_size = 15G根据实际硬件内存大小调整
文件权限设为0644