Package: mysql-server-5.0
Version: 5.0.18-3
Hi,
Since there's some problem with my database, I decided to re-install
mysql-server-5.0.
First, I do
aptitude purge mysql-server mysql-server-5.0
and select YES when asked to delete /var/lib/mysql or not.
Then, re-install it:
aptitude install mysql-server
but failed with this:
Setting up mysql-server-5.0 (5.0.18-3) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld...failed or took more than 6s.
Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket:
'/var/run/mysqld/mysqld.sock' exists!
In syslog:
Jan 11 18:37:10 cola mysqld_safe[2553]: 060111 18:37:10 [ERROR]
/usr/sbin/mysqld: Incorrect key file for table './mysql/user.MYI'; try
to repair it
Jan 11 18:37:10 cola mysqld_safe[2553]: 060111 18:37:10 [ERROR]
/usr/sbin/mysqld: Incorrect key file for table './mysql/user.MYI'; try
to repair it Jan 11 18:37:10 cola mysqld_safe[2553]: 060111 18:37:10
[ERROR] /usr/sbin/mysqld: Incorrect key file for table
'./mysql/user.MYI'; try to repair it Jan 11 18:37:11 cola
mysqld_safe[2553]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root
USER !
Jan 11 18:37:11 cola mysqld_safe[2553]: To do so, start the server, then
issue the following commands:
Jan 11 18:37:11 cola mysqld_safe[2553]: /usr/bin/mysqladmin -u root
password 'new-password' Jan 11 18:37:11 cola mysqld_safe[2553]:
/usr/bin/mysqladmin -u root -h cola password 'new-password'
Jan 11 18:37:11 cola mysqld_safe[2553]: See the manual for more
instructions. Jan 11 18:37:11 cola mysqld_safe[2553]:
Jan 11 18:37:11 cola mysqld_safe[2553]: Please report any problems with
the /usr/bin/mysqlbug script! Jan 11 18:37:11 cola mysqld_safe[2553]:
Jan 11 18:37:11 cola mysqld_safe[2553]: The latest information about
MySQL is available on the web at
Jan 11 18:37:11 cola mysqld_safe[2553]: http://www.mysql.com Jan 11
18:37:11 cola mysqld_safe[2553]: Support MySQL by buying
support/licenses at https://order.mysql.com
Jan 11 18:37:11 cola mysqld_safe[2588]: 060111 18:37:11 [ERROR]
/usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should
be repaired
Jan 11 18:37:11 cola mysqld_safe[2588]: 060111 18:37:11 [ERROR]
/usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should
be repaired
Jan 11 18:37:11 cola mysqld_safe[2594]: 060111 18:37:11 [ERROR]
/usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should
be repaired
Jan 11 18:37:11 cola mysqld_safe[2594]: 060111 18:37:11 [ERROR]
/usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should
be repaired
Jan 11 18:37:12 cola mysqld_safe[2600]: 060111 18:37:12 [ERROR]
/usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should
be repaired
Jan 11 18:37:12 cola mysqld_safe[2600]: 060111 18:37:12 [ERROR]
/usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should
be repaired
Jan 11 18:37:12 cola mysqld_safe[2694]: started
Jan 11 18:37:12 cola mysqld[2697]: InnoDB: The first specified data file
./ibdata1 did not exist:
Jan 11 18:37:12 cola mysqld[2697]: InnoDB: a new database to be created!
Jan 11 18:37:12 cola mysqld[2697]: 060111 18:37:12 InnoDB: Setting file
./ibdata1 size to 10 MB
Jan 11 18:37:12 cola mysqld[2697]: InnoDB: Database physically writes
the file full: wait...
Jan 11 18:37:13 cola mysqld[2697]: 060111 18:37:13 InnoDB: Log file
./ib_logfile0 did not exist: new to be created
Jan 11 18:37:13 cola mysqld[2697]: InnoDB: Setting log file
./ib_logfile0 size to 5 MB
Jan 11 18:37:13 cola mysqld[2697]: InnoDB: Database physically writes
the file full: wait...
Jan 11 18:37:13 cola mysqld[2697]: 060111 18:37:13 InnoDB: Log file
./ib_logfile1 did not exist: new to be created
Jan 11 18:37:13 cola mysqld[2697]: InnoDB: Setting log file
./ib_logfile1 size to 5 MB
Jan 11 18:37:13 cola mysqld[2697]: InnoDB: Database physically writes
the file full: wait...
Jan 11 18:37:13 cola mysqld[2697]: InnoDB: Doublewrite buffer not found:
creating new
Jan 11 18:37:14 cola mysqld[2697]: InnoDB: Doublewrite buffer created
Jan 11 18:37:14 cola mysqld[2697]: InnoDB: Creating foreign key
constraint system tables
Jan 11 18:37:14 cola mysqld[2697]: InnoDB: Foreign key constraint system
tables created
Jan 11 18:37:14 cola mysqld[2697]: 060111 18:37:14 InnoDB: Started; log
sequence number 0 0
Jan 11 18:37:14 cola mysqld[2697]: 060111 18:37:14 [ERROR]
/usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should
be repaired
Jan 11 18:37:14 cola mysqld[2697]: 060111 18:37:14 [ERROR]
/usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should
be repaired
Jan 11 18:37:14 cola mysqld[2697]: 060111 18:37:14 [ERROR] Fatal error:
Can't open and lock privilege tables: Table './mysql/user' is marked as
crashed and should be repaired
Jan 11 18:37:14 cola mysqld_safe[2716]: ended
The architecture is i386.
--
Best Regards,
Wen-chien Jesse Sung
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
