root@lamp:~# /etc/init.d/mysql stop
* Stopping MySQL database server mysqld [ OK ] root@lamp:~# mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak root@lamp:~# mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak root@lamp:~# /etc/init.d/mysql start
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables. root@lamp:~# mysql -uroot
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) root@lamp:~# show engines
-bash: show: command not found root@lamp:~# cat /etc/mysql/conf.d/storage_engine.cnf
cat: /etc/mysql/conf.d/storage_engine.cnf: No such file or directory root@lamp:~# /etc/init.d/mysql restart
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So, I went on to do
So, I went on to do these:
root@lamp:~# /etc/init.d/mysql stop
* Stopping MySQL database server mysqld [ OK ]
root@lamp:~# mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak
root@lamp:~# mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak
root@lamp:~# /etc/init.d/mysql start
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
root@lamp:~# mysql -uroot
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
root@lamp:~# show engines
-bash: show: command not found
root@lamp:~# cat /etc/mysql/conf.d/storage_engine.cnf
cat: /etc/mysql/conf.d/storage_engine.cnf: No such file or directory
root@lamp:~# /etc/init.d/mysql restart
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
===
I still can't create tables with engine INNODB...