全都变为utf8环境,请问该怎么弄?我改过my。cnf,但是在[mysqld]中如果加了 default-character-set=utf8,那msyql就不能启动
报错信息为下:
081205 16:04:29 [Warning] './mysql/host' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
081205 16:04:29 [Warning] './mysql/user' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
081205 16:04:29 [Warning] './mysql/db' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
081205 16:04:29 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format.
081205 16:04:29 mysqld ended
意思就是说它自己的数据库不能设置为UTF8?
还是只需要创建新的数据库设置它的
CREATE DATABASE NEW default charset utf8 COLLATE utf8_general_ci就可以了?