Page 1 of 1

Access denied

PostPosted: 27. February 2019 23:31
by Dani Solis
I'm new in the forum.

I hope I can contribute something to the community.

I have installed XAMPP and Workbench, when try access to "PHPMyAdmin" appear following error:
Image

Similar error appear in Workbench:
Image

I try modified the Config.inc.php file. But error is persistent.

Somebody the forum know how resolve this issue?

Thanks

DS

Re: Access denied

PostPosted: 28. February 2019 09:23
by Nobbie
You havent applied a valid user in config.inc.php

Re: Access denied

PostPosted: 28. February 2019 19:45
by Dani Solis
I access with user root and same password but now not me permit access.

My Config.inc.php file
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = 'pma';

Before:

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = 'pma';

Re: Access denied

PostPosted: 28. February 2019 21:04
by Altrea
Why is $cfg['Servers'][$i]['user'] an empty string and not 'root'?

Re: Access denied

PostPosted: 28. February 2019 22:07
by Dani Solis
With root or without root appear me the error:
MySQL said: Documentation
Cannot connect: invalid settings.

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Lang'] = '';