access denied to phpMyadmin

aiyer..knape eh??tulung2..nk gune myadmin kua error cani..n for ur info saya ade set password tuk database saya nih

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

p/s:ngengs~ xgeti nk load gmbar error dlm nih(harap membantu, maaf ats kesengalan ini )

bukak http://localhost/phpmyadmin/setup kat browser then setup lah username dan password

kalau tak ingat .. root password kena change root password by command line. yang ni google sebab lupa password hehe...

punca masalah
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
dia nak access tanpa password tapi masa install mysql root tu letak password kan.....

jadi letak lah password root masa install mysql tadi.

pg kt file config ko...
jngn set password..

**ayoi

http://localhost/phpmyadmin/setup
link broken la bro


**meteora11
lanjut sikit lagi boleh?cane tuh??

awak install cara mana phpmyadmin?
install dari pakej Xampp, wamp atau install berasingan.?

install dari wammp5

anysha wrote:
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Lor... kalau dah NO, mana ada password pada database tu :p

Kosongkan ruang password tu, atau cuba guna koding yang selalu saya guna dalam localhost ni :

Code:

$open = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "Nama_Database";
mysql_connect($open, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());

Lor... kalau dah NO, mana ada password pada database tu :p

Kosongkan ruang password tu, atau cuba guna koding yang selalu saya guna dalam localhost ni :

Code:

$open = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "Nama_Database";
mysql_connect($open, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());

[/quote]



aish..tapi ble gune console nak access dB gune password saya.
actually system saya dh bole run pon dgn dB yg dibuat dlm console tuh juga connect
ke dB dgn password saya ($dbpass="passwordku");

Okay lah tu, try and error...

note : ni bakal php programmer ni... Lepas ni belajar nak hack script plak tau...

haha!programmer la sgt..lps nih xmaen sgt kot!masuk kolej maen dgn network plak.
tapi atleast taw la jgk skit2..
hack script??waahh!!mmg ditunggu2 ney..sape nk offer ajar ney??

ek!!prob kt ats nih cane??

cuba masuk url;
http://localhost/phpmyadmin/

boleh masuk ker tidak.

Lor... ingat dah solved dah...

Dah test $dbpass=""; ?? Boleh run ker tak...?

meteora11 wrote:pg kt file config ko...
jngn set password..

Guna solution ni... Lagipun, tu cuma localhost jer kan... bukan web server :p

OngBok wrote:cuba masuk url;
http://localhost/phpmyadmin/

boleh masuk ker tidak.

xbuley laa...nk upload gambar x geti plak nk tunjuk errornye

anysha wrote:

OngBok wrote:cuba masuk url;
http://localhost/phpmyadmin/

boleh masuk ker tidak.

xbuley laa...nk upload gambar x geti plak nk tunjuk errornye

Dia ni pun 1 kedekut betul

Bak lah coding nya... Cuma tunjuk Error jer, macam mana nak solved...

Meh paste kat sini codingnya... Kedekut betul lah...

Ni nak marah ni

nk tunjuk kod ape abg hanz yer??
dh nk bkk myadmin dlm wamp jer xle..
nk tunjuk ape ek?ek?

Lor... sat...

Search "config.inc.php" dalam folder phpmyadmin...

Dah jumpa, buka file tu, paste kat sini coding lebih kurang macam ni...

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

/* End of servers configuration *//

kalau tak dapat jugak bukak fail config.inc.php. Fail nie ada dalam C:\wamp\apps\phpmyadmin x.x.x

Pinda kod berikut;

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '123456x'; //masukkan password yang awak dah set
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

//bukan password database tapi password untuk user root.
// ok . cuba dulu.

hollaa!!!
berjaya!!!
mmg best la korang2 ney! cayunk la kt korg sume!!
thanks a lot guys!!