selamlar şu anlatımı googlede buldum:
################################################## ##
sırası ile komutları takip ederek root şifrenizi sıfırlayabilirsiniz.
/etc/init.d/mysql stop
mysqld_safe –skip-grant-tables &
mysql -u root
use mysql;
update user set password=PASSWORD(”yenişifreniz”) where User=’root’;
flush privileges;
quit
/etc/init.d/mysql stop
/etc/init.d/mysql start
yaptıktan sonra
mysql -u root -p
komutu ile giriş yapabilirsiniz. Şifre sorucaktır yenişifreniz olarak belirttiğim kısıma şifrenizi yazınız.
/etc/init.d/mysql olarak yazdığım kısım /etc/init.d/mysqld olarakta olabilir.
################################################## ##
bu anlatıma göre mysql root şifresini değiştirecektim ama mysql yi bozdum geri başlamıyor ne yapabilirim?
Başlatmaya çalışınca:
[root@shellciyiz ~]# service mysqld start
Starting MySQL............................................. .................................................. .....Manager of pid-file quit without updating file. [BAŞARISIZ]
[root@shellciyiz ~]#
Log dosyası:
###############################
080722 07:46:50 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
080722 7:46:50 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080722 7:46:51 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
080722 7:46:51 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
080722 7:46:51 InnoDB: Started; log sequence number 0 0
080722 7:46:51 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
080722 7:54:32 [Note] /usr/libexec/mysqld: Normal shutdown
080722 7:54:32 InnoDB: Starting shutdown...
080722 7:54:35 InnoDB: Shutdown completed; log sequence number 0 43655
080722 7:54:35 [Note] /usr/libexec/mysqld: Shutdown complete
080722 07:54:35 mysqld ended
080722 07:55:29 mysqld started
080722 7:55:29 InnoDB: Started; log sequence number 0 43655
080722 7:55:29 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
080722 21:27:15 [Note] /usr/libexec/mysqld: Normal shutdown
080722 21:27:15 InnoDB: Starting shutdown...
080722 21:27:15 InnoDB: Shutdown completed; log sequence number 0 43655
080722 21:27:15 [Note] /usr/libexec/mysqld: Shutdown complete
080722 21:27:15 mysqld ended
080722 21:28:08 mysqld started
080722 21:28:08 InnoDB: Started; log sequence number 0 43655
080722 21:28:08 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
080722 21:28:14 [Note] /usr/libexec/mysqld: Normal shutdown
080722 21:28:14 InnoDB: Starting shutdown...
080722 21:28:16 InnoDB: Shutdown completed; log sequence number 0 43655
080722 21:28:16 [Note] /usr/libexec/mysqld: Shutdown complete
080722 21:28:16 mysqld ended
080722 21:37:09 mysqld started
080722 21:37:09 InnoDB: Started; log sequence number 0 43655
080722 21:37:09 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
080725 18:33:57 [Note] /usr/libexec/mysqld: Normal shutdown
080725 18:33:57 InnoDB: Starting shutdown...
080725 18:33:59 InnoDB: Shutdown completed; log sequence number 0 43655
080725 18:33:59 [Note] /usr/libexec/mysqld: Shutdown complete
080725 18:33:59 mysqld ended
###############################
mysql'yi bozdum geri başlatamıyorum
1
●694