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

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 = 127.0.0.1

[mysqld]
bind-address = 0.0.0.0

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

Git Bash using Laravel Artisan displays escaped characters

If you have output similar to below displaying escaped characters try changing Git Bash options for terminal to xterm-256color

 ←[33mevent←[39m
  ←[32mevent:generate←[39m      Generate the missing events and listeners based
on registration
 ←[33mhandler←[39m
  ←[32mhandler:command←[39m     Create a new command handler class
  ←[32mhandler:event←[39m       Create a new event handler class
 ←[33mkey←[39m
  ←[32mkey:generate←[39m        Set the application key
 ←[33mmake←[39m
  ←[32mmake:command←[39m        Create a new command class

Git Bash 2.6.2, windows 8.1 64bit

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/"
to
DocumentRoot "d:/webdir/"

and

<Directory "c:/wamp/www/">
to
<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>

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

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

127.0.0.1      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/mod_rewrite.so

If behind proxy server add to exceptions in browser