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          关闭一个查询窗口