| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 100767 | 2009-06-20 00:24:00 | SQLYog Connection to Database | LarsJohann (13010) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 783805 | 2009-06-20 05:36:00 | First off, put your hosts file back how it was before - changing it will not help, and removing the localhost entry will break things. When I said to remove the line reading 'bind 127.0.0.1' I was talking about the MySQL config file (usually my.cnf), not the hosts file. To solve error 1130 you'll need to grant the correct permissions to your users - somebody's post above explains how to do that. |
Erayd (23) | ||
| 783806 | 2009-06-20 18:56:00 | # Copyright (c) 1993-2006 Microsoft Corp. # # This is a sample HOSTS file used by Microsoft TCP/IP for Windows. # # This file contains the mappings of IP addresses to host names. Each # entry should be kept on an individual line. The IP address should # be placed in the first column followed by the corresponding host name. # The IP address and the host name should be separated by at least one # space. # # Additionally, comments (such as these) may be inserted on individual # lines or following the machine name denoted by a '#' symbol. # # For example: # # 102.54.94.97 rhino.acme.com # source server # 38.25.63.10 x.acme.com # x client host 127.0.0.1 localhost # This was the line I removed 11.111.111.11 mysql.ath.cx # Me 22.222.22.22 mysq.ath.cx # My Dev <- I just added him in ::1 localhost Alright, so that's what it used to look like before I removed 127.0.0.1. My Dev gets the error 1130 when trying to connect, so there must be something I'm not doing to unblock him. If I make any changes to host file, should I restart the MYSQL Window Service? or restart the computer? :thanks |
LarsJohann (13010) | ||
| 783807 | 2009-06-21 03:35:00 | You don't (usually) need to reboot after changing the hosts file, but it doesn't hurt. As has been mentioned above, this isn't a firewall issue - it's a permissions issue. You need to grant your developer access from hosts other than localhost. You can do this via the GRANT command, or if you'd prefer most GUIs have the ability to set privileges. |
Erayd (23) | ||
| 1 2 | |||||