mysql8.0创建用户只能访问某一个数据库

create user 'username'@'172.16.73.111' identified by 'xxxxmima';

GRANT ALL PRIVILEGES ON dbname.* TO 'username'@'172.16.73.111' WITH GRANT OPTION;