I am trying to create a remote website that will be useing my WAMP5 databases untill I am done creating it but It refuses to allow my remote scripts to access the DB even though I have set you a username with the remote IP as host.
Does your firewall/router allow requests coming in from the internet with the destination TCP port 3306 through? You need to set up the port forwarding for TCP port 3306, forwarding these requests to the internal IP address of your WAMP server. Once you have that working, you can then limit the source IP address of these requests to the external IP address of your remote website, if your firewall/router allows you to do that.
username = the MySQL username you want the remote server to use when talking to your MySQL in your WAMP server
web01 = the name of the remote server (computer name or host name)
example.com = the domain name of the remote server
The host information is therefore web01.example.com. When you replace the components with the actual values from your remote server and its domain, you have the host you need to add under your MySQL user as a host so that you can assign access rights to the 'user' which connects from the remote server.
Yes, if: - Dajax is the MySQL username in the db connect parameters of your script running in the remote server - mycompname is the hostname of the remote server - mjolnir.ath.cx is the remote domain.
Just to get it right, the hostname and the remote domain are attributes of the remote server where your PHP scripts are running, different from the computer name and domain where you host your WAMP server and the MySQL database.