授权指定IP连接:
grant all on *.* to root@'127.0.0.1' identified by 'root110';
导入带中文的SQL:
mysql -uroot -proot110 table < table.sql -f --default-character-set=utf8
要注意加上-f --default-character-set=utf8
转载于:https://www.cnblogs.com/aquester/archive/2013/02/27/9891740.html