error when entering mysql with XAMPP 3.2.2

Question

error when entering mysql with XAMPP 3.2.2

Navigation

#1 by (0 votes)

0

Hello everyone I have I am finding myself with the following problem

when trying to enter the phpmyadmin server on my local host sends me the following error

in my config.inc.php

/*
 * Servers configuration
 */
$i = 0;

/*
 * First server
 */
$i++;

/* 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'] = true;
$cfg['Lang'] = '';

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

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

mysql

asked by antonio sanchez 19.04.2018 в 21:08

source

1 answer

Execution Problems AsynkTask Go back, modify the DOM after it renders

score 0 · Answer 1

Try to do the following:

From a mySQL console:

UPDATE mysql.user SET Password=PASSWORD('nuevoPassWord') WHERE User='root';
FLUSH PRIVILEGES;

See how to use the mysql console from windows

In your file config.inc.php modify the following line

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

For this:

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

Restart the xampp and start it again.