Set Password User root di MySQL

January 1st, 2012 Musa Amin
  1. Login ke mysql dengan user root
    mysql -u root</li>
  2. Gunakan database mysql
    mysql> use mysql;
  3. Update tabel user, isi field password dengan password_baru untuk User = root
    mysql> update user set password=PASSWORD("password_baru") where User='root';
  4. Reload hak akses/privileges
    mysql> flush privileges;
  5. Keluar dari mysql
    mysql> quit;
  6. Coba login kembali menggunakan password
    mysql -u root -p

selamat mencoba :)

sumber :
howtoforge.com

Incoming search terms:

membuat password root di mysql, mysql set password, konfigurasi password mysql, set password mysql, isi password root mysql, setting username dan password mysql pic, seting password mysql, password wifi amin, password user root, mysql username root password

Other Posts

Posted in Database, Web Development Tags: , , ,
«
»
You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply

ads ads ads ads