fix mysql .md

kemungkinan error karena shutdown computer yang dipaksa

untuk fixing

• backup (move/rename) file ibdata1 yang ada di folder (MYSQL install)/data
• hapus semua file (bukan folder) yang ada di folder (MYSQL install)/data
• logout and login computer
• sudo service mysql start
• sudo service mysql stop
• akan ada file ibdata1 yang baru setelah servis mysql di-start, timpa file tsb dengan ibdata1 backup
• sudo service mysql start lagi

set plugin mysql_native_password after installation

https://stackoverflow.com/a/43240922

SET PASSWORD = PASSWORD('test');
update mysql.user set plugin = 'mysql_native_password' where User='root';
FLUSH PRIVILEGES;

reset password ke password = 'root'

sudo mysql mysql
update user set password='*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B', authentication_string = '*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B';
flush privileges;

restore db from .frm

--- /etc/mysql/mariadb.conf.d/50-server.cnf

[mysqld]
  innodb_file_per_table=1
  innodb_force_recovery=1

mysql -uroot -p DATABASE < backup/DATABASE.sql 

USE INFORMATION_SCHEMA;
SELECT CONCAT("ALTER TABLE `", TABLE_SCHEMA, "`.`", TABLE_NAME, "` DISCARD TABLESPACE;") 
AS MySQLCMD FROM TABLES 
WHERE TABLE_SCHEMA = "table_tmp";

hapus heading dan border nya dari hasil diatas

cp -f ~/brokendb/*.ibd /var/lib/mysql-files/dummy/

kemungkinan karena masalah ini
https://askubuntu.com/questions/892026/shutdown-hangs-on-a-stop-job-is-running-to-for-mysql-community-server