XAMPP or Wamp users can make some mistakes when installing EPESI, as they end by creating a password for root user (when you should have created a new mysql user with password).
This will lock them out of Mysql (and other applications already installed) because root user was (probably) initially created without password. Also phpMyadmin will not be able to login and to remove the password.
[size=150:164ulcwu]PHPMyadmin locked out?[/size:164ulcwu]
If you created a password for root user you will find yourself locked out from phpmyAdmin.
To gain access again, you need to remove the password from Mysql on XAMPP so it works like before.
You will also need to remove the mysql password from EPESI install (so you can still use EPESI without mysql password)
1- Remove the Mysql password from EPESI Xampp install.
#1.1- Edit the file EPESI config.php at your XAMPP directory
\htdocs\YOUR_EPESI_INSTALL\data\config.php
(change YOUR_EPESI_INSTALL = by the folder where you installed EPESI)
#1.2- Clear the value for DATABASE_PASSWORD
/**
* User password to authorize SQL server.
*/
define('DATABASE_PASSWORD','');
2- Reset the password for mysql Root user (The easy way for XAMPP)
#2.1- Go to your phpMyAdmin Xampp directory and edit file config.inc.php
Mine is at:
D:\xampp\phpMyAdmin\config.inc.php
#2.2- Edit (lines 18...) the password and auth type values
This is the way the "Authentication type and info" section should be saved
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';
#2.3- Save the config.inc.php file and restart the XAMPP server.
#4- Enter phpmyadmin and remove password from the root user
#5- Restart XAMPP again
- Ready to go!
- or... The long version for servers:
MySQL :: MySQL 5.5 Reference Manual :: B.5.4.1 How to Reset the Root Password - http://dev.mysql.com/doc/refman/5.5/en/ ... sions.html
