linux安装mysql即热部署

linux下安装mysql
mysql安装教程
https://blog.youkuaiyun.com/pengjunlee/article/details/81212250
systemctl start mysqld.service #启动 mysql
systemctl restart mysqld.service #重启 mysql
systemctl stop mysqld.service #停止 mysql
systemctl enable mysqld.service #设置 mysql 开机启动

mysql> use mysql;
mysql> update user set password=PASSWORD("这里输入root用户密码") where User='root';
mysql> flush privileges;

mysql设置远程登录

GRANT ALL PRIVILEGES ON *.* TO 'your username'@'%'
 IDENTIFIED BY 'your password';

数据库热部署

mysqldump -uroot -pok databaseName tableName>filename.sql
source absolutionPath