[Install PHPUnit] Installing PEAR and PHPUnit on WAMP and Windows 7 (no longer maintained from PHPUnit 3.7)

First of all, thanks to @Sebastian Bergmann for reminding and sorry for my careless about this reblog because End of Life for PEAR Installation Method to PHPUnit from github and The package PHPUnit is not maintained anymore and has been superseded. Package has moved to channel pear.phpunit.de, package PHPUnit from pear.php.net.

So this blog should be a reblog of installing PHPUnit(<3.7) in Windows7 from http://thecancerus.com/ and I found it was still useful for understanding the theory of configuration of php(in wamp) and the environment variables.

The newest manual installation of PHPUnit in windows can be found its documentation.

Continue reading

Add user for phpMyAdmin in command line

Background :

Wamp + phpMyAdmin

Objective :

By default, there is no user for phpMyAdmin, so we will create one.

Method :

1. Open the terminal of mysql in Wamp.

2. Type Enter.

3. Commands :

# create a user

CREATE USER 'yourUsername'@'localhost' IDENTIFIED BY 'yourPassword';

# grant all the privilege to the user

GRANT ALL PRIVILEGES ON *.* TO 'yourUsername'@'localhost'
IDENTIFIED BY 'yourPassword' WITH GRANT OPTION;