Goodnight! Maybe I do not understand something, but to connect to a remote SQL database, you need to make a query. Actually the database itself is stored on the site. I try to connect to it in order to check the connection through novicat , but I can not). Gives an error message:

2003 - Can't connect to mySql server on 'myip' (10060).

In all the examples there is some kind of Microsoft Mysql Server, and if you don’t actually have it, on the site, but there is only phpmyadmin and that's it? I can form and work with the database, but I cannot connect to it. In general, I ask for help to solve this problem.

PS Thank you all, who was not too lazy to read my Noob questions.

    4 answers 4

    Virtual hosts very reluctantly open up to MYSQL from the outside. You need to purchase a host or with a personal MYSQL with full access (to open it yourself). But it is still dangerous.

    It is better to try to implement what you want with the help of XML, or make a SOAP server in PHP or JAVA or what else your hoster allows for access to the database.

    And from to connect already to SOAP.

      Take a look at your hosting forum. Maybe someone has already encountered your problem. My hosting provider has everything described in detail how to connect through Navicat and the tunnel.

      • Thanks for the answer. Perhaps I will write in those. hosting support. - LapinioZX
      • In those. I wrote to the support that I need to open a remote access to MySQl to some ip, but if I need to get a request from the database from any computer, then this is contrary to security. So tell me, how can this all be realized? I do not need the most complicated tables, but only 2-3 with a couple of attributes and that's all. - LapinioZX

      In the MySQL configuration there is a line "allow access from the outside for all."

      • Do not quite understand where this line. I looked in different settings and found nothing. Tell me, please, in more detail where to go. Now I am on the main page of phpMyAdmin. - LapinioZX 4:34
      • look for the bind-address line, I look at my.cnf and I don’t know how it is in phpMyAdmin ( - Malus

      According to the ideas, access to the database is opened with the help of "Privileges", in phpMyadmin, (tab "Privelegies"), go in there and:

      1-add new user

      2-when choosing access, list [User_NAME] @ [your ip], (for example, your address is 89.89.89.89, and your username is Sasha, you will

      Sasha@89.89.89.89

      ) It seems so I think .. And if it does not work out, then the hoster should be contacted, unfortunately ..