【Mysql】-mysql创建用户、数据库、授权-sql语句

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

转载于:https://my.oschina.net/devpmp/blog/824961