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.

Fixed - loading shared libraries: libpangox-1.0.so.0: Anydesk on Ubuntu 22.04 | vetechno

Visual Studio Code Black Screen Windows 7, 8.1 and 10