mysql - 创建用户时mysql语法错误

Question

我在实际启动mysql之前使用文本文件中的sql语句列表来引导mysql，命令如下

/usr/sbin/mysqld --user=mysql --bootstrap --verbose=0 < $tfile && echo "Successfully run $tfile"

更新root用户密码并在$tfile中创建wordpress用户的SQL语句是

USE mysql;
FLUSH PRIVILEGES;
CREATE USER "root"@"%" IDENTIFIED BY "1234567890abcdef";
GRANT ALL PRIVILEGES ON *.* TO "root"@"%" WITH GRANT OPTION;
UPDATE user SET password=PASSWORD("1234567890abcdef") WHERE user="root";
GRANT ALL PRIVILEGES ON *.* TO "root"@"localhost" WITH GRANT OPTION;
UPDATE user SET password=PASSWORD(") WHERE user="root" AND host="localhost";
CREATE DATABASE IF NOT EXISTS `wordpress` CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER "wordpress"@"%" IDENTIFIED BY "1234567890abcdef";
GRANT ALL PRIVILEGES ON *.* TO "wordpress"@"%" WITH GRANT OPTION;

但是，无论 K 如何调整，我都会回到相同的错误

ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1234567890abcdef' at line 1 [ERROR] Aborting

Answer 1

在简单模式下，MySQL 将 " 视为文字引号，但如果启用 ANSI_QUOTES，则将其用作标识符的引号符号。

检查 SQL_MODE，例如 session 值 -

SELECT @@SESSION.sql_mode;

并根据需要进行更改。更多信息 - ANSI_QUOTES 。

<小时/>

尝试在脚本之前更改此模式 -

-- SET @@SESSION.sql_mode = 'ANSI_QUOTES';
SET @@SESSION.sql_mode = '';
USE mysql;
FLUSH PRIVILEGES;
CREATE USER "root"@"%" IDENTIFIED BY "1234567890abcdef";