如何在MySQL/MariaDB中创建一个与root具有相同特权的用户?
如何在MySQL/MariaDB中创建一个与root具有相同特权的用户?
% mysql --user=root mysql
CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' WITH GRANT OPTION;
CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' WITH GRANT OPTION;
CREATE USER 'admin'@'localhost';
GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
CREATE USER 'dummy'@'localhost';
FLUSH PRIVILEGES;
%
似乎不包括 localhost
,对吗? - Pacerier$ mysql -u root -p
,然后输入 root 密码才能启动 MySQL 命令行。 - user3405291