MYSQL基础学习

1、全球数据库排名

4、mysql数据库常用的一些操作

5、常用的一些基本命令show databasesuse mysqlshow tablesselect user,host,password from mysql.user; grant all privilege on *.* to test_1@'%'mysql -h127.0.0.1 -utest_1select user()create database jianfengcreate table user(id int,name varchar(10));grant select on db1.user to test_1@'%'flush privilegesshow master status\Gchange master to xxxshow engine innodb status\Gshow tables from information_schema like 'INNODB%'