1. 启动和停止:
/etc/init.d/mysqld start
/etc/init.d/mysqld stop
2. 修改默认的engine
sudo vi /etc/my.cnf
add default-storage-engine=INNODB to the last of [mysqld] , looks like:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
default-storage-engine=INNODB
3. 登陆:
mysql -u root -p