MySQL "Host is not allowed to connect to this MySQL server" (1 Viewer)

[BTJustice]

I installed MySQL Community Server 5.5.8 and am trying to setup the database connection. Every time I try to TEST, it says...

"Host [COMPUTER NAME] is not allowed to connect to this MySQL server"

I took the time to search the Wiki, but all I could find was this which was not helpful...

MySQL - MediaPortal Wiki

I have the hostname as my computer's name.

I set the password as MediaPortal.

I have no idea what to do here. I am running Windows 7 Professional 64-bit.

 

[BTJustice]

I figured it out. When I did the original install, MySQL was not downloaded and installed by MediaPortal setup. That's why I downloaded MySQL Community Server 5.5.8.

I uninstalled and reinstalled MediaPortal and this time it downloaded and installed MySQL "mysql-essential-5.1.38-winx64.msi".

 

[JoeBrady]

I too am getting this message when trying to run the setup.

I did download mysql-essential-5.1.56-winx64 instead of the .38, is this my problem? Any other way around?

 

[Cojun]

AW: MySQL "Host is not allowed to connect to this MySQL server"

Hi,

in some cases, you configured your computer with a specific computer name like "tvserver" or something else. In this case, MYSQL will not allow the connection from this hostname because you can only connect from "localhost" in the default settings.

How to solve this problem:

1. Install MySQL GUI-Tools
2. Open MySQL-Administrator login to MySQL
3. Click on User administration
4. On the left lower site you will find a user list. Find the user wich Mediaportal should use to connect. Right click on that username an choose "Add new host" (or something like this).
5. Now provide the hostname of your computer (e.g. tvserver)

Ready!
MP can now connect to MySQL

Cheers

Daniel

 

[tom bradley]

hate to bring up a dead post but i am having the same problems and MySQL combined Adminstrator tools and GUI Tools into one big thing and i dont know what i am looking for.

if anyone wants to help that would mean a lot.

 

[pasindulakmal]

I also had the same problem,

I have created a new user for MySQL with all privileges.

Problem solved.