Allow remote access to MYSQL database

To allow remote access to MySql first create a MySql user and assign host as %.

CREATE USER 'newuser'@'%' IDENTIFIED BY 'password';

then grant privileges

GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'%';

then flush privileges


You may need to add the following to /etc/mysql/my.cnf to listen for all ip’s instead of just localhost, this will override the setting bind-address =

bind-address =

You may also need to allow TCP port 3306 for incoming connections in your firewall for MySql.

Wamp Configuration Virtual Hosts

This guide will change the document root, create a virtual host, bypass proxy(if behind corporate server)for the virtual host.

1. Change 2 entries in httpd.conf

DocumentRoot "c:/wamp/www/"
DocumentRoot "d:/webdir/"


<Directory "c:/wamp/www/">
<Directory "d:/webdir/">

2. Search for and uncomment the line below to enable virtual hosts

# Virtual hosts
Include conf/extra/httpd-vhosts.conf

3. Add a default virtual host and a custom entry by editing the file C:\wamp\bin\apache\apache2.4.9\conf\extra\httpd-vhosts.conf

<VirtualHost *:80>
    ServerName localhost
    DocumentRoot "d:/webroot"

<VirtualHost *:80>
    ServerAdmin [email protected]
    ServerName site1.local
    DocumentRoot "d:/webroot/site1"
    ErrorLog "site1.log"
    CustomLog "site1.custom.log" common

5. Add entry to hosts file, C:\Windows\System32\drivers\etc\hosts      site1.local

6. Restart all services in Wamp

This should work, things to look out for:

Enable Apache Mod_rewrite, although it may appear enabled in Wamp interface also check httpd.conf for the line

LoadModule rewrite_module modules/

If behind proxy server add to exceptions in browser