---
title: "MySQL Root Password Reset on Ubuntu 20.04"
description: "Bu yazıda MySQL şifrenizi nasıl sıfırlayabileceğinize değindim."
image: "https://sezer.in/wp-content/uploads/2022/04/mysql.jpg"
url: "https://sezer.in/mysql-root-password-reset-on-ubuntu-20-04/"
date: "2022-04-17T15:35:31+03:00"
updated: "2022-05-02T23:52:15+03:00"
author: "Sezer Şanlıkan"
lang: "tr"
source: "https://sezer.in/mysql-root-password-reset-on-ubuntu-20-04/"
---

# MySQL Root Password Reset on Ubuntu 20.04

MySQL root şifresini sıfırlamak için öncelikle MySQL servisini durduralım.

```
sudo systemctl stop mysql.service
```

Servisi kontrol edelim.

```
sudo systemctl status mysql.service
```

```
● mariadb.service - MariaDB 10.3.34 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
     Active: inactive (dead) since Sun 2022-04-17 12:24:38 UTC; 2s ago
       Docs: man:mysqld(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 20540 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
   Main PID: 20540 (code=exited, status=0/SUCCESS)
     Status: "MariaDB server is down"
```

MySQL başlarken tablo ve network kontrolünü devre dışı bırakıyoruz.

```
sudo systemctl set-environment MYSQLD_OPTS="--skip-networking --skip-grant-tables"
```

MySQL servisini tekrardan başlatıyoruz.

```
sudo systemctl start mysql.service
```

Servisi kontrol ediyoruz.

```
sudo systemctl status mysql.service
```

```
● mariadb.service - MariaDB 10.3.34 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
     Active: active (running) since Sun 2022-04-17 12:27:31 UTC; 2s ago
       Docs: man:mysqld(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 21825 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
    Process: 21834 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 21837 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
    Process: 21915 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 21917 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
   Main PID: 21884 (mysqld)
     Status: "Taking your SQL requests now..."
      Tasks: 31 (limit: 9441)
     Memory: 83.3M
     CGroup: /system.slice/mariadb.service
             └─21884 /usr/sbin/mysqld --skip-networking --skip-grant-tables
```

Root olarak MySQL'a bağlanıyoruz.

```
sudo mysql -u root
```

Önceki izinleri temizleyelim.

```
flush privileges;
```

```
MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.001 sec)
```

MySQL DB'sine geçiş yapalım.

```
USE mysql
```

Aşağıdaki komutta 'yeni-sifre' kısmını tırnakları silmeden içerisindeki yazıyı şifreniz ile değiştirin.

```
ALTER USER  'root'@'localhost' IDENTIFIED BY 'yeni-sifre';
```

MySQL'dan çıkış yapalım.

```
quit;
```

```
MariaDB [mysql]> quit;
Bye
```

Tüm proccessleri kill edelim.

```
sudo killall -u mysql
```

MySQL servisini restart edelim.

```
sudo systemctl restart mysql.service
```

Yeni şifremizle giriş yapmayı deneyelim.

```
sudo mysql -u root -p
```

```
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 36
Server version: 10.3.34-MariaDB-0ubuntu0.20.04.1 Ubuntu 20.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> 
```

Cheers!