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