Langsung ke konten utama

Postingan

Menampilkan postingan dengan label Reset

Mengubah dan reset password server mysql (How to set change and recover a mysql root password)

Chances are, you have MySQL running somewhere in your data center. If that's the case, there might be a time when you need to set or change the root user password. This can happen when you've forgotten the password or when you're looking to up your security game (remembering you set the original MySQL password to something far too simple). As you might expect, the process is handled entirely through the command line and works with with either MySQL or MariaDB installations. The Linux distribution being used doesn't matter (as long as you have admin access, either by way of su or sudo). A word of warning:  Given the current state of attacks, across the landscape of IT, I highly recommend you using seriously  strong passwords  for your databases. Use a random password generator and then store that in a  password manager  (instead of using an easily memorized password). Be safer than safe. With that said, let's get to work. Setting the password for the first time D...

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,            ...

Recover MySQL root Password

Recover MySQL root Password https://www.cyberciti.biz/tips/recover-mysql-root-password.html   Y ou can recover MySQL database server password with following five easy steps. Step # 1: Stop the MySQL server process. Step # 2: Start the MySQL (mysqld) server/daemon process with the –skip-grant-tables option so that it will not prompt for password. Step # 3: Connect to mysql server as the root user. Step # 4: Setup new mysql root account password i.e. reset mysql password. Step # 5: Exit and restart the MySQL server. Here are commands you need to type for each step (login as the root user): Step # 1 : Stop mysql service # /etc/init.d/mysql stop Output: Stopping MySQL database server: mysqld. Step # 2: Start to MySQL server w/o password: # mysqld_safe --skip-grant-tables & Output: [1] 5988 Starting mysqld daemon with databases from /var/lib/mysql mysqld_safe[6025]: started Step # 3: Connect to mysql server using mysql client: # mysql -u root Output: Welc...