mysql查看用户的权限(sql查看用户拥有的权限)

SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user; 

show grants for 'nextcloud'@'%'; 

or

select * from mysql.user where user='root' \G; 

select user();

use mysql;
UPDATE user SET password=PASSWORD('新密码') WHERE user='用户';
flush privileges;

grant 权限 on 库名.表名 to '用户名'@’网段‘  identified by  "该用户的密码"；

grant all privileges on nextcloud.* to 'nextcloud'@'%' identified by 'du..olctx..entest.1';

drop user 'nextcloud'@'%';