How can I fix authentication?

Question

I installed XAMPP server and it run correctly, but when I went to connect to phpMyAdmin by remote access I have this problem:

enter image description here

My configuration of config.inc.php is:

$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'my ip address';
$cfg['Servers'][$i]['port'] = '3306';

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

Even when I configure a password and I enter by it I have the same problem.

http://stackoverflow.com/questions/22033083/xampp-start-automatically-on-windows-7-startup/22033578#22033578 — Sathish D, Apr 21 '16 at 08:40
@SathishD That is to run MySQL automatically, I don't think that will fix anything. — node_modules, Apr 21 '16 at 08:41
I don't quite understand: you are able to connect to mysql from the localhost and unable to connect to the same server from external machine? — user4035, Apr 21 '16 at 08:43
The MySQL Server cannot be connected implies it is a problem with the server not accepting incoming connections. You need to contact the server administrator or you need to allow incoming connections from your IP. Correct me if I am wrong. — Praveen Kumar Purushothaman, Apr 21 '16 at 08:43
@user4035 He's trying to connect to the server MySQL. Check carefully. :) — Praveen Kumar Purushothaman, Apr 21 '16 at 08:44
@PraveenKumar In this case he needs to allow external connections for hist host for the root user in his mysql. — user4035, Apr 21 '16 at 08:52
@user4035 Yes, that's what I am telling. But some geniuses answer like below. :D — Praveen Kumar Purushothaman, Apr 21 '16 at 08:54
@PraveenKumar Yes, it's a simplified answer. I think, I gave him the code to GRANT access from remote host to root. — user4035, Apr 21 '16 at 08:55

score 1 · Answer 1 · answered Apr 21 '16 at 08:54

1

In MySQL allow access from your host to root user:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'<your IP or %>' IDENTIFIED BY '<password>';

<your IP or %> = Is either your IP or "%" symbol to allow access from all the hosts.

<password> = your root password

answered Apr 21 '16 at 08:54

user4035

21,015
10
54
86

score -1 · Answer 2 · answered Apr 21 '16 at 08:41

-1

Change:

$cfg['Servers'][$i]['AllowNoPassword'] = true;

to

$cfg['Servers'][$i]['AllowNoPassword'] = FALSE;

answered Apr 21 '16 at 08:41

Webeng

6,796
4
27
55

The MySQL Server cannot be connected implies it is a problem with the server not accepting incoming connections. Correct me if I am wrong. – Praveen Kumar Purushothaman Apr 21 '16 at 08:42

How can I fix authentication?

2 Answers2