Set up wamp server

Monday, October 26, 2015
After finish installing WAMP server, make sure the its taskbar icon is green color, if it is orange color, then do following steps :
1) u can to turn off or uninstall your antivirus.
2) click wamp orange logo > Apache > Service > Install Service
3) click wamp orange logo > mysql > Service > Install Service
4) restart all services.

open localhost/phpmyadmin on browser, login username is root and password is empty or "password". If u cannot login, maybe because during installation got bug due to didn't install vc.dll or other file. So u need uninstall wamp completely then reinstall it.

When its taskbar is green color. You need to set 3 things :
1) Change password of PHPMYADMIN mysql by console.
2) Change password in PHPMYADMIN config.inc.php file.
3) Change limit in php.ini file.

Change password of PHPMYADMIN mysql by console.


Step 1 : Click wamp icon on taskbar near clock time bottom right corner. Then choose mysql console
Step 2 : When it ask for password, u just hit enter because no password.
Step 3 : Type in : use mysql;
Step 4 : Press Enter.
Step 5 : Type in : UPDATE myslq.user SET Password="PASSWORD("AnyPasswordYoulike") WHERE User="root";
Step 6 : Press Enter.
Step 7 : FLUSH PRIVILEGES;
Step 8 : Type in : Exit
Step 9 : Press Enter.

Step 10: It will show "effacted 1 row in db" if success update database table, if no show that sentence mean it is fail, so check table is it has field password? if no, then replace password file to "authentication string" field in query (new wamp database table dont have password field, only have authentication string field.

Change password in PHPMYADMIN config.inc.php file.


Step 1 : Go to My Computer > C Drive > (Your Local Server Folder, WAMP/MAMP/XAMPP) > APPS > PHPMYADMIN > config.inc.php

Step 2 : Using a text editor, such as Notepad++, open the config.inc.php file.

Step 3 : Find this line of code: $cfg['Servers'][$i]['password'] = ''; // MySQL password

Step 4 : Change 'password' to the new chosen password you created just now.

Step 5 : Click Save.


Change limit in php.ini file.


Step 1 : Click green color wamp icon on taskbar > php > php.ini

Step 2 :
Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Step 3 :
Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

Step 4 : Then restart wamp for the changes to effect.

wamp error 2003 (hy000) can't connect to mysql server on 'localhost' (10061) or #2002 - No connection could be made because the target machine actively refused it.

Monday, September 28, 2015
WAMP logo turn into orange color.

WAMP mysql console shows error 2003 (hy000) can't connect to mysql server on 'localhost' (10061).

localhost/phpmyadmin shows error #2002 - No connection could be made because the target machine actively refused it.

Solution :
Step 1 : click WAMP orange icon and choose "Stop All Services".

Step 2 : go to c:\wamp\bin\mysql\mysql5.6.17\data\ and delete the 2 files ib_logfile0 and ib_logfile1.

Step 3 : click WAMP orange icon and choose "Start All Services".

change port address in WampServer

Friday, March 09, 2012
To change the port address in a Wamp Server Ver 2.0 , at first change the listen port inside the file httpd.conf of apache, and to display the changed port address on wamp server , also change the localhost address and add the port to it inside the file wampmanager.tpl .

To change the port address of Apache in Wamp server :
1. Go to \wamp\bin\apache\apache2.2.8\conf
2. Open “httpd.conf” in notepad
3. Find “Listen 80” and Change it to your desired port (for example : Listen 8081)
4. Save it and close it .

To show the starting page of Wamp Server with new changed port address :
1. Go to \wamp
2. Open “wampmanager.tpl” in notepad
3. Find “http://localhost” and replace with your given port address. For example :
· http://localhost:8081/
· http://localhost:8081/phpmyadmin/
· http://localhost:8081/sqlitemanager/
4. Save and close it .

Special Characters For Text Message

, Thursday, December 02, 2010
Did you see some people wrote those special characters on their facebook and msn before? Example as the following picture :



Enter your email address:

Subscribe in a reader

Follow zac1987 on Twitter

Donation

If you feel my website is informative and it is useful for you, please donate some money to support me or buy me a drink. I will continues this good works. Thank you.