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;