mysql - “GRANT ALL ON database.* TO 命令中的错误

Question

我正在尝试运行包含 command 的脚本GRANT ALL ON BIDB.* TO biouser@'localhost' IDENTIFIED by 'bio123!'; 。但不知何故我得到一个错误说biouser is not valid at this position and an identifier is expected。我附上了这个问题的图片。

标签： mysqlmysql-workbench

Answer 1

它已在 mysql 8.0 中删除，请参阅GRANT

改为使用

CREATE USER 'biouser'@'localhost' IDENTIFIED by 'bio123!';
GRANT ALL PRIVILEGES ON BIDB.* TO 'biouser'@'localhost';