mysql数据库导入问题

1.Specified key was too long; max key length is 767 bytes
SHOW VARIABLES LIKE 'innodb_large_prefix';

SET GLOBAL INNODB_LARGE_PREFIX = ON;

SHOW VARIABLES LIKE 'innodb_file_format';

SET GLOBAL innodb_file_format = BARRACUDA;

2. Error Code: 1709 - Index column size too large. The maximum column size is 767 bytes.

建表语句 添加  ROW_FORMAT=DYNAMIC

3.字符集问题
替换字符集为空

4.mysql允许他人连接命令
#other(库名,所有用*),*(表名,可以指定表),123456(密码)
grant all privileges on other.* to root@'%' identified by '123456' with grant option;
flush privileges;