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, 

                References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, 

                Execute_priv, Repl_slave_priv, Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv, 

                Alter_routine_priv, Create_user_priv, Event_priv, Trigger_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, 

                max_questions, max_updates, max_connections, max_user_connections 

FROM `USER` 

WHERE USER='sas2021';

SELECT HOST, USER, Password, Select_priv FROM `USER`;

7. Jalankan service SAS21

8. Selesai. Aplikasi SAS21 sudah dapat digunakan kembali.

=========================================================================

Reset Forgotten MySql root Password Under Windows

If you forgot root password for your MySQL database server running under Microsoft Windows, there is still a way to access your database and even reset your password using the command prompt.

Follow next steps:

1. Stop your MySQL server completely. This can be done from Wamp(if you use it), or start “services.msc” using Run window, and stop the service there.

2. Open your MS-DOS command prompt using “cmd” inside the Run window. Then go to your MySQL bin folder, such as C:\MySQL\bin. Path is different if you use Wamp.

3. Execute the following command in the command prompt:

  mysqld.exe -u root --skip-grant-tables

4. Leave the current MS-DOS command prompt as it is, and open a new MS-DOS command prompt window.

5. Go to your MySQL bin folder again.

6. Enter “mysql” and press enter.

7. You should now have the MySQL command prompt working. Type “use mysql;” so that we switch to the “mysql” database.

8. Execute the following command to update the password:

UPDATE user SET Password = PASSWORD('your_new_passowrd') WHERE User = 'root';

However, you can now run almost any SQL command that you wish.

After you are finished close the first command prompt, and type “exit;” in the second command prompt.

 You can now start the MySQL service. That’s it.