【mysql数据库权限授权，INSERT command denied to user ‘xxl_job‘@‘192.165.22.100‘ for table ‘xxl_job_registry‘】

一、xxljob后台注册报错

INSERT command denied to user ‘xxl_job’@‘192.165.22.100’ for table ‘xxl_job_registry’

二、解决：因为用户xxl_job没权限

1、首先查看权限

-- 首先查看权限
SELECT * FROM mysql.user;

没有的话，就要给他授权：

INSERT INTO `mysql`.`user`(`Host`, `User`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Create_user_priv`, `Event_priv`, `Trigger_priv`, `Create_tablespace_priv`, `ssl_type`, `ssl_cipher`, `x509_issuer`, `x509_subject`, `max_questions`, `max_updates`, `max_connections`, `max_user_connections`, `plugin`, `authentication_string`, `password_expired`, `password_last_changed`, `password_lifetime`, `account_locked`) VALUES ('192.165.22.100', 'xxl_job', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0, 'mysql_native_password', '*9B23B3756B375082022DB360326101B189872F22', 'N', '2023-06-26 17:45:29', NULL, 'N');

2、给用户添加权限

-- 给用户添加插入的权限
GRANT INSERT ON xxl_job.xxl_job_registry TO 'xxl_job'@'192.165.22.100'; 
FLUSH PRIVILEGES;

3、展示该用户当前的权限设置

SHOW GRANTS FOR 'xxl_job'@'192.165.22.100';

4、修改当前用户的权限设置

REVOKE ALL PRIVILEGES ON xxl_job.xxl_job_registry FROM 'xxl_job'@'192.165.22.100';
GRANT INSERT ON xxl_job.xxl_job_registry TO 'xxl_job'@'192.165.22.100';
FLUSH PRIVILEGES;

5、对指定用户指定数据库授权全部权限

GRANT ALL ON xxl_job TO 'xxl_job'@'192.165.22.100'; 
FLUSH PRIVILEGES;

执行结束完成后，就很不会在连续报错了！！！！