Mysql创建用户和给予权限

1.创建用户

mysql> create user 'work'@'localhost' identified by 'GenshinImpactOffline2022';

2.赋予权限

mysql> GRANT ALL PRIVILEGES ON  *.* TO ‘work’@‘localhost’ IDENTIFIED BY ''GenshinImpactOffline2022’；

3.刷新权限

flush privileges;