MySQL Problems & How to Solve

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

retype: 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.


VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>