1、创建数据库
mysql> create database RA;
2、创建用户,授权限,允许远程访问
mysql> grant all privileges on RA.* to ra@"%" identified by 'ra@xxxxx '; # 添加一个用户ra并授所有权允许从任何其它主机连接到mysql(通配符%)
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> grant select,insert,update,delete on RA.* to ra@'%' identified by 'ra@xxxx '; #添加用户ra并授予增删改查权限,允许从任何主机连接到mysql
3、删除数据库、表和用户
mysql>drop database 数据库名;
mysql>drop table 数据表名;
mysql> drop user ra@localhost ;
Query OK, 0 rows affected (0.00 sec)