MySQL常用操作
1.创建数据库
mysql> create database testbase;
2.删除数据库
mysql> drop database testbase;
3.查询用户信息
mysql> select user,host from mysql.user;
删除用户
mysql> drop user 用户名@'%'; mysql> drop user 用户名@localhost;
用户授权
mysql> grant all privileges on DBname.* to 'user'@'host' Identified by 'passwd';