mysql授权 Navicat快捷键

//创建用户
create user 'tiansong'@'%'  identified by 'test123';


//赋予权限
GRANT privileges ON databasename.tablename TO 'username'@'host'
grant all on test_tiansong.* to 'tiansong'@'%';  // all  或 select，insert，update，delete
//撤销权限：
revoke all on test_tiansong.* from 'tiansong'@'%';


//修改密码:
SET PASSWORD FOR 'pig'@'%' = PASSWORD("123456");
set password for 'tiansong'@'%'=paswword("test123");

set password for 'tiansong'@'%'=password("test123");

或

use mysql;

update user  set password for 'tiansong'@'%'=password("test123");

// 修改host
/*   远程登录mysql失败， 权限问题
update user set host = '%' where user = 'root';


GRANT ALL PRIVILEGES ON *.* TO 'root'@'*' IDENTIFIED BY 'test1234' WITH GRANT OPTION;


FLUSH   PRIVILEGES;
*/
//查看有哪些权限：
show grants for 'tiansong'@'%';


//删除用户
drop user 'tiansong'@'%'





//Navicat 快捷键：
 1.ctrl+q           打开查询窗口
2.ctrl+/            注释sql语句
3.ctrl+shift +/  解除注释
4.ctrl+r           运行查询窗口的sql语句
5.ctrl+shift+r   只运行选中的sql语句
6.F6               打开一个mysql命令行窗口
7.ctrl+l            删除一行
8.ctrl+n           打开一个新的查询窗口
9.ctrl+w          关闭一个查询窗口