PhD Social Science News : IN DATABASE and THEIR KIND … . HOW TO RESET LOST ROOT PASSWORD OF MARIADB OR MYSQL … .

Last Updated on July 21, 2026 by skraito with Lord Jesus Christ

To recover or reset your MariaDB root password, you must stop the database service, restart it without authentication checks, and apply a new password.

Before proceeding, try running sudo mysql -u root. In newer MariaDB versions, local root access often defaults to the unix_socket plugin, which allows you to log in automatically without a password if you use sudo.

If you still need to reset it, follow these step-by-step terminal instructions.

1. Stop the Database Service

Turn off the running MariaDB process to prevent resource conflicts.

• Ubuntu / Debian:bashsudo systemctl stop mariadb Use code with caution.
• CentOS / RHEL / Fedora:bashsudo systemctl stop mysqld Use code with caution.

2. Start MariaDB in Safe Mode

Launch the database by bypassing the privileges table (--skip-grant-tables) and disabling external network connections (--skip-networking) for security.

bash

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

Use code with caution.

Note: The & symbol forces the command to run in the background, freeing up your terminal window.

3. Log In Without a Password

Connect to the server using the database client wrapper.

bash

mariadb -u root

Use code with caution.

(On older setups, you can use mysql -u root instead).

4. Apply the New Password

Once you see the MariaDB [(none)]> prompt, reload the permissions framework and declare your new credentials.

sql

-- Reload grant tables to make user alterations possible
FLUSH PRIVILEGES;

-- Update the password for the root user
ALTER USER 'root'@'localhost' IDENTIFIED BY 'YourNewStrongPassword';

-- Save and exit
FLUSH PRIVILEGES;
EXIT;

Use code with caution.

Replace YourNewStrongPassword with your chosen security key.

5. Restore Normal Operations

Kill the active background safe-mode process and bring the standard service back online.

bash

# Stop the safe mode instance
sudo kill $(pgrep mysqld_safe)

# Restart the standard service
sudo systemctl start mariadb

Use code with caution.

6. Verify the Changes

Test your updated login configuration to verify successful restoration.

bash

mariadb -u root -p

Use code with caution.

Type your newly designated password when requested.