关于收回root帐号的执行过程

zhgc

SYS_SFC_001_INC.mes_decode('8&wYWL;;q')
  self.MyConnection1.Port:=strtoint( SYS_SFC_001_INC.getHostPort);

zhgc

select b.* from information_schema.PROCESSLIST a,
syant.z_session b
where a.id=b.pid and a.user='ROOT'
order by b.exe

zhgc

额外补充点知识，只有拥有创建权限且有 SUPER 权限的用户才可以建 DEFINER = 其他用户的对象。例如：root 账号可以创建 DEFINER = testuser 的视图，而 testuser 在有创建视图的前提下只能创建 DEFINER 为自己的视图。

zhgc

SQL指令Grant(分配权限)和Revoke(回收权限)

zhgc

skip-grant-tables

UPDATE `user`
SET HOST = '%',
insert_priv = 'y',
update_priv = 'y',
Alter_priv = 'y',
delete_priv = 'y',
create_priv = 'y',
drop_priv = 'y',
reload_priv = 'y',
shutdown_priv = 'y',
Process_priv = 'y',
file_priv = 'y',
grant_priv = 'y',
References_priv = 'y',
index_priv = 'y',
create_user_priv = 'y',
show_db_priv = 'y',
super_priv = 'y',
create_tmp_table_priv = 'y',
Lock_tables_priv = 'y',
execute_priv = 'y',
repl_slave_priv = 'y',
repl_client_priv = 'y',
create_view_priv = 'y',
show_view_priv = 'y',
create_routine_priv = 'y',
alter_routine_priv = 'y',
create_user_priv = 'y'
WHERE
        `User` LIKE 'root'
        AND `Host` LIKE '%';