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

来源：互联网发布：淘宝官方下载电脑版编辑：程序博客网时间：2024/04/30 09:08

提示缺少[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

0 0