MySQL中常见的问题

• 问题描述: MySQL登录始终读取主机名

解决方案

在[mysqld]下设置skip-name-resolve即可

---

• 问题描述: ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

解决方案

select * from information_schema.innodb_trx

kill [trx_mysql_thread_id]

---

• 问题描述：系统自带的MySQL有时虽然授予用户远程登录的权限但是还是无法登录

解决方案

修改配置文件/etc/mysql/mysql.conf.d/mysqld.cnf将下面的bind-address注释掉

---

• 问题描述：MySQL初始化数据库脚本时报错

FATAL ERROR: please install the following Perl modules before executing /usr/local/mysql/scripts/mysql_install_db:
Data::Dumper

解决方案

yum install autoconf -y

---