Error while localy connecting to MySql

Asked Aug 04 '12 at 18:09

Active Aug 04 '12 at 18:13

Viewed 464 times

Today when I wanted to connect to my local MySQL server, I got an error message from server:

Host '192.168.1.100' is not allowed to connect to this MySQL server.

What does this mean? My machine is a MacBook Pro with OSX Lion. Yesterday everything was fine, but today when I want connect mysql with Eclipse, I got this error. In Navicat everything work fine, I can open shemas and write select.

edited Aug 04 '12 at 18:13

bfavaretto

71,580
16
111
150

asked Aug 04 '12 at 18:09

Jack Daniel

2,397
8
33
58

1

Use `localhost` or `127.0.0.1` instead of the LAN IP. – bfavaretto Aug 04 '12 at 18:11
So local = on your local machine? Can you show the code you are using to connect? – Pekka Aug 04 '12 at 18:15
i use this string to connect to database: jdbc:mysql://localhost:3306/hibernate-test and I don't use LAN IP. i use localhost – Jack Daniel Aug 04 '12 at 18:47
but when I'm using 127.0.0.1 in the string of connection, everything is OK. why system see localhost as my lan ip? – Jack Daniel Aug 04 '12 at 19:01

Error while localy connecting to MySql

0 Answers0