Connect to MySQL through localhost ?
-
Hi everybody. I bought a hosting to a server (no matter which are), and there I made a MySQL database ... and I want to connect to this MySQL database, through ODBC. When I tried to connect through ODBC driver GUI, I get
[Connection failed. Can't connect to MySQL server on 'mydomain.com'(10060)]error. On server side, I had done everything to be able to connect (add my IP on remote MySQL list, create user, pass, and database, grant all rights to user, etc.). But the guys from hosting said that I will be able to connect on my MySQL DB through localhost .... it is possible to do that ? If yes, how ? Can you help me ? Thank you. -
Hi everybody. I bought a hosting to a server (no matter which are), and there I made a MySQL database ... and I want to connect to this MySQL database, through ODBC. When I tried to connect through ODBC driver GUI, I get
[Connection failed. Can't connect to MySQL server on 'mydomain.com'(10060)]error. On server side, I had done everything to be able to connect (add my IP on remote MySQL list, create user, pass, and database, grant all rights to user, etc.). But the guys from hosting said that I will be able to connect on my MySQL DB through localhost .... it is possible to do that ? If yes, how ? Can you help me ? Thank you.You have to check with the hosting services in what way MySQL configured...You have two main options... 1. MySQL accessible only from applications running on the hosted server... 2. MySQL made public and you can use it from the outside world... In my experience it is always the first option you get... But! also in this case you can access your data from outside, by adding a layer - of some API - of software to it...
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
You have to check with the hosting services in what way MySQL configured...You have two main options... 1. MySQL accessible only from applications running on the hosted server... 2. MySQL made public and you can use it from the outside world... In my experience it is always the first option you get... But! also in this case you can access your data from outside, by adding a layer - of some API - of software to it...
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
Hi everybody. I bought a hosting to a server (no matter which are), and there I made a MySQL database ... and I want to connect to this MySQL database, through ODBC. When I tried to connect through ODBC driver GUI, I get
[Connection failed. Can't connect to MySQL server on 'mydomain.com'(10060)]error. On server side, I had done everything to be able to connect (add my IP on remote MySQL list, create user, pass, and database, grant all rights to user, etc.). But the guys from hosting said that I will be able to connect on my MySQL DB through localhost .... it is possible to do that ? If yes, how ? Can you help me ? Thank you. -
Hi everybody. I bought a hosting to a server (no matter which are), and there I made a MySQL database ... and I want to connect to this MySQL database, through ODBC. When I tried to connect through ODBC driver GUI, I get
[Connection failed. Can't connect to MySQL server on 'mydomain.com'(10060)]error. On server side, I had done everything to be able to connect (add my IP on remote MySQL list, create user, pass, and database, grant all rights to user, etc.). But the guys from hosting said that I will be able to connect on my MySQL DB through localhost .... it is possible to do that ? If yes, how ? Can you help me ? Thank you.Can you connect to the database with other than your project? i.e. MySQL workbench or putty?
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
-
Can you connect to the database with other than your project? i.e. MySQL workbench or putty?
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
-
-
Hi everybody. I bought a hosting to a server (no matter which are), and there I made a MySQL database ... and I want to connect to this MySQL database, through ODBC. When I tried to connect through ODBC driver GUI, I get
[Connection failed. Can't connect to MySQL server on 'mydomain.com'(10060)]error. On server side, I had done everything to be able to connect (add my IP on remote MySQL list, create user, pass, and database, grant all rights to user, etc.). But the guys from hosting said that I will be able to connect on my MySQL DB through localhost .... it is possible to do that ? If yes, how ? Can you help me ? Thank you.For my experience it is always About your Server IP Whitelists. As i understand your MySQL Database is Hosted somewhere using a Professional hosting company. These companies wont just allow outside connections even you knew your DB login credentials. For what i understand you are trying to host a Database online where you can deploy your project anywhere and use that DB as an online storage. This can be achieve by: 1. Make sure that the PC's IP Addess are registered to your server IP Whitelist so they wont block incoming MYSQL connections from your end. 2. Make sure you are using a Static IP otherwise you will have to re register your public ip to your server every time it changes
-
For my experience it is always About your Server IP Whitelists. As i understand your MySQL Database is Hosted somewhere using a Professional hosting company. These companies wont just allow outside connections even you knew your DB login credentials. For what i understand you are trying to host a Database online where you can deploy your project anywhere and use that DB as an online storage. This can be achieve by: 1. Make sure that the PC's IP Addess are registered to your server IP Whitelist so they wont block incoming MYSQL connections from your end. 2. Make sure you are using a Static IP otherwise you will have to re register your public ip to your server every time it changes
"As i understand your MySQL Database is Hosted somewhere using a Professional hosting company. These companies wont just allow outside connections even you knew your DB login credentials" Yes, you are right ... and yes, I already added my IP in the server white list .. not working ! And the solution given by the server administrators was to buy a VPS hosting on their server, or a dedicated server ... for me, in this stage, is not worth it ... I wonder if there exist another workaround ... ?
