Cara Mengatasi Error "Connection for controluser as defined in your configuration failed" pada phpmyadmin.

Saat gw buka localhost yang nongol malah Error "Connection for controluser as defined in your configuration failed" pada phpmyadmin.

Pesan error lengkapnya adalah sebagai berikut :

Error

MySQL said:
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

Connection for controluser as defined in your configuration failed.

kali ini gw akan berbagi penyelesaian untuk kasus diatas sesuai apa yang saya alami sendiri, tapi tidak terlepas dengan pesan yang sama namun cara penyelesaianya atau solusinya berbeda, pada keadaan yang gw   alami untuk solusi pesan error seperti ini, gw hanya merubah :

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['host'] = 'localhost'; menjadi $cfg['Servers'][$i]['host'] = '127.0.0.1';$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

pada dokumen konfigurasi phpmyadmin di xampp/phpmyadmin/config.inc.php

akhirnya error dengan keadaan pada kasus di komputer saya pun terselesaikan, karena untuk perintah localhost sendiri sepertinya sudah terpakai oleh aplikasi lainya,
karena bila saya mencari solusi dengan kata kunci #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

jadi lengkapnya seperti di bawah ini : 

/*

 * 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'] = 'config';

$cfg['Servers'][$i]['host'] = '127.0.0.1';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['compress'] = false;

$cfg['Servers'][$i]['user'] = 'root';

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

$cfg['Servers'][$i]['extension'] = 'mysql';

$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* User for advanced features */

$cfg['Servers'][$i]['controluser'] = 'pma';

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

/* 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';

$cfg['Servers'][$i]['tracking'] = 'pma_tracking';

$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';

/*

 * End of servers configuration

 */

?>

Semoga bermanfaat.

Share on Google Plus

About Betacenturia

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.