MySQL查询不是从bash执行,而是从MySQL客户端运行
使用UBUNTU 16。 MySQL查询从bash中失败,但从MySQL客户端运行: query=$(cat << EOF CREATE DATABASE \`${mysql_local_database}\` /*!40100 COLLATE \'utf8_hungarian_ci\' */; use \`${mysql_local_database}\`; GRANT SELECT, EXECUTE, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, INDEX, INSERT, REFERENCES, UPDATE, LOCK TABLES ON \`${mysql_local_database}\`.* TO 'myuser'@'%'; FLUSH PRIVILEGES; EOF ) echo $query mysql -u ${mysql_local_user} -p${mysql_local_pass} -h localhost […]