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'; | +--------------------------------------------+