I want to make this tutorial as simple/concise as possible, so:
1. Download XAMPP and install it – here it is a video for this step: Xampp tutorial youtube link, only if you are a complete beginner. You do not need to install Filezilla Server, only Apache and MySql.
2. After you have installed XAMPP, do verify if you have both Apache and MySql servers running: Double click on XAMPP icon (XAMPP Control Panel – shortcut on your desktop or xampp-control.exe from your installed XAMPP hard drive location). You have to have both services running and SVC radio buttons of Apache and MySql checked. Otherwise check SVC boxes and start Apache and MySql services. Do remember that you do not have to do this every time you start your computer: Apache PHP application and MySql database will start automatically.
3. Open PhpMyadmin in your web browser: "http://127.0.0.1/phpmyadmin/". As you can see there is no login process for accessing PhpMyadmin which is not the best thing to happen for serious applications or CMS. You definitely need a password for accessing your databases. In PhpMyadmin go to Privileges where you delete all users except 127.0.0.1 and localhost. Edit - Check every privileges and get a password for this two users.
4. After you have saved your changes, go to PhpMyadmin folder from XAMPP installation directory. Find config.inc.php file end edit it:
* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'your password';
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = false;
/* User for advanced features */
//$cfg['Servers'][$i]['controluser'] = 'pma';
//$cfg['Servers'][$i]['controlpass'] = '';
Save this file and copy PhpMyadmin folder in Htdocs folder. Now you have a duplicate information about PhpMyadmin in XAMPP main directory and Htdocs – where your localhost server runs programming scripts.
Run http://127.0.0.1/phpmyadmin. If you will have a login window with user name and password, everything worked as in my explanation. Just type your user name and password (this have to be the same as one saved in your phpmyadmin/privileges form – step 3) and you are all set for work.
An easiest method for 3. - 4. especially for the latest versions of XAMPP is to access 127.0.0.1 or localhost; run security tab from XAMPP menu (127.0.0.1/security), than click on 127.0.0.1/security/xamppsecurity.php. There you will be allowed to change root password without accessing phpmyadmin user privileges or the config file.