【Mysql】-mysql创建用户、数据库、授权-sql语句
# 登录192.168.80.xxx数据库
mysql -u root -p
---------------------------------------------------------------------
# 创建用户 (创建了一个名为: bbddev 密码为: password 的用户。)
mysql> insert into mysql.user(Host,User,Password) values('localhost','bbddev',password('password'));
# 刷新权限表
mysql>flush privileges;
# 退出后登录一下
mysql>exit;
@>mysql -u bbddev -p
@>输入密码
mysql>登录成功
---------------------------------------------------------------------
mysql -u root -p
# 创建数据库 dbname
create database dbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
# 授予bbddev用户拥有该数据库的全部权限
grant all privileges on `dbname`.* to 'bbddev'@'%' identified by 'password';
# 授予bbddev用户在本地服务器对该数据库的全部权限
grant all privileges on `dbname`.* to 'bbddev'@'localhost' identified by 'password';
# 刷新权限
flush privileges;
# 显示数据库列表
show databases;
# 删除数据库
drop database dbname;