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

Post a Comment

Popular posts from this blog

Visual Studio Code Black Screen Windows 7, 8.1 and 10

Image
Enable Ginger Cannot connect to Ginger Check your internet connection or reload the browser Disable in this text field Edit Edit in Ginger Edit in Ginger × Visual Studio Code Black Screen Windows 10 Due to compatibility issue of Visual Studio Code with Windows Operating system this type of errors generally comes. In this guide we will fix Visual Studio Code Black Screen on Windows 7, 8.1 and 10. Please follow the below steps: Also Read:-  How to Download and install Windows 11 on Virtual Box | VMware | Laptop How to Fix Visual Studio Code Black Screen Step1. Right-click on VS Code Shortcut ---> go to properties ---> add     --disable-gpu to Target: (Shown in screenshot below)      "C:\Program Files\Microsoft VS Code\Code.exe" --disable-gpu   Put same as shown in the above screenshot. Step2 . Now go to compatibility tab and in compatibility mode, tick the box "Run this program in compatibility mode for ". 1. For windows 7 :- Selec...
Read more

How to Register and Enable Red Hat Subscription, Repositories and Updates for RHEL 8.4 Server

Image
How to Register and Enable Red Hat Subscription, Repositories and Updates for RHEL 8.4 Server Hey guys, In this tutorial post, After installation of  Red Hat Linux 8.x , we will need to subscribe to the system with  Red Hat Subscription Management (RHSM)  to get updates, support, bug fixes, etc. A subscription service has the function to recognize registered systems with the products installed on them. Without a subscription, you are not allowed to get an update, supports, and install repositories. If you want to update or install a package that is not associated with  DNF or YUM   command. You may get the bellow messages. "This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.  Error: There are no enabled repositories in "/etc/yum.repos.d", "/etc/yum/repos.d", "/etc/distro.repos.d"."  Local Subscription Manager service tracks down the installed software products or packages, available and...
Read more

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

Image
How to download files and folder from s3 bucket using command line It is very easy to download files and folder from s3 bucket using command line in windows, mac and Ubuntu. AWS Command Line Interface (AWS CLI)  will help you to download the file and folder from AWS S3 bucket. For more details you can go to official website Install aws cli on windows Step1. Go to link and download .msi file  Step2. Run the downloaded MSI installer or the setup file. Step3. Now follow the on-screen instructions. By default, the AWS CLI version 1 installs to C:\Program Files\Amazon\AWSCLI . Step4. To confirm the installation,  open the cmd and put below command C:\Program Files\Amazon\AWSCLI> aws --version aws-cli/1.7.24 Python/2.7.9 Windows/8 Step5. We’ve only installed AWS CLI on your PC. To be able to connect to your AWS account, you’ll need one more step. Note:- To get AWS Access and Secret key, visit to AWS console. C:\Program Files\Amazon\AWSCLI> aws configure AWS Access Key...
Read more