[root@localhost]# cat /var/lib/mysql/hostname-err
[Warning] './mysql/host'
had no or invalid character set, and default character set is multi-byte, so
character column sizes may have changed
[Warning] './mysql/user' had no or
invalid character set, and default character set is multi-byte, so character
column sizes may have changed
[Warning] './mysql/db' had no or invalid
character set, and default character set is multi-byte, so character column
sizes may have changed
[ERROR] Fatal error: mysql.user table is damaged or in
unsupported 3.20 format.
mysqld ended
이것은 mysql의 user를 관리하는 table이
3.20 포맷으로 만들어졌기 때문 입니다.
임시적으로 아래와 같이 실행할수잇읍니다.
[root@localhost]#
mysqld_safe --skip-grant-tables --user=mysql &
또한 멀티바이트 캐릭터셋을 지원하지
않는 버젼에 관한 에러는 아래의 픽스로 수정할수있읍니다.
[root@localhost]#
mysql_fix_privilege_tables --password=MySQL_ROOT_PASSWORD
This script updates
all the mysql privilege tables to be usable by
MySQL 4.0 and
above.
This is needed if you want to use the new GRANT
functions,
CREATE AGGREGATE FUNCTION, or the more secure passwords in
4.1
done