mysql8.x创建用户以及授权

#Java后端直接在xml文件中使用update执行语句

1: CREATE USER ‘henry’@’%’ IDENTIFIED by ‘123456’;

2: grant all privileges on test_db_1.* to ‘henry’@’%’ with grant option;

3: alter user ‘henry’@’%’ identified with mysql_native_password by ‘123456’;