MySQL
[root@xiandian ~]#mysql -uroot -p000000
//此为登录数据库
MariaDB [(none)]> show variables like "storage_engine"；
//查看mysql的默认存储引擎信息
MariaDB [(none)]> show variables like 'have%';
//查看mysql支持的存储引擎有哪些
MariaDB [(none)]>insert into mysql.user(host.user.password) values("localhost","examuser",password("000000"));
//创建本地用户examuser，密码为000000，然后查询mysql数据库中的user表的host，user，password字段
MariaDB [(none)]>use mysql;
//进入mysql数据库
MariaDB [mysql]>select host.user.password from user;
//查询host，user，password字段
MariaDB [mysql]>grant select,delete,update,create on *.* to examuser@"localhost" identfied by "000000";
//给予用户访问数据库的查询，删除，更新，创建的本地权限
