WampServer fixes

##########################################################
# How to fix WampServer if it shows only the orange icon #
##########################################################
1) go to services
2) stop Web Deployment Agent Service
3) restart WampServer

#############################
# How to upgrade phpMyAdmin #
#############################
1) go to phpmyadmin.net and download latest release
2) extract to C:\wamp\apps
3) go to C:\wamp\alias
4) open phpmyadmin.conf
5) change
        Alias /phpmyadmin "c:/wamp/apps/phpMyAdmin-3.2.0.1/"
        <Directory "c:/wamp/apps/phpMyAdmin-3.2.0.1/">
        with:
        Alias /phpmyadmin "c:/wamp/apps/new-version/"
        <Directory "c:/wamp/apps/new-version/">
6) copy config.inc.php from previous folder to new version of phpMyAdmin
7) left click Wamp - Restart All Services
8) right click Wamp - Refresh

#####################################
# How to change phpMyAdmin password #
#####################################
1) C:>mysql -u -root
2) C:>SET PASSWORD FOR root@localhost=PASSWORD('pass');
3) go to C:\wamp\apps\phpmyadmin
4) open config.inc.php
5) change $cfg['Servers'][$i]['password'] = '';
   with
   $cfg['Servers'][$i]['password'] = 'pass';

####################################
# Change MySQL language to English #
####################################
1) open my.ini
2) change
# Change your locale here !
lc-messages=fr_FR
with
lc-message=en_US

##############################################
# Access remote server with local phpmyadmin #
##############################################
1) config.inc.php -> add at end
/* Remote DB access */
$i++;
$cfg['Servers'][$i]['host'] = 'HostName:port'; //provide hostname and port if other than default
$cfg['Servers'][$i]['user'] = 'userName';   //user name for your remote server
$cfg['Servers'][$i]['password'] = 'Password';  //password
$cfg['Servers'][$i]['auth_type'] = 'config';   // keep it as config

########################################
# Log in as another user in phpmyadmin #
########################################
1) Create user
2) Close all open instances to PHPMyAdmin in your browser
3) config.inc.php -> change line
$cfg['Servers'][$i]['auth_type'] = 'config';
to
$cfg['Servers'][$i]['auth_type'] = 'cookie';
3) Visit your PHPMyAdmin URL (localhost/phpmyadmin for example)

#################################
# CakePHP server configurations #
#################################
1) httpd.conf
<Directory "c:/wamp/www/">
    AllowOverride all
</Directory>
LoadModule rewrite_module modules/mod_rewrite.so
2)c:\wamp\www>php -r "readfile('https://getcomposer.org/installer');" | php
  c:\wamp\www>php composer.phar create-project --prefer-dist cakephp/app myfirstcake
  y [folder perissions]