Question: |
In cPanel for remote MySQL IP address that is entered 79.174.64.19 from which the script need to access the database of the website vtp63.EN.Run this code: $db_host = \"88.99.193.234\"; $db_base = \"termotex_vtp\"; $db_user = \"termotex_vtp\"; $db_pass = \"....\"; // The corresponding password $mysqli = new mysqli($db_host, $db_user, $db_pass, $db_base); if ($mysqli->connect_errno) printf(\"Error connecting to database: %s\\n\", $mysqli->connect_error); else echo \"Connection successful\";causes an error:http://www.landkit.ru/db.phpWarning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2003): Can`t connect to MySQL server on `88.99.193.234` (110) in /home/landkit/domains/landkit.ru/public_html/db.php on line 7Ошибка connect to the database: Can`t connect to MySQL server on `88.99.193.234` (110)please Tell me what should be corrected to refer remotely to the database?Thank you! |
Question: |
Extras:1. script db.php very long runs, but in the end will come out the error message.2. if you look on the website SERVER_ADDR vtp63.ru he shows 88.99.193.243 Appeal and that IP address causing the error. |
Answer: |
Hello. By default remote connection to the database for security purposes is locked. To connect You must have a static IP address which we will add in the trusted after which You will be able to connect. If You have static IP just doesn`t work. we will add it. |
Question: |
Good day!Thanks for the reply!Yes, the IP address is static, with our dedicated VPS automatically update our software products, one of which is installed on Your hosting site vtp63.EN.IP address from which you want the database access site vtp63.EN:79.174.64.19 And, tell me, please, for remote database access any IP address as the host parameter to put: 88.99.193.234 or 88.99.193.243? |
Answer: |
as a host, specify the url of your website panel menu - remote mysql Ukazat template % |
Question: |
Thank you, connected. |
Answer: |
ok |
|