mysql8.0 创建用户并赋权

Posted by 蓝染君

2025年7月24日

On 2025年7月24日

create database

CREATE DATABASE backend_db CHARACTER SET utf8mb4;

CREATE DATABASE backend_db CHARACTER SET utf8mb4;

create user

CREATE USER 'backend_user'@'%' IDENTIFIED BY 'BackendUser';

CREATE USER 'backend_user'@'%' IDENTIFIED BY 'BackendUser';

GRANT ALL PRIVILEGES ON backend_db.* TO 'backend_user'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

GRANT ALL PRIVILEGES ON backend_db.* TO 'backend_user'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

Public Key Retrieval is not allowed解决

在链接的驱动属性中，增加allowPublicKeyRetrieval=true