Linuxo Forumi

Ukoliko ste zaboravili svoju  mysql lozinku a imate root pristup na Linux računaru, samo pratite par sledećih koraka:

1. Zaustavite MYSQL servis

# /etc/init.d/mysql stop

ili

# service mysqld stop

2. Pokrenite MYSQLl bez lozinke.

# mysqld_safe –skip-grant-tables &

a ispis bi trebao da bude:

Output:

[1] 5988

zatim pritisnite enter.

3. Konektujte se na mysql server pomoću MYSQL klijenta.

# mysql -u root

Output:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log (ili slično)


mysql>

4. Kreirajte novu MYSQL lozinku.

mysql> use mysql;

mysql> update user set password=PASSWORD(”NEW-ROOT-PASSWORD”) where User=’root’;

mysql> flush privileges;

mysql> quit

5. Restartujte MYSQL servis

# /etc/init.d/mysql restart

ili

# service mysqld restart


Info: dralnux.com