Please Wait, Loading...

Saturday 3 September 2016

Serba serbi Mengenai MySQL

  1. Show versi, daftar process, thread
    SHOW VARIABLES LIKE "%version%"; 
    SHOW FULL PROCESSLIST;
    SHOW PROCESSLIST;
    SHOW STATUS LIKE 'Thread%';
  2. Solusi ketika membuat user keluar pesan kesalahan "ERROR 1054 (42S22): Unknown column 'password_last_changed' in 'mysql.user' "
     mysql_upgrade -u root -p
    /etc/init.d/mysqld restart
    Lakukan drop user, flush privileges, kemudian lakukan pembuatan user dan tentukan grant dan flush privileges nya.
  3. Cek dan Un-Install password authentication plug-in di MySQL
    mysql> select * from information_schema.plugins where plugin_name='validate_password';
    Empty set (0.05 sec)

Posted By adminblog15:55