1. 下载mysql client(以5.6为例):
sudo apt-get install mysql-client-core-5.6
2. 链接数据库服务器
mysql -h 192.168.100.xx -u root -p
输入密码: xxxx
(查看所有用户:select * from mysql.user;
显示所有数据库: show databases;
)
3.创建数据库
create database django;
(查看一个表的metadata: desc table;)
(使用数据库:use database_name;)
(显示状态: status;)
4.创建用户
(http://dev.mysql.com/doc/refman/5.7/en/create-user.html)
(sql wildcard:http://www.w3school.com.cn/sql/sql_wildcards.asp)
create user 'fu'@'%' identified by '1qaz@WSX';
注: identified 其实就是密码
(修改密码:set password for 'user'@'host'=password('xxx');)
5.grant权限
(查询grant:show grants for 'user'@'host';)
grant select,create,delete,insert,update on django.* to 'fu'@'%' identified by 'xxxx';
(更新权限:flush privileges;)
priv_level
: { * | *.* |db_name
.* |db_name.tbl_name
|tbl_name
|db_name
.routine_name
}
说明:
*.* 所有数据库
db_name.* db_name数据库中的所有表
de_name.table db_name中的table表
参考:https://docs.qingcloud.com/guide/rdbs.html
http://dev.mysql.com/doc/refman/5.7/en/creating-database.html