修改[mysql密码],参照百度经验
https://jingyan.baidu.com/article/454316ab4e9e65f7a7c03ad1.html
字符集修改
- 在cmd的命令状态下,输入如下指令:
- 进入mysql的安装路径,bin路径下,输入:mysql
- set character_set_client=utf8;
- set character_set_connection=utf8;
- set character_set_database=utf8;
- set character_set_results=utf8;
- set character_set_server=utf8;
- SHOW VARIABLES LIKE ‘character%’;
- SHOW VARIABLES LIKE ‘collation_%’;
- ok,搞定