Host Is Not Allowed To Connect To This MySQL Server Error In Visual Foxpro

When you encounter this type of error in VFP, it may mean that the MySQL account you are using does not have the right privileges.

For a quick fix, go to the server PC and open MySQL Command Line Client. Type the command below:

grant all privileges on *.* to root@'%' identified by 'YourPassword';

Change the 'root' if you're not using that user and change YourPassword with your own password.