Apache Friends Support Forum

Hello,
I have installed XAMP 5.6 on my Ubuntu 14.04 system.
I have used /opt/lampp/manager-linux-x64.run to start Apache and MySql.
I have used phpMyAdmin without password (MySql root default no password.)
All worked fine.
I have readed it is strongly recommended to put a password on the user MySql root user, so i did it, i found two account in the table: root@localhost and root@linux, i puted the same password (only letters and numbers) to both.
I updated the /opt/lampp/phpadmin/config.inc.php with my password.
And...
I can't login anymore with phpMyAdmin, it says "...error... verify the values of host,username,password...".
The log confirm this login error.

Thank you for your help.

Maybe you did a typo?

Instead of providing a password in config.inc.php, you should change the type of authorization from "config" to "cookie". If you do so, you will receive a login dialog upon start of phpmyadmin. Maybe you can login there successfully.

Thank's for your answer. I had almost nothing in my data base so i deleted et reinstalled XAMP and it's working fine now (of coarse...). I will try the XAMP security script and i hope it will better...

Bigoudi wrote:I will try the XAMP security script and i hope it will better...

Dont do so, the security part has been removed from Xampp, the documentation is outdated. But DO NOT use the "fragments" of the security folder and DO NOT use an old security folder, in most cases this results in a destroyed Xampp installation where you cannot access your database anymore.

Instead use PhpMyAdmin to assign a password to "root" and/or create another user with full permissions.