用户允许远程登陆授权,如root
E:\mysql-5.6.43-winx64\bin>mysql -u root -p
Enter password:Aa123456
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Aa123456' WITH GRANT OPTION;
重载授权表:
mysql>FLUSH PRIVILEGES;
mysql>exit
--创建数据库
create database 数据库名称 default character set utf8 collate utf8_general_ci;
create database 数据库名称 default character set gbk collate gbk_chinese_ci;
--创建用户
create user '用户名称'@'%' identified by '用户密码';
--用户授权数据库
grant select,insert,update,delete,create on 数据库名称.* to 用户名称;
--刷新生效
flush privileges ;
--取消用户所有数据库(表)的所有权限
revoke all on *.* from 用户名;
--删除用户
delete from mysql.user where user='tester';
--删除数据库
drop database schema名称或数据库名称;