🔐 [TUTORIAL] How to Reset MySQL Root Password (FreeBSD – Metin2 Server)

[RESOURCES HUB]

Below you will find the simplest method to reset your MySQL root password on FreeBSD.


All commands must be executed in SSH (Putty).

---

Stop MySQL Server​

/usr/local/etc/rc.d/mysql-server stop

---

Start MySQL Without Password Check​

mysqld_safe --skip-grant-tables &

This starts MySQL without checking user privileges.

---

Connect as Root​

mysql -u root

---

Reset Root Password​

Run the following commands one by one:

use mysql;

update user set password=PASSWORD("NEW_PASSWORD") where User='root';

flush privileges;

quit

⚠ Replace NEW_PASSWORD with your new password.

---

Stop MySQL Again​

/usr/local/etc/rc.d/mysql-server stop

---

Start MySQL Normally​

/usr/local/etc/rc.d/mysql-server start

---

Optional – Reboot Server​

reboot

---

Done!​

✔ Root password successfully changed
✔ MySQL running normally
✔ You can now login using the new password