Menambahkan user baru database mysql dengan "--skip-grant-tables" (Reset Forgotten MySql root Password Under Windows)
Reset Forgotten MySql root Password Under Windows ========================================================================= Kasus membuat koneksi langsung ke database SAS 1. Stop service MySQL server yang akan ditambahkan usernya (SAS21). This can be done from Wamp(if you use it), or start “services.msc” using Run window, and stop the service there. 2. Buka cmd 3. Masuk folder bin (sesuaikan dengan kondisi database diinstall) cd "C:\DBSAS21\bin" 4. Jalankan mysqld.exe -u root --skip-grant-tables biarkan cmd tsb terbuka 5. Buka cmd lagi 6. Jalankan mysql USE mysql; INSERT INTO `USER` SELECT '%' HOST, 'akk21' USER, PASSWORD('Akk21') Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, ...