Page 1 of 1

PhpMyAdmin MySql Error

PostPosted: 19. June 2013 23:30
by harrysbird
i installed a xampp 1.7.3 and I added a password and I was on phpmyadmin and I got error

unknown mysql server host 'localhost' (11001)

here Config inc

<?php
/*
* 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
*/
$i++;

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'cookie'; /* Authentication method (config, http or cookie based) */
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;

/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysqli';

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

/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

/*
* End of servers configuration
*/

/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

$cfg['AllowAnywhereRecoding'] = true;
$cfg['DefaultCharset'] = 'utf-8';
$cfg['DefaultLang'] = 'en-utf-8';
$cfg['DefaultConnectionCollation'] = 'utf8_general_ci';

$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman/5.1/en';
$cfg['MySQLManualType'] = 'searchable';

?>


Please Help

Re: PhpMyAdmin MySql Error

PostPosted: 09. March 2015 08:30
by @sbk
good morning, i am begging in php and i will like you to help me this error code #1045 Cannot log in to the MySQL server,
well i have make a change to config.inc.php.safe, which i try to add the user name and password over there and restarted xamp and web
browser still not working.
i believe someone can tell me what to do.
i will be expecting your reply.
Thanks
@sbk

Re: PhpMyAdmin MySql Error

PostPosted: 09. March 2015 12:25
by Nobbie
@sbk wrote:well i have make a change to config.inc.php.safe, which i try to add the user name and password over there and restarted xamp and web


What did you change and why did you change it? Please show us config.inc.php and explain your changes.