Home / Questions / 279473
Accepted
RazerJs
Asked: 2020-07-17 14:46:32 +0800 CST 2020-07-17 14:46:32 +0800 CST

phpmyadmin error

  • 772

install xampp 7.3.7; at the beginning I had some problem to start the service so I deleted the files from \xampp\mysql\data ibdata1, ib_logfile1... etc all but the folders I had no information to lose... I ended up changing the port to 3366 and it raised the service correctly... I even added data with mySQL Worbench but when trying to open phpMyAdmin it shows me the error in the photo...

error opening phpMyAdmin admin

  • mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

  • The connection for controluser, as defined in your configuration, failed.

  • mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)

  • phpMyAdmin tried to connect to the MySQL server, and the server refused this connection. You will need to check the host, username and password in config.inc.php and make sure they match the information provided by the MySQL server administrator

They were as default 'root' without password, I tried to change the configuration of my.ini and config.inc.php by enabling the password option and putting a simple one but nothing. Greetings

mysql

3 Answers

  1. Best Answer

    check the connection port from phpmyadmin to mysql since it is not updated and check

    $cfg['Servers'][$i]['host'] = '127.0.0.1:3366';
    • 4

  2. Had the same error after trying to change the password to MySQL User = root and Password = root. After this I got that error; I fixed it by editing the file:

    c:\xampp\phpMyAdmin\config.inc

    and changing the line

    $cfg['Servers'][$i]['password'] = '';

    by:

    enter image description here

    And it worked perfectly...

    I hope it helps you and you get out of the problem...

    • 2

  3. To be able to access through phpmyadmin and ask for the username and password, the config.inc.phpphpmyadmin parameters must be:

    /* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;
    • 1