MySQL: Host ist not allowed to connect to this MySQL server

URL dieses Beitrags: http://blog.stefan-macke.com/2010/10/27/mysql-host-ist-not-allowed-to-connect-to-this-mysql-server/

When connecting to a (development) MySQL server from a remote machine (e.g. with Oracle SQL Developer) I got the following error message:

Host [my host name] is not allowed to connect to this MySQL server.

All user permissions in the mysql.user table were set correctly (host % for user root) and bind-address in my.conf was set to 0.0.0.0 (I don’t recommend these settings on a production machine!).

I found the solution in the MySQL Reference Manual in Chapter 5.4.7. Causes of Access-Denied Errors: I needed to update my glibc library. After a simple apt-get install libc6 everything worked perfectly.

Kommentare zu diesem Beitrag

  1. Gravatar Markus
    Am 1. November 2010 um 00:24 Uhr

    Name auf das muss man mal kommen?! Aber was mich interessen würde: hast du eine binary version installiert gehabt? Lg

  2. Gravatar Stefan
    Am 1. November 2010 um 13:32 Uhr

    Ich habe MySQL einfach per apt-get installiert, also ist die Antwort wohl “ja” ;-)

Einen Kommentar schreiben

XHTML: Diese Tags sind erlaubt: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>