Mysql root şifresini unuttuysanız..

Mysql root şifresini unuttu iseniz, aşağıdaki adımları izleyerek değiştirebilirsiniz.

1. Mysql stop edilir.

[root@fedora ~]# /etc/init.d/mysqld stop

veya

[root@fedora ~]# killall -9 mysqld

2. Şifresiz mysqld ‘yi başlatıyoruz.

[root@fedora ~]# /usr/bin/mysqld_safe –skip-grant-tables –skip-networking & mysql -uroot

3. Şifreyi resetliyoruz.

mysql> use mysql;

mysql> UPDATE user SET Password=PASSWORD(“sifre123″) WHERE User=”root”;
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2 Changed: 2 Warnings: 0

mysql> exit

4. Şifremiz sifre123 oldu. Çalışan süreçleri öldürüyoruz.

[root@fedora ~]# /etc/init.d/mysqld stop

5. Son olarak mysql başlatıyoruz.Artık yeni şifremizle giriş yapabiliriz.

[root@fedora ~]# /etc/init.d/mysqld start

seygiyle.

213 Responses to “Mysql root şifresini unuttuysanız..”

  1. 5pillars Says:

    Good article. I’m dealing with many of these issues as well..

  2. Glen Checkley Says:

    Howdy! This blog post could not be written much better! Looking through this article reminds me of my previous roommate! He constantly kept talking about this. I most certainly will send this article to him. Pretty sure he will have a very good read. Thanks for sharing!

  3. check out the post right here Says:

    I simply want to say I am beginner to blogging and honestly savored you’re page. Almost certainly I’m want to bookmark your website . You actually come with impressive posts. Many thanks for revealing your web site.

Leave a Reply


Warning: Undefined variable $user_ID in /home/bursa/public_html/wp-content/themes/silveray/comments.php on line 147

 Characters available