At first run this command:
sudo mysqland then you should check which authentication method of your MySQL user accounts use.So run this command
SELECT user,authentication_string,plugin,host FROM mysql.user;now you can see something like this already :
+------------------+-------------------------------------------+-----------------------+-----------+ | user | authentication_string | plugin | host | +------------------+-------------------------------------------+-----------------------+-----------+ | root | | auth_socket | localhost | | mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | | debian-sys-maint | *CC744277A401A7D25BE1CA89AFF17BF607F876FF | mysql_native_password | localhost | +------------------+-------------------------------------------+-----------------------+-----------+in the table that is in the above , you can see that all of your mysql users accounts status & if you have set a password for root account before you see mysql_native_password in plugin column instead auth_socket. All in all for change your root password you should run :
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';Be sure to change password to a strong password of your choosing. Then for reload your server to put your new changes into effect run this;
FLUSH PRIVILEGES;So again check the authentication methods which has employed by your mysql , by this command:
SELECT user,authentication_string,plugin,host FROM mysql.user;and now the output is :
as you can see in the grant table your root account has mysql_native_password . now you can exit MYSQL shell
exit;That's it.just you should restart mysql by sudo service mysql restart. Now you can login to mysql as a root account with your password easily.
Terkadang ketika menginstal mysql dan phpmyadmin, kita sering lupa password yang baru saja diinput, atau bahkan kita tidak diminta memasukan password root kita sehingga default password akun root nya kosong (password kosong hanya bisa digunakan di
server lokal semacam localhost, tetapi tidak bisa digunakan untuk server online), lalu bagaimana cara reset password root mysql phpmyadmin? Sebelumnya Anda harus ada aplikasi putty untuk meremote langsung ke server yang akan dituju. Jika tidak bisa login //xxx/phpmyadmin dengan password kosong(default installnya), ikuti langkah langkah berikut ini: Demikian artikel yang kami bahas tentang cara reset password root mysql phpmyadmin kali ini, semoga bermanfaat. Jika ada kesulitan silahkan tanyakan
di komentar. Terimakasih:) Baca juga: Cara Membuat Private Nameserver dengan BIND di Ubuntu/Debian
Resetting or Changing PHPMyAdmin Password On Linux. Sometimes you might have the problem of resetting your phpmyadmin password. Everytime it makes you to feel big to work. And some tutorials are not nice to read and follow. because they may suggested the final step mainly. Let me elaborate you in detail.
Just goto your Terminal. Just do the following steps.
Stop the MySQL server to get `mysqld` access to change your admin password.
sudo service mysql stopStart mysqld to access the mysql table directly without mysql Server.
Login to MySQL as root without providing password. So, if you forget the Root password, you can reset with it.
mysql -u root mysqlChange KVCODES with your new root password
UPDATE user SET Password=PASSWORD('KVCODES') WHERE User='root'; FLUSH PRIVILEGES; exit; // Change your password instead of KVCODESSometimes it wont work, so lets try two more options.
The first alternative option would be the below command.
UPDATE user SET authentication_string=PASSWORD('KVCODES') WHERE User='root'; FLUSH PRIVILEGES; exit; // Change your password instead of KVCODESAnd the second alternative method would be like this
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'KVCODES';Kill mysqld after changing the password
sudo pkill mysqldStart mysql and phpmyadmin
sudo service mysql startLogin to phpmyadmin as root with your new password.