CentOS下的MySQL基本操作

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