mysql练习题
1.查找数据库版本号
mysql> select version();
2.查找数据库列表
mysql> show tables;
3.查看所有用户和权限,找到可以从任意IP地址访问
mysql> show grants for root@localhost
mysql> select distinct concat('user: ''',user,'''@''',host,''';') as query from user;
mysql> select distinct concat('user: ''',user,'''@''',host,''';') from user;
+--------------------------------------------+
| concat('user: ''',user,'''@''',host,''';') |
+--------------------------------------------+
| user: 'root'@'127.0.0.1'; |
| user: 'root'@'::1'; |
| user: 'root'@'localhost'; |
+--------------------------------------------+
标签：练习题,+--------------------------------------------+,host,user,模块,mysql,root,selec
From： https://www.cnblogs.com/lisenMiller/p/17237763.html