Rabu, 24 Juli 2013

Mengatasi Error Login phpmyadmin

Barangkali teman-teman pernah mengalami kesulitan login phpmyadmin dan menemukan pesan error seperti berikut:


Error

SQL query:  Edit
SELECT `comment`
FROM `phpmyadmin`.`pma_column_info`
WHERE db_name = 'information_schema'
AND table_name = ''
AND column_name = '(db_comment)'

MySQL said: 
#1142 - SELECT command denied to user ''@'localhost' for table 'pma_column_info'


Nah, untuk mengatasi error seperti di atas, caranya cukup mudah. Pertama carilah file config.inc.php yang ada di folder phpmyadmin. Bukalah dengan notepad atau program lain. Lalu carilah tulisan seperti berikut:

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


Nah, tinggal hapus tuh tulisan pma. Simpel kan? Oh iya, kalau belum punya file config.inc.php silakan copy kode berikut ke notepad lalu simpan dengan nama
config.inc.php di folder phpmyadmin. Oh ya, jangan lupa untuk mengganti tulisan berwarna hijau ya, biar bisa konek ke mysql. Sesuaikan dengan pengaturan di mysql kamu. Berikut kodenya:

=================================================================================

/*
 * 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]['port'] = 3606;

$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'] = '';
$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';
$cfg['Servers'][$i]['recent'] = 'pma_recent';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';

/*
 * End of servers configuration
 */

?>

Ada komentar, kritik, saran, atau request?