I-BEGO

Iseng ce, ane ingin memberi password mysql Xampp. Ane search di mbah google disuruh masuk ke phpmyadmin nya tapi agk sedikin binggung juga ce.
1. masuk ke http://localhost/phpmyadmin, ke menu Privileges memasukan passwordnya trz klik tombol Go.
2. merubah file config.inc.php yang isi nya

Code: Select all

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';  //Di ubah cookie/http
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['user'] = 'root';              //Di ubah username
$cfg['Servers'][$i]['password'] = '';            //Di isikan password
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;


ane coba ubah menjadi

Code: Select all

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'cookie';  //Di ubah cookie/http
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['user'] = 'vian';              //Di ubah username
$cfg['Servers'][$i]['password'] = '12345';            //Di isikan password
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;


ane dapat contoh dari http://moboskunks.blogspot.com/2010/12/ ... -pada.html
pas ane masuk ke phpmyadmin muncul permintaan memasukan username and password. Ane masukan sesuai yg di atas tp kok gk mau masuk ya. Kira2 kenapa ya apakah stepnya ada yang kurang ato salah

Di phpmyadmin, pilih Privilege.

mungkin maksudnya merubah password server mysql nya yah ?