Page 1 of 1

[SOLVED] Can't login at phpMyAdmin

PostPosted: Jan 3rd, '14, 07:40
by janpihlgren
I'm running Mageia 3 kernel 3.10.24-desktop-2.mga3 x86_64, ThinkPad W701 with 16GB RAM.
Database = mariadb 5.5.28 13.mga3
phpmyadmin is 3.5.8.2 1.mga3 noarch
Firefox is 24.1.1
skip_networking is set to OFF
When running webmin I have no problem to access MySQL.
I haven't used phpMyAdmin for a while. When I for a couple av days ago tried to access my mysqldatabases through phpMyAdmin I get the following message:
#2000 Kan ej logga in på MySQL-servern

Translation:
#2000 Can't logg in at the MySQL-server

When I access MySQL in a terminal window I have no problem. I can logg in as root and as user.
I uninstall phpMyAdmin and install it again. No success.

I have no idea where to look to solv the problem. :(

Re: Can't login at phpMyAdmin

PostPosted: Jan 3rd, '14, 11:10
by filip
Take a look at a:
/etc/phpmyadmin/config.php

Re: Can't login at phpMyAdmin

PostPosted: Jan 3rd, '14, 12:51
by janpihlgren
Thanks for advice.
I changed $cfg['Servers'][$i]['auth_type'] from cookie to http.
I get the following message:
#2000 - mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file

I changed the password as adviced.
Then I was able to logg in through phpMyAdmin.
I had to reedit config.php again and change back again to cookie.
Now I can logg in again.
If the error apear again I'll try to remember how to edit config.php
Thanks.