[LINUX:16510] Re: Mysql

---------

New Message Reply About this list Date view Thread view Subject view Author view

From: Murat Koc (muratkoc@saneg.itu.edu.tr)
Date: Wed 07 Jun 2000 - 14:55:41 EEST


> mysqladmin -u root password yenipasword u de yemedi?
>
> How-To dosyalarinda my.cnf dosyasindan bahsediyor ama sistemde boyle bir dosya bulamadim?
>
> Nasil uninstall edebilirim ? Yeniden kurmak istiyorum..

Selam,
mysql in dokumanlarinda soyle bir bolum vardir.
Sanirim burada yazilanlari uygulamaniz ise yarar.
Dokumana mysql in web sayfasindan veya makinanizda kurulu oldugu yerde
html diye bir dizin vardir oradan ulasabilirsiniz.

IYI CALISMALAR

                                                             MURAT KOC

8.9 How to reset a forgotten password.

   If you have forgotten the root user password for MySQL, you can
   restore it with the following procedure.
    1. Take down the mysqld server by sending a kill (not kill -9) to the
       mysqld server. The pid is stored in a .pid file which is normally
       in the MySQL database directory:
kill `cat /mysql-data-directory/hostname.pid`
       You must be either the UNIX root user or the same user the server
       runs as to do this.
    2. Restart mysqld with the --skip-grant-tables option.
    3. Connect to the mysqld server with mysql -h hostname mysql and
       change the password with a GRANT command. See section 7.25 GRANT
       and REVOKE syntax. You can also do this with mysqladmin -h
       hostname -u user password 'new password'
    4. Load the privilege tables with: mysqladmin -h hostname
       flush-privileges or with the SQL command FLUSH PRIVILEGES.

 
 Listeden cikmak icin:
          unsub linux
 mesajini listeci@bilkent.edu.tr adresine gonderiniz.
   Lutfen Listeci icin MIME / HTML / Turkce Aksan kullanmayin.
 Listeci arayuzu: http://listweb.bilkent.edu.tr/yardim/bilkent/linux.html
 Liste arsivinin adresi: http://listweb.bilkent.edu.tr/


New Message Reply About this list Date view Thread view Subject view Author view

---------

Bu arsiv hypermail 2b29 tarafindan uretilmistir.