mysql创建用户并授权

1. 创建用户并授权

-- 创建数据库
CREATE DATABASE IF NOT EXISTS my_db CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
create user 'user_app'@'%' identified by '123456';
grant all on my_db.* to 'user_app'@'%';
flush privileges;