mysql 命令行

yum install mysql mysql-server mysql-libs mysql-server


service mysqld start

chkconfig --levels 235 mysqld on
mysqladmin -u root password 'root'

mysql -h localhost -u root -proot

show databases;
use bedrock;     -- Specify database to connect to. Also refers to path: /var/lib/mysql/bedrock

show tables;
create table employee (Name char(20),Dept char(20),jobTitle char(20));
DESCRIBE employee;       -- View table just created. Same as "show columns from employee;"


service mysqld stop