Reset MariaDB password running on EC2 instance - AWS

Question

I have MariaDB running on an EC2 instance. How do I reset its password? The instance is of Linux 2.

Answer 1

Hey @Hannah, follow these steps:

1. Stop the MariaDB service:

sudo systemctl stop mariadb

2. Start MariaDB in safe mode:

sudo mysqld_safe --skip-grant-tables --skip-networking &

3.  Log in to the MariaDB monitor:

mysql -u root

4. Update your MariaDB root password:

UPDATE mysql.user SET Password = PASSWORD('new_password_here') WHERE User = 'root';

Output:

Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0