如何从godaddy中托管的远程服务器访问本地MySql数据库

Question

I am trying to access a database which is in root@localhost from a website hosted by godaddy.

i created a php file in the project folder and trying to access the local mysql database

here is the code

//actionpage.php

<?php

$db=mysqli_connect("127.0.0.1","cancan","canpass","test");


if (!$db) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";

?>

it gives me the error on the browser

Connection failed: Access denied for user 'cancan'@'localhost' (using password: YES)

The website i created is just static html without a back end..

I am pretty new to back end developing , Please help me

Answer 1

So long as Godaddy doesn't block outgoing MySQL connections and your ISP doesn't block incoming MySQL connections, this is technically possible.

You would need to:

1. Configure MySQL to listen on your computer's external network interface (i.e. not on a UNIX socket nor on the loopback IP address).
2. Ensure that the MySQL service is available on the Internet (which will probably mean configuring your Internet router to perform port forwarding for the MySQL port from the Internet to your development machine)
3. Change the connection string in your PHP so it connects to the hostname or IP address of your computer on the Internet (probably your router's external IP address).

You'd probably want to ensure you have a static IP address on the Internet so that you don't need to update the PHP every time your IP changes.

---

This, however, will be slow (because your MySQL traffic has to go back and forth across the Internet) and risky from a security perspective.

So don't do it. Get a MySQL service from Godaddy.