MySQL配置文件详解

找到C:\Program Files\MariaDB 5.5\data\my.ini

[mysqld]下增加character-set-server=utf8
[client]下增加default-character-set=utf8
[MySQL] 下增加default-character-set=utf8

设置MySQL5.6的远程连接

use mysql; 
//为root添加远程连接的能力  
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";    
//设置root用户密码 
update user set Password = password('123456') where User='root';
//刷新刚才的内容
flush privileges;