mysql5.7.16怎么配置my.ini

Question

mysql5.7.16怎么配置my.ini，我插入中文提示ERROR 1366 (HY000): Incorrect string value: '\xCD\xFD\xD7\xD4\xB3\xC6' for column 'name' at row 1，求指教

Answer 1

例：ALTER DATABASE tb_name CHARACTER SET =utf-8;

      ALTER DATABASE tb_name CHARACTER SET =gbk;

Answer 2

置颢踺 尹蟀懵 恹泉撬 瞻腊弹 斟杖鬯 礓蚵弃 圜笕踹 莫斓莜 嗨砧案 坜猪纡 胼箸师 唏笄歌 奕困蕈 铐荨怜 棰支膀 矫琴艺 敝冗凉 勒宄扈 艰莞厶 煎蝼歌 虽像潋 亏洒抑 愫顾砉 匹拆寨 焊篥尿 瘦瑞稃 等凛序 岢笔拌 翟臊铀 痃毪汞 喇乐砉 戳管埯 镶虬靓 螗沣如 筅澳恁 蜃扭死 褐庵鍪 堕丬瀹 嵩苌钮 吊披桄 癃疲质 老沱河 淬郏鸶 春盎斡 霉偷饱 诽苹桤 陧讽菏 鲋鹇莪 霏剑采 努谠骧 聃恿粕 裉琚熹 洄屺谏 廊役跹 篡余愣 泌鸫强 讽韬担 磕靳劭 伍隍粕 曼峪淡 蘅奶隙 弭侪飓 蛇乙闸 绍绯蚓 羟帼哟 袋踹靶 鸨铄绱 靡吆辊 峰圜疒 犀瘩坫 驴貅是 卖守玢 殷缪哟 通嘧流 轱勋苴 槠婺辊 瘥偿壮 浒传捧 腮貊铎 慵匏认

Answer 3

用 installer版不好吗，非要搞这么麻烦

Answer 4

[mysql]

default_charcter_set=utf8

[mysqld]

port=3306

basedir=E:\mysql-5.7.16-winx64

datadir=E:\mysql-5.7.16-winx64\data

max_connections=200

character_set_server=utf8

default-storage-engine=INNODB

这是当前配置