Update : It’s seems that Xampp is better !
Yes, it can be done but it will also depends on performance of your pc of course. Using phptriad, you can setup your own php web development server in just 7 minutes time. It will save a lot of your time.
I will recommend this method if you are new with this stuff and want to test it on your local pc.
PHPTriad is a package for Windows that will, with a click of the mouse, install the Apache web server, PHP, and MySQL on your computer with all the necessary configurations. The following is a simple tutorial to set up PHPTriad and MySQL.
Download the PHPTriad software to any temp folder.
Once downloaded, simply clicking on the self-installing executable, will install the trio in a root folder called apache. Under that directory are all of the components including Apache, PHP and MySQL. Apache and MySQL are servers that need to be started in order for them to function.Scripts must be placed in the C:\apache\htdocs folder.
The install will place the following shortcuts under Start menu -> PHPTriad:
- Launch site
- Shutdown MySQL (shuts down the MySQL server)
- Start Apache (starts the Apache web server)
- Start MySQL (starts the MySQL server)
Note the following from the MySQL reference manual:
The default privileges on Windows give all local users full privileges to all databases without specifying a password. To make MySQL more secure, you should set a password for all users and remove the row in the mysql.user table that has Host=’localhost’ and User=’ ‘.
You should also add a password for the root user. The following example starts by removing the anonymous user that can be used by anyone to access the test database, then sets a root user password:
mysql> DELETE FROM user WHERE Host=’localhost’ AND User=”;
C:\> C:\apache\mysql\bin\mysqladmin reload
C:\> C:\apache\mysql\bin\mysqladmin -u root password your_new_password
phpMyAdmin is intended to handle the adminstration of MySQL over the Web.
Currently it can:
- create and drop databases
- create, copy, drop and alter tables
- delete, edit and add fields
- execute any SQL-statement, even batch-queries
- manage keys on fields
- load text files into tables
- create and read dumps of tables
- export and import CSV data
- administer one single database
PHPMyAdmin comes with the PHPTriad software. If you change the security options for the MySQL database (as stated above) you will need to change the configuration file for PHPMyAdmin.
- Open the file: C:\apache\htdocs\phpMyAdmin\config.inc.php with any text editor.
Look for the following two lines
$cfgServers['user'] = ‘root’; // MySQL user (only needed with basic auth)
$cfgServers['password'] = ‘ ‘; // MySQL password (only needed with basic auth)
Note that second line does not have a password. Enter the root password here which you selected earlier.
Now,as a ‘root’ user the PHPMyAdmin web administration page should give you full privilege to all the databases.