Steps to Recover MySQL Root Password

vladi160 — Sun, 25 Jun 2023 11:37:54 +0000

Introduction

It's not uncommon to lose or forget the MySQL root password, especially if you haven't accessed your server in a while. The following guide provides a step-by-step process for recovering the MySQL root password on an Ubuntu system. We'll also cover some common issues you might encounter during the process and how to address them.

Stop the MySQL service

The first step is to stop the currently running MySQL service. You can do this by running the following command in the terminal:

sudo systemctl stop mysql

Start MySQL

Next, you'll need to start the MySQL server without a password. The --skip-grant-tables option allows us to connect to MySQL without a password and with all privileges.

sudo mysqld_safe --skip-grant-tables &

Note: If you face the issue of "Directory '/var/run/mysqld' for UNIX socket file don't exist", you can resolve it by creating the directory:

sudo mkdir /var/run/mysqld
sudo chown mysql:mysql /var/run/mysqld

Log in to MySQL without a password

Now, you should be able to connect to MySQL as the root user without a password:

mysql -u root

Change the root password

After successfully logging into MySQL, use the following SQL command to change the root password:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'New-Password';

Replace 'New-Password' with your new root password. Then exit the MySQL shell by typing exit.

Stop the MySQL service

Now, stop the MySQL service which is running without password verification:

sudo mysqladmin -u root -p -S /var/run/mysqld/mysqld.sock shutdown

When prompted, enter the new MySQL root password that you set earlier.

Start the MySQL service

Finally, start the MySQL service as usual:

sudo systemctl start mysql

Moving an EC2 instance from one AWS account to another.

vladi160 — Sun, 07 May 2023 17:04:19 +0000

Moving an EC2 instance from one AWS account to another can be done by following these steps. Please note that you will need access to both the source and destination AWS accounts to complete this process.

Create an Amazon Machine Image (AMI) of the EC2 instance:

a. In the source AWS account, go to the EC2 Management Console.
b. Select the instance you want to move.
c. Click on 'Actions', then select 'Create Image'.
d. Provide a unique name and description for the image and click 'Create Image'.
e. Wait for the AMI creation process to complete.

Share the AMI with the destination AWS account:

a. In the source AWS account, go to the 'AMIs' section of the EC2 Management Console.
b. Select the newly created AMI.
c. Click on 'Actions', then select 'Modify Image Permissions'.
d. Enter the destination AWS account ID and click 'Add Permission'.
e. Save the changes.

Launch a new EC2 instance in the destination AWS account:

a. In the destination AWS account, go to the EC2 Management Console.
b. Click on 'Launch Instance'.
c. Select 'My AMIs' from the left-hand menu.
d. Choose the shared AMI from the source account and click 'Select'.
e. Follow the standard process to configure and launch the new EC2 instance.

a. After verifying that the new EC2 instance is working correctly, terminate the old instance in the source account to avoid incurring unnecessary charges.

DEV Community: vladi160

Steps to Recover MySQL Root Password

Introduction

Stop the MySQL service

Start MySQL

Log in to MySQL without a password

Change the root password

Stop the MySQL service

Start the MySQL service

Moving an EC2 instance from one AWS account to another.