mysql导入导出与授权远程访问
===
1.mysql导出
mysqldump -uroot -p'password' dbname > /media/dbname.sql
2.mysql导入
mysql -uroot -p'password' dbname < /media/dbname.sql
3.远程访问授权:
你想使用rowsea从任何主机连接到mysql服务器的话。
GRANT ALL PRIVILEGES ON *.* TO '用户名'@'授权的IP' identified by 'rowsea.com' WITH GRANT OPTION ;
flush privileges;
flush tables;4.修改密码
update user set password=PASSWORD('rowsea.com') where user='root';
flush privileges;
flush tables;