phpMyAdmin authentication problem

Und alles was mit phpMyAdmin seine Verwandtschaft findet hat hier seinen Platz.

phpMyAdmin authentication problem

Postby bronfai » 07. January 2016 11:16

Hey there,
I installed xampp 7.0.1 on Mint 17

I can enter in mysql by typing in terminal
$ mysql -u root -pMYPASSWORD

In /opt/lampp/phpmyadmin/config.inc.php
It is as follows:

$ cfg ['Servers'] [$ i] ['auth_type'] = 'http';
$ cfg ['Servers'] [$ i] ['user'] = 'root';
$ cfg ['Servers'] [$ i] ['password'] = 'MYPASSWORD';

When I log on phpMyAdmin, in the authentication window I write

User name: root
Pasword: MYPASSWORD

Problem: "Wrong username / password. Access denied."

In Xampp Control Panel "MySQL STOPPED" is always shown and I can not start (Apache and ProFTPD are running)
How I can solve?
bronfai
 
Posts: 4
Joined: 07. January 2016 10:59
Operating System: Mint 17

Re: phpMyAdmin authentication problem

Postby Nobbie » 07. January 2016 13:12

bronfai wrote:$ cfg ['Servers'] [$ i] ['auth_type'] = 'http';
$ cfg ['Servers'] [$ i] ['user'] = 'root';
$ cfg ['Servers'] [$ i] ['password'] = 'MYPASSWORD';


You have a wrong understanding, how these credentials are working. You only need to specify user and password, when you choose "config" as auth_type. In that case, phpmyadmin will try to login automatically by using these values for the MySQL Login. If you specify "http" or "cookie" (i prefer "cookie" by the way, it looks nicer), you will be prompted instead for a User and Password, the values of config.inc.php then will be ignored (the do not have any meaning, you even may leave them empty).

bronfai wrote:When I log on phpMyAdmin, in the authentication window I write

User name: root
Pasword: MYPASSWORD

Problem: "Wrong username / password. Access denied."

In Xampp Control Panel "MySQL STOPPED" is always shown and I can not start (Apache and ProFTPD are running)
How I can solve?


I think, that you may already have another MySQL installation up and running, which collides with Xampps MySQL. You cannot run MySQL twice. Login as root and run a "ps -fe" command in order to find out, if there is already a process called "mysqld". Also if you simply enter "mysql ...." in a shell and there is starting up the MySQL interpreter, this might not be the Xampp interpreter (which is stored in /opt/lampp/....), but the interpreter from your Linux distribution. You can find out that by entering "which mysql" in a shell, it tells you exactly, where mysql is stored. i think, it is /usr/bin/mysql.

If i am right, you have to start your Application manager or Software manager (or similar, depends on your distribution) and de-install the MySQL version. Then reboot the machine and try to start Xampps MySQL again. Keep in mind, that Xampps MySQL comes with a user "root" without any password (you may change that later on in PhpMyAdmin, there is a User menu).
Nobbie
 
Posts: 8770
Joined: 09. March 2008 13:04

Re: phpMyAdmin authentication problem

Postby bronfai » 07. January 2016 15:27

Oops! with "ps-fe" MySQL appears in "/usr/sbin/mysql"
Now I try to uninstall it.

Thank you very much for your help!...
bronfai
 
Posts: 4
Joined: 07. January 2016 10:59
Operating System: Mint 17

Re: phpMyAdmin authentication problem

Postby bronfai » 07. January 2016 17:46

At last, now I have running /opt/lampp/sbin/mysqld

But the problem remains :-(

In config.inc.php it appears:

$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

/* Server parameters */
//$cfg['Servers'][$i]['host'] = 'localhost';
//$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;

When I enter localhost and then phpMyAdmin, again asked me the same thing:

"The server http://localhost:80 requires a username and password. The server says: phpMyAdmin localhost" asking User Name and Password
bronfai
 
Posts: 4
Joined: 07. January 2016 10:59
Operating System: Mint 17

Re: phpMyAdmin authentication problem

Postby bronfai » 07. January 2016 19:29

Hello,

Fixed: I write username but left empty password. I entered in Mysql and I created an empty database.

I appreciate the help.
bronfai
 
Posts: 4
Joined: 07. January 2016 10:59
Operating System: Mint 17


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 1 guest