Mengganti Password mysql pada xampp

1. hidupkan services mysql dan apache
2. buka http:\\localhost\phpmyadmin pada browser
3. klik menu SQL kemudian ketik sintak berikut pada text area lalu klik tombol Go : 
    UPDATE mysql.user SET Password=PASSWORD('password anda') WHERE User='root';
  FLUSH PRIVILEGES;
 
4. Jika sukses maka akan keluar pesan bahwa query sukses di eksekusi.
5. Buka file config.inc.php dengan editor kesukaan anda (biasanya terletak di c:\\xampp\phpMyAdmin\config.inc.php)
6. Edit seperti file dibawah ini : 
    $cfg['Servers'][$i]['auth_type']            = 'config';
    $cfg['Servers'][$i]['user']                 = 'root';
    $cfg['Servers'][$i]['password']             = 'password anda';
    $cfg['Servers'][$i]['AllowNoPassword']      = true;
7. Simpan file tersebut kemudian restart mysql dan apache anda.
8. Sekarang seharusnya password mysql anda sudah berubah.

Comments

  1. AnonymousNovember 15, 2011 at 3:52 PM

    Thanks.... It Works !

    ReplyDelete
  2. AnonymousJanuary 5, 2012 at 7:16 PM

    MASIH ACCESS DENIED CUY

    ReplyDelete
  3. adi rFebruary 20, 2012 at 6:01 PM

    @anonymous : setelah restart mysql sama apache service harusnya sudah bisa bro.

    ReplyDelete
  4. Syawaluddin Amin, S.KomOctober 22, 2012 at 11:54 PM

    trims

    ReplyDelete
  5. AnonymousMay 17, 2014 at 1:01 AM

    Terima kasih mas Adi, semoga Allah SWT membalas kebaikan ilmu yang anda berikan...amiin..

    ReplyDelete

Post a Comment

silahkan berkomentar, kritik dan saran yang membangun adalah harapkan kita semua !

Popular posts from this blog

Data Flow Diagram (DFD)

Image
DATA FLOW DIAGRAM Data Flow Diagram (DFD) describes the system distribution into a smaller system. DFD allows the user to easily learn about computer and understand about worked system. DFD allows to learn new system are logically develop without consider the physically environment where the data flow (like by phone, mail, etc) or physically environment where the will be save (like file card, microfiche, hard disk, tape, diskette, etc). DFD is a tool used in methodology structured Analysis and design. CONTEXT DIAGRAM Context Diagram consists of one process to describe the system environment. It’s a highest level in DFD which is describes all the input into the system and output from system. System has a boundary which is to separate the system with the external entity. In context diagram there is no storage. Because context diagram are process to describe the system environment. ZERO DIAGRAMS Zero diagrams are describes the process of DFD. It gives a opi...
Read more

VERIFIKASI SUARA MENGGUNAKAN METODE MFCC DAN DTW MENGGUNAKAN METODE MFCC DAN DTW (BAB II TINJAUAN PUSTAKA)

BAB II TINJAUAN PUSTAKA 1.1     Konsep Dasar Pengenalan Suara Diantara banyak komunikasi yang dilakukan oleh manusia, berbicara ( speech ) memberikan paling banyak informasi penting dan paling efektif dalam berkomunikasi. Informasi – informasi tersebut antara lain : gender, keadaan kesehatan, emosi, serta identitas pembicara. Pengenalan suara dapat dikategorikan menjadi 3 bagian, yaitu : speech recognition, speaker recognition, dan language recognition. Dalam tugas akhir ini hanya khusus membahas mengenai speaker recognition lebih spesifiknya lagi membahas tentang speaker verification. Speaker recognition adalah suatu proses yang bertujuan mengenali siapa yang sedang berbicara berdasarkan informasi yang terkandung dalam gelombang suara yang di- input -kan. Speaker recognition dibagi menjadi 2 bagian, yaitu : speaker verification dan speaker identification. Speaker verification adalah proses verifikasi seorang pembicara, d...
Read more

flexigrid + php with add and edit button

Image
this is a little example for flexigrid with add and edit button. Original source code of flexigrid could be found at http://flexigrid.googlecode.com/files/flexigrid-1.1.zip additional code that I have is : function test(com,grid) { if (com=='Delete') { if($('.trSelected',grid).length>0){ if(confirm('Delete ' + $('.trSelected',grid).length + ' items?')){ var items = $('.trSelected',grid); var itemlist =''; for(i=0;i<items.length;i++){ itemlist+= items[i].id.substr(3)+","; } $.ajax({ type: "POST", dataType: "json", url: "delete.php", data: "items="+itemlist, success: function(data){ alert("Query: "+data.query+" - Total affected rows: "+da...
Read more