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.

Über Stefan

Polyglot Clean Code Developer

2 Kommentare

  1. Markus
    1. November 2010 um 0:24:12

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

  2. Stefan
    1. November 2010 um 13:32:46

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

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert

To create code blocks or other preformatted text, indent by four spaces:

    This will be displayed in a monospaced font. The first four 
    spaces will be stripped off, but all other whitespace
    will be preserved.
    
    Markdown is turned off in code blocks:
     [This is not a link](http://example.com)

To create not a block, but an inline code span, use backticks: 

Here is some inline `code`.

For more help see http://daringfireball.net/projects/markdown/syntax