How to setup LAMP on Windows in 1 minute

June 8, 2010 · Posted in Linux, Open Source, Windows · Comment 

To run php application, most of user will used Apache + PHP + MySQL as their program platform. Most of the beginner user like to setup LAMP on Windows to develop or run the php application. To setup LAMP on Windows, is a bit complicated. But there is asoftware called AppServ to allow us to setup LAMP just in 1 minute.   AppServ is a software with  full-featured of Apache, MySQL, PHP, phpMyAdmin. Read more

How to install phpmyadmin on Centos

February 17, 2010 · Posted in Linux, Open Source, Uncategorized, centos · Comment 

phpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL over the World Wide Web. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions. (Info from http://www.phpmyadmin.net)

How to install phpmyadmin? Before you install phpmyadmin, you need to install your LAMP 1st. Once you install, just follow below steps:-

  1. $ su -
  2. # cd /var/www/html Read more

How To Reset MySQL Root Password

February 12, 2010 · Posted in Linux, Open Source, Uncategorized, centos · Comment 

I setup MySQL Server on CentOS few month ago, but i forgot the root password for MySQL. How to reset the password?

You can recover MySQL database server password with following steps.

Step # 1: Stop the MySQL server process.

service mysqld stop

Step # 2: Start the MySQL (mysqld) in safe mode with the –skip-grant-tables option

mysql_safe -skip-grant-tables-u root & Read more

Next Page »