| 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 | ||
| 783795 | 2009-06-20 00:24:00 | Hello everybody, I am trying to set up an SQL database on my computer and am using the client called SQLYog and i am wondering ,how can I set up a database to have others connect to it instead of using Localhost? I run my connection through DynDNS.What are the steps to get others to be able to connect to my database? Thanks alot, Simon. |
LarsJohann (13010) | ||
| 783796 | 2009-06-20 00:32:00 | What sort of SQL database is this? MS SQL Server (if so, is it 2005 or 2008)? | somebody (208) | ||
| 783797 | 2009-06-20 00:49:00 | I am running MySQL 5.1. | LarsJohann (13010) | ||
| 783798 | 2009-06-20 01:09:00 | I am running MySQL 5.1. Comment out the 'bind 127.0.0.1' line from the config file, and restart MySQL - it will then bind to all addresses by default. This will make it publicly accessible. |
Erayd (23) | ||
| 783799 | 2009-06-20 01:17:00 | Comment out the 'bind 127.0.0.1' line from the config file, and restart MySQL - it will then bind to all addresses by default. This will make it publicly accessible. After that, you will need to forward port 3306 on your router through to your computer. Then anyone on the internet should be able to connect to your database by using your DynDNS address. |
somebody (208) | ||
| 783800 | 2009-06-20 02:40:00 | Hello everyone thanks for the help, but i still cannot connect to my DYNS address. I get some error :s | LarsJohann (13010) | ||
| 783801 | 2009-06-20 04:05:00 | Hello everyone thanks for the help, but i still cannot connect to my DYNS address. I get some error :s Any chance you could let us know what "some error" says? |
Erayd (23) | ||
| 783802 | 2009-06-20 04:43:00 | It gives me the error code "Error 1130". | LarsJohann (13010) | ||
| 783803 | 2009-06-20 05:24:00 | Alright, for example purposes, the DynDNS Host is mysql.ath.cx MySQL Info: Username: Root Password: Root Now what I'm trying to accomplish here, is to have my developers be able to connect to the database by using the hostname mysql.ath.cx with the username of root and password of root. I have gone to the host file in windows/system32/drivers/etc and deleted the 127.0.0.1 localhost line so that it reads 11.111.111.11 mysql.ath.cx. But when i try logging in I get this error: Error 1130 (i691.photobucket.com) In that picture, i edited my info to go with the example. UPDATE: I apologize, the image is super small for some reason >.< You'll have save it and zoom in. Sorry about that. Now this is what my host file reads: # 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 11.111.111.11 mysql.ath.cx ::1 localhost Is there something I'm not typing right? Thank you for your time and appreciate all the help I can get. |
LarsJohann (13010) | ||
| 783804 | 2009-06-20 05:27:00 | I can't vouch for the validity of this, but you can try: lists.mysql.com | somebody (208) | ||
| 1 2 | |||||