#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 1The likely cause is: $cfg[‘Servers’][$i][‘controlhost’] = ‘192.168.164’; and it does not have global privileges! Therefore, you need to add a copy of the root user and set its host to 192.168.1.64.
An error occurred at this step, but I did not organize the screenshot. Ultimately, I had to change $cfg[‘Servers’][$i][‘controlhost’] = ‘localhost’; in phpMyAdmin on the server to successfully complete the step of copying the root user.
Edit the root user privileges for the host 192.1.68.1.64! Set it to have global privileges for the database.Edit the zhidao.hmwis.top user privileges on the localhost host! Set it to have global privileges for zhidao.hmwis.top.Privileges updated successfully. At this point, $cfg[‘Servers’][$i][‘controlhost’] = ‘192.168.1.64’; is set. This means you can manage the server’s MySQL through phpMyAdmin from other machines.
![The likely cause is: $cfg['Servers'][$i]['controlhost'] = '192.168.164'; and it does not have global privileges! Therefore, you need to add a copy of the root user and set its host to 192.168.1.64.](https://media.shuijingwanwq.com/2015/01/35.png)
![Privileges updated successfully. At this point, $cfg['Servers'][$i]['controlhost'] = '192.168.1.64'; is set. This means you can manage the server's MySQL through phpMyAdmin from other machines.](https://media.shuijingwanwq.com/2015/01/63.png)