Skip to main content

How to reset MySQL root password in Ubuntu in latest Ubuntu versions 18.04 and above




I have forget my MySQL root password and not able to login in phpMyAdmin. I am very bad in MySQL commandline. After long struggle while Googling, I found this solution in Stackoverflow -

But this will work only latest Ubuntu version because of enhance security of MySQL.

 First, as root, stop the mysql server. 


systemctl stop mysql

Next, create a /var/run/mysqld directory to be used by MySQL process to store and access socket file: 

mkdir -p /var/run/mysqld

chown mysql:mysql /var/run/mysqld

Check that the newly created directory do exist. Now manually start MySQL with the following linux command and options: 

/usr/sbin/mysqld --skip-grant-tables --skip-networking &

Confirm that the process is running as expected: 

jobs

[1]+ Running sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking;

 Leave that terminal running and open another terminal, not as root.

Now access MySQL database without password: 


mysql -u root -p
mysql>

Using the MySQL session first flush privileges: 

FLUSH PRIVILEGES;

Next, reset root password. The following commands will reset MySQL root password: 

mysql> USE mysql;
mysql> UPDATE user SET authentication_string=PASSWORD("LKYbak0r") WHERE User='root';
mysql> UPDATE user SET plugin="mysql_native_password" WHERE User='root';

Quit MySQL session: 

mysql> exit

Now switch to the root terminal and terminate current mysqld process: 

pkill mysqld

jobs

[1]+ Done sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking //

 Lastly, start MYSQL database: 


systemctl start mysql

You should now able to connect to mysql as root. 

mysql -u root -p

Source: Stackoverflow

Popular posts from this blog

WordPress Site is not loading properly behind Google Cloud/AWS Load Balancer

Hello Guys, Today we are going to understand how can we fix a WordPress loading issue (CSS and JS loading issue) behind the Google Cloud Load Balancer or AWS Load Balancer. Generally, When we host a WordPress site directly with Google Cloud Compute Engine VM instance or AWS EC2 instance. It's loading perfectly fine. But once we added this WordPress server behind any Load Balancer either from GCP Load Balancer or AWS Load Balancer, you site will completely broken, means the CSS and JS of your site not loaded properly. The reason for this is - When you put a load balancer in front of WordPress, you need to modify wp-config.php to process the HTTP header HTTP_X_FORWARDED_PROTO to detect the protocol that the user is using and not the protocol the load balancer is using to connect to your backend. To fix this issue, we have to make following changes in the  wp-config.php  file and add the below code snippet on the top of  wp-config.php file - Google Cloud Platform Load Bal...

How to Setup Kubernetes Cluster in Google Cloud Virtual Machine using "kubeadm"? | Ubuntu 20.04/22.04 LTS

  Hello Friends, In this post, we are going to setup Kubernetes Cluster on Virtual Machine in Google Cloud Platform using kubeadm tool. Hope this post will help you in Kubernetes learning Hand-On Labs (HOL). Requirements: Master Node: No. of VMs 1 Specifications - 2 vCPUs, 4GB RAM, 20 GB HDD (Balanced PD or SSD PD), Operating System (OS) Ubuntu 20.04 LTS x86/64, amd64  Firewall Rule - Ingress Allow 6443 (API Server) | 2379 (ETCD) | 10251 (Scheduler) | 10252 (Controller Manager) 10250 (Kubelet), sudo access with admin access  Worker Node: No. of VMs 2 Specifications - 2 vCPUs, 4GB RAM, 20 GB HDD (Balanced PD or SSD PD), Operating System (OS) Ubuntu 20.04 LTS x86/64, amd64  Firewall Rule - Ingress Allow 30000-32767 (Services) | 10250 (Kubelet),  sudo access with admin access  Disable Swap and comment fstab entry: First, Disable Swap and remove or comment the Swap entries from fstab file : sudo swapoff -a sudo sed -i '/ swap / s/^\(.*\)$/#\1/g' /etc/fstab Next...

How to Convert PEM KeyFile into PPK KeyFile and vice versa?

Hi, In this post, we will learn that how can we convert PEM KeyFile into PPK KeyFile and vice versa including the installation of the tool which we will use to accomplish this. For the Windows Operating System In Windows system is easy and straight forward. You just need a tool called "puttygen.exe" from the URL -  https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html Choose the appropriate version as per your OS. Convert PEM into PPK in Windows After downloading the PuTTYgen and open it, load your file (select All Files (*.*) in the bottom dropdown to select your PEM key file).  You will get a message Successfully imported foreign key, Just click OK, Now click on Save private key button to save that key in the location where do you want to save it. Convert PPK into PEM in Windows Now we will convert PPK file into PEM using PuTTYgen in Windows PC Open the PuTTYgen tool, now load your PPK file into it, and finally, Go to Conversions Menu and Click on Export OpenSSH k...