通过phpMyAdmin添加用户的时候报错:check the manual that corresponds to your MySQL server version for the right syntax to use的解决!

#1064 – you have an error in your SQL syntax;check the manual that corresponds to your MySQL server version for the right syntax to use near’* TO ‘zhidao.hmwis.top’@’localhost” at line 1
![分析原因应该为:$cfg['Servers'][$i]['controlhost'] = '192.168.164';而其本身并不具有全局权限!因此需要添加复制root用户,使其主机为192.168.1.64。](http://www.shuijingwanwq.com/wp-content/uploads/2015/01/35.png)


![权限成功更新,此时$cfg['Servers'][$i]['controlhost'] = '192.168.1.64';了。也就是说可以在其他机器上通过phpmyadmin管理服务器上的MySQL。](http://www.shuijingwanwq.com/wp-content/uploads/2015/01/63.png)
近期评论