- #!/bin/bash
- #export MYSQL_PWD=chen1989
- #mysql -u root -p "$MYSQL_PWD" <<EOF
- mysql -uroot -padmin123456 <<EOF
- create database energy;
- use energy;
- source /usr/local/energy.sql;
- create database nacos;
- use nacos;
- source /usr/local/nacos.sql;
- create database xxl_job;
- use xxl_job;
- source /usr/local/xxl_job.sql;
- #use mysql;
- #delete from user where Host='localhost' and User = 'root';
- EOF
|