Changing and Resetting MySQL Root Password on Ubuntu 18.04 and Ubuntu 20.04




Step1. First Login to Mysql

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourPasswordHere';

where :- root is user and yourPasswordHere is password

For eg.

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'R0oT#';


That's it. Thank You.

Comments

Popular posts from this blog

Failed to establish the VPN connection. This may be caused by a mismatch in the TLS version.

To make SSL VPN connection work, please turn off IE security configuration | vetechno

How to download and install GlobalProtect VPN on Ubuntu 20.04 LTS | vetechno