http://www.runoob.com/mysql/mysql-install.html
书籍:https://pan.baidu.com/s/1fIVAXZnZH7u_DDRIyjLTRQ mysql登陆: mysql -uroot -p 输入密码 增加用户: mysql > create user 'dog''@''localhost'identified by '123'; 查看用户: mysql>select user,host from mysql.user; 删除用户: mysql> drop user 'dog'@'localhost'; 查看数据库: mysql>show databases; 创建数据库: mysql>create database students; 删除数据库: mysql>drop database students; 查看数据库表: mysql>use mysql; mysql>show tables; 增加数据库表: mysql>use students; mysql>create table pet( name varchar(20), #名字 owner varchar(20), #主人 species varchar(20), #种类 sex char(1),