MySql安装后各种错误解决办法

提示缺少[ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'

cp share/english/errmsg.sys /usr/share/mysql/errmsg.sys

初始化mysql
/usr/local/mysql# scripts/mysql_install_db --user=mysql

chown -R mysql:mysql /var/lib/mysql

创建系统服务
/usr/local/mysql# cp support-files/mysql.server /etc/init.d/

ln -s /usr/local/mysql/bin/mysqld_safe /usr/bin/mysqld_safe

注意mysqld的路径

datadir = /usr/local/mysql/data

如果提示2003 注释掉

# bind-address = 127.0.0.1

如果提示1045 
/usr/local/mysql# bin/mysql -u root -p 输入密码
mysql> use mysql
mysql> UPDATE user SET Password=PASSWORD('xxxxxx') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit

/usr/local/mysql# service mysql.server restart

支持中文

[client]
default-character-set=utf8
[mysqld]
character_set_server= utf8
#不再进行反解析（ip不反解成域名）
skip-name-resolve