[SOLVED] Can't login at phpMyAdmin

This forum is dedicated to basic help and support :

Ask here your questions about basic installation and usage of Mageia. For example you may post here all your questions about getting Mageia isos and installing it, configuring your printer, using your word processor etc.

Try to ask your questions in the right sub-forum with as much details as you can gather. the more precise the question will be, the more likely you are to get a useful answer

[SOLVED] Can't login at phpMyAdmin

Postby janpihlgren » Jan 3rd, '14, 07:40

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. :(
Last edited by janpihlgren on Jan 3rd, '14, 13:07, edited 3 times in total.
User avatar
janpihlgren
 
Posts: 294
Joined: Mar 30th, '11, 12:23
Location: Marsta, Sweden

Re: Can't login at phpMyAdmin

Postby filip » Jan 3rd, '14, 11:10

Take a look at a:
/etc/phpmyadmin/config.php
filip
 
Posts: 478
Joined: May 4th, '11, 22:10
Location: Kranj, Slovenia

Re: Can't login at phpMyAdmin

Postby janpihlgren » Jan 3rd, '14, 12:51

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.
User avatar
janpihlgren
 
Posts: 294
Joined: Mar 30th, '11, 12:23
Location: Marsta, Sweden


Return to Basic support

Who is online

Users browsing this forum: No registered users and 1 guest