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

Visual Studio Code Black Screen Windows 7, 8.1 and 10

How to install VLC player on Ubuntu 22.04 LTS Jammy Jellyfish | vetechno

How to download files and folder from s3 bucket using command line