Bursa Bilgisayar

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


[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


Related posts

213 thoughts on “Mysql root şifresini unuttuysanız..

  1. During the rainy days, you can just stay at home comfortably by watching Dexter online for free.
    Yes, Panasonic and Skype have become partners and
    plan to release the new Panasonic Blu Players
    in 2011. You can get FM transmitters such as 50W FM TRANSMITTER, 25m – W FM TRANSMITTER,
    and 5W FM TRANSMITTER on sale with the latest features and functions which cater for your need.

  2. Instead of normal sieges of 200-400 smelly Nords, think more like
    a calm hurricane of 1500+ vikings all aiming to pull an arm or
    leg off of your body. If you have 100 points in Lockpick, then you can just walk down the other pier and pick the
    very hard lock to get inside. net accounts may have been compromised by a successful hack
    against their internal network.

  3. Installing Meyers will net you a discount in Nash’s store at the Mojave Express Store.
    Just stick with any character you make until level 15 to gain the subclasses.
    No one will get any power, but no one will ever be able to use Archimedes I.

Bir Cevap Yazın

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir

 Characters available