启动服务

• sudo service mysql status
• sudo service mysql start
• sudo service mysql stop
• sudo service mysql restart

基本指令

• mysql -u root -p
• show databases;
• create database test;
• use test;
• show tables;
• create table users(
  id int NOT NULL AUTO_INCREMENT,
  username varchar(255) NOT NULL,
  age int,
  PRIMARY KEY (id)
  ) ENGINE = innodb;
• select * from user;
• insert into test (username, age) values (‘liming’, 25);