Re: [Linux] mysql sifresi

---------

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

From: Mehmet DOGAN (mehmetd@doruk.net.tr)
Date: Wed 07 Sep 2005 - 15:57:41 EEST


komutu su sekilde deneyin sadece
> mysql
seklinde bir deneyin sizden hala sifre soruyorsa yapmaniz gereken sunlardir:

To reset a root password that you forgot (using paths on our system):

Login as root to the box with the MySQL server.
Stop MySQL server.
Open the mysql server startup script. This is the file you have just executed to stop MySQL server.
Find the line that contains teh safe_mysqld command and add --skip-grant-tables as its parameter.
Start MySQL server.
Login as the mysql user and connect to the mysql user/permission database:
# su -l mysql
# mysql -u root mysql
Run the following two queries:
mysql> UPDATE user SET Password=PASSWORD('12gandalf34') WHERE User='root';
mysql> FLUSH PRIVILEGES;
replacing newrootpassword with the new root password to the box with the MySQL server.
Exit mysql database by typing \q.
Exit mysql user console by typing exit
Stop MySQL server.
Open the mysql server startup script and remove the --skip-grant-tables parameter you added above.
Start MySQL server.

bunlari yaptiktan sonra "mysql" komutu ile sifresiz girebilirsiniz

_______________________________________________
Linux mailing list
Linux@liste.linux.org.tr
http://liste.linux.org.tr/mailman/listinfo/linux


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

---------

Bu arsiv hypermail 2.1.2 tarafindan uretilmistir.