Allow remote access to MYSQL database

contrib Leave a comment

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

contrib 8 Comments

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

contrib Leave a comment

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