V
V
Vladimir Novitsky2018-02-13 21:50:34
MySQL
Vladimir Novitsky, 2018-02-13 21:50:34

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

1 answer(s)
B
Boris Korobkov, 2018-02-13
@BorisKorobkov

Access denied for user 'root'@'localhost'

Have you tried translating into Russian?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question