MySQL

安装

命令

操作	命令
命令行登录	mysql -u user -p;
用户管理	user mysql;
查询用户	select host, user from user;
创建用户	create user userName IDENTIFIED by 'password';
修改用户名	rename user oldName to newName;
删除用户	drop user userName;
修改密码	set password for userName = password('password');
查看用户权限	show grants for userName;
赋予权限	grant select on db_name.* to userName;
赋予多种权限	grant select, update, delete, insert on db_name.* to userName;
flush privaileges	flush privileges;
赋予权限匹配机器	grant select on db_name.* to userName@'%';
赋予表结构权限	grant create, alter, drop on db_name.* to userName@'%';
外键权限	grant references on db_name.* to userName@'%';
临时表权限	grant create temporary tables on db_name to userName@'%';
索引权限	grant index on db_name.* to userName@'%';
创建视图权限	grant create view on db_name.* to userName@'%';
查看视图权限	grant show view on db_name.* to userName@'%';
普通dba权限	grant all privileges on db_name.* to userName@'localhost';
高级dba权限	grant all privileges on . to userName@'localhost';
权限作用列	grant select(id,name) on db_name.table_name to userName@'localhost';
回收权限	revoke select on db_name.* from userName;
创建数据库	create database db_name; `CREATE {DATABASE	SCHEMA} [IF NOT EXISTS] db_name [create_specification] ... `

外网无法访问

100038

错误原因, 外网地址无法访问, 修改配置文件\/etc\/mysql\/my.cnf, 这里将 bind-address注释掉就可以了

参考

1. MySQL 官网 http:\/\/www.mysql.com\/
2. MySQL 文档 http:\/\/dev.mysql.com\/doc\/