mysql问题汇总
1、mysql远程连接失败
mysql -uroot -pAdmin@888 -h10.126.189.167
报错：ERROR 1130 (HY000): Host '10.126.189.167' is not allowed to connect to this MySQL server
# 查看用户情况
# user表里的 host项把localhost改成%
update user set host = '%' where user ='root'; flush privileges;
