Sabtu, 02 Juli 2011

MySQL default user and password denied

==to see the solution without reading the story, please goto solution==
==untuk melihat solusi dalam bahasa indonesia tanpa membaca stori,klik solusi==

today when I tried to install XAMPP on my computer to show my students the server-side webprogramming, no errors found and the whole installation successfully until I try to connect to phpMyAdmin.

the default user "root" with no password is rejected, and the user/pwd "root"/"root" also rejected.

the page always resulted:
"Welcome to phpMyAdmin 2.10.2
Wrong username/password. Access denied."

no matter how deep I try, including connection via mySQL command line, the default password is always rejected.

no search result give the good result on solution, and finally I trowed back to "Add and Remove Programs" to uninstall the MySQL service.
then I realize something that, I've already installed Apache and MySQL before last installation of these things.

aha!
the problem I face is not really a problem that described anywhere, perhaps you've meet some problem on your computer, just see whether you already had the MySQL service before, so you can reset the password from correct path.


for your information, when we install a service package of webservice (i.e XAMPP, or others), if you already had it, all the service will connected to last instances (including the web path, mySQL instance), although the service panel is from new installation.

in Indonesia:kalau Anda menemukan masalah setelah menginstall paket webservice (misal XAMPP atau lainnya), jika masalahnya adalah <span style=">default user dan password selalu ditolak saat mengakses MySQL, baik dari phpMyAdmin maupun dari lainnya, kemungkinan karena Anda sudah memiliki MySQL sebelumnya, silakan periksa, lakukan reset pada path sebelumnya.

=semoga bermanfaat=
~ok

Tidak ada komentar: