Re: #1130 - Host 'localhost' is not allowed to connect to this MySQL server

[Boris Gnarf]

Just wanted to post my findings about a similar problem i had, but on OpenBSD.

- OpenBSD 4.2
- a fresh installation on a new server
- installed mysql-server with the package manager
- created the tables with mysql_install_db
- started server

I could not connect in with localhost, server-ip or any other way.
I traced the problem back to my user.MYD, user.MYI and user.frm not being filled correctly. So there were no users which could actually connect - this results in the same error.

This problem was cause becaues mysql_install_db couldn't create the temporary tables in /tmp (i missed the error messages three times, because the program always outputs quite a bit and i cba reading it).

This was because the rights on the /tmp folder were incorrect, which i blame the openbsd installer for, but anyways... thats it. (fix: chmod 01777 /tmp).

So, to recap: make sure your tables are initialized correct after a new installation.

(Hope i posted this in a relevant forum...)



Edited 1 time(s). Last edit at 11/23/2007 02:20PM by Boris Gnarf.