MySql Change Password

Many a time your security scan shall fail for having

/etc/mysql/debian.cnf file in your linux instance. Typically, after a image has been made, you need to remove this file and set a special user debian-sys-maint which can be used to reset your root user login.

Step 1:

mysql -u debian-sys-maint -p%oldpassword%

(replace %oldpassword% with the password you are being given by us when you first time do SSH to your instance)

Step2:

SET PASSWORD = PASSWORD(‘%newpassword%’);

(replace %newpassword% with the new password)

Step3:

exit

Step 4:

Now you can login with this user and set password for any user including root

Mysql Debian conf file vulnerability remediation on public clouds – AWS Azure GCP Oracle04.16.2022