Linux平台上MySQL常用命令

1、启动MySQL server，使用命令
sudo service mysqld start
2、查看MySQL server的状态，使用命令
sudo service mysqld status
3、查看MySQL日志
MySQL的日志地地址 /var/log/mysqld.log
如查询 ‘temporary password’相关的信息 sudo grep ‘temporary password’ /var/log/mysqld.log
4、登录MySQL后修改密码
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘MyNewPass4!’;
5、查看存储引擎 SHOW ENGINES;
6、创建数据库 CREATE DATABASE menagerie;
7、使用数据库 USE menagerie;
8、查看当前数据库中的表 SHOW tables;
9、创建表 CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
VARCHAR is a good choice for the name, owner, and species columns because the column values vary in length.
To verify that your table was created the way you expected, use a DESCRIBE statement: DESCRIBE pet;