Host computer-name is not allowed to connect to this mySQL Server

Posted on 2014-08-11
Last Modified: 2014-08-19
Hi guys,

We still have some applications that runs old MySQL data bases and until some time ago we didn't have any problems to use them.

We are using:

WinMySQLadmin 1.4
MySQL Control Center 0.9.4
MyODBC 3.51

I already share the C:/Mysql folder

This time I'm using a workgroup and I can see all the computers, the problem is when I try to test the connection with myODBC and this error appears:

Host "computer-name" is not allowed to connect to this MySQL Server

Thank you so much in advance !!!
Question by:elm9999
    LVL 82

    Expert Comment

    by:Dave Baldwin
    I almost always set up connections with IP addresses and not host names.  Check the user privileges that you are trying to use to make sure that "computer-name" is allowed to connect.

    I don't know of any reason to share "C:/Mysql".  That does not enable remote computers to connect to the database.

    Author Comment

    Thank you Dave

    Actually I already test it with IP addresses and the same result.

    Accepted Solution

    This time I can use the application without network.

    Author Closing Comment

    I just wanted to share the same data base with laptops outside the office but just for 2 hours, so I did it locally on three laps.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    I have been using r1soft Continuous Data Protection ( for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
    Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now