Problemas con mariadb

Problems with the Linux version of XAMPP, questions, comments, and anything related.

Problemas con mariadb

Postby » 18. February 2017 18:01

Buenas tardes.

Instale hace poco mi laamp 5.6.28, con PHP 5.6.28, MariaDb 10.1 y todo funcionaba perfectamente, hasta que importe una base de datos SQL que provenia de una version de MySql 5.5, al importar la base de datos y reiniciar el servidor, me encuentro con el siguiente mensaje:

Welcome to phpMyAdmin Error MySQL said: Documentation Cannot connect: invalid settings. Connection for controluser as defined in your configuration failed. 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.

Despues de mirar por internet, encuentro que debo de hacer algunos cambios en dejandolo como sigue:

* This is needed for cookie based authentication to encrypt password in
* cookie
$cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */

* Servers configuration
$i = 0;

* First server
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
//$cfg['Servers'][$i]['host'] = 'localhost';
//$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;

* phpMyAdmin configuration storage settings.

/* User used to manipulate with storage */
// $cfg['Servers'][$i]['controlhost'] = '';
// $cfg['Servers'][$i]['controlport'] = '';
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = '';

Despues de esto ya no me da el error, pero ahora tengo esta pantalla que me pide user y password, y he probado todas las combinaciones que se me ocurren, pero no puedo entar.


no puedo ver phpmyadmin, ni acceder a mis bases de datos, para modificarlas, alguna sugerencia para corregir este problema.

Muchas Gracias.
Posts: 1
Joined: 18. February 2017 17:28
XAMPP version: 5.6.28
Operating System: Linux Mint 18 Sarah \n \l

Re: Problemas con mariadb

Postby Altrea » 18. February 2017 20:19


in english please. We don't understand spanish here.

best wishes,
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
AF Moderator
Posts: 10265
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 13 guests