Technical discuss

正确的 MySQL 8.0+ 用户创建和授权方法

27 Dec 2025 09:50 #967 by service

New Topic

-- 登录 MySQL

Code:

sudo mysql -u root -p

-- 创建用户（如果不存在）

Code:

CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'password';

-- 授予所有权限

Code:

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

-- 刷新权限

Code:

FLUSH PRIVILEGES;

-- 退出

Code:

EXIT;

Please Log in or Create an account to join the conversation.