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;
