Mengganti Password User mysql lewat console

Login ke database mysql sebagai user root.

[root@prayoga stylekit4]# mysql -u root -p
Enter password:

tampilkan daftar database :

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| cacti              |
| mysql              |
| stylekit_wrdp1     |
+--------------------+
4 rows in set (0.00 sec)

pindah ke database mysql

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

tampilkan host, user, dan password dari table user.

mysql> select host, user, password from user;
+-----------+----------------+------------------+
| host      | user           | password         |
+-----------+----------------+------------------+
| localhost | root           | 185f9d24632e420b |
| localhost | stylekit_wrdp1 | 426809af19ae5drd |
| localhost | cactiuser      | 6616ff255193e53d |
+-----------+----------------+------------------+
3 rows in set (0.00 sec)

ganti passwordnya

mysql> set password for 'stylekit_wrdp1'@'localhost'=old_password('password_baru');
Query OK, 0 rows affected (0.00 sec)

keterangan :
stylekit_wrdp1 : adalah nama user yang akan diganti passwordnya.
password_baru : adalah password yang kita inputkan.