Answer the question
In order to leave comments, you need to log in
When I try to login phpMyAdmin gives error #1045. How to fix?
Installed the server, including phpMyAdmin. When trying to log in, it gives an error: #1045 - Access denied for user 'root'@'localhost' (using password: YES) and below mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' ( using password: YES)
The configuration file was created via setup in PMA:
<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 4.7.7 setup script
* Date: Tue, 13 Feb 2018 10:18:58 +0000
*/
/* Servers configuration */
$i = 0;
/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '12345';
/* End of servers configuration */
$cfg['blowfish_secret'] = 'ojG(]H&/L\'-!pbvtq.~EjdcKc*<xLAL1';
$cfg['DefaultLang'] = 'en';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>
Answer the question
In order to leave comments, you need to log in
Access denied for user 'root'@'localhost'
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question