I – How Can I Solve “Host ‘MachineName’ is not allowed to connect to this MySql Server” Error?
How To Solve;
Go to phpMyAdmin by type in “http://you-nas-ip/phpMyAdmin/” in your browser, enter your username and pass
Once in, click on “Privillages” on the main page just below “Storage engines”.
Under “User Overview” you should have an entry as the circled area below:
if not, add it by clicking on “Add a new user” as below:
User name: root
Host: Any host
Password: Use textfield: password
Database for user: Grant all privileges on wildcard name (username\_%)
Global privileges: Check All
then click on “Go”.
Now go to your MySQL admin tool and try again.