linux下安装mysql
mysql安装教程
https://blog.csdn.net/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