#apt-get install mysql-server
导出:
#mysqldump -uroot -p[password]dbname> db.sql
导入:
#mysql -uroot -p[password]
mysql> create database dbname;
mysql> use dbname;
mysql> dbname< db.sql
mysql> exit;
配置:
1.防火墙开放端口3306;
2.添加远程访问权限:
#mysql -uroot -p[password]
mysql> grant all PRIVILEGES on *.* to root@'%' identified by 'password';
mysql> flush privileges;
mysql> exit;
3.编辑/etc/mysql/my.cnf,注释bind-address,或将ip改为0.0.0.0
#service mysqld restart
原文链接:https://blog.csdn.net/icysky1989/article/details/49999417