我正在try 自动执行MySQL用户创建过程. 我想创建一个包含MySQL用户创建语句的临时文件, 那我会这样称呼它:
mysql-u root-root<;temp
但我一直在使用mysql语法:
DROP DATABASE IF EXISTS mytestdatabase;
CREATE DATABASE mytestdatabase;
SELECT @password:="my password";
DELETE FROM mysql.user WHERE Host='localhost' AND User='mytestdatabase';
GRANT ALL PRIVILEGES ON mytestdatabase.* TO 'mytestdatabase'@'localhost' IDENTIFIED BY PASSWORD '@password';
FLUSH PRIVILEGES;
但是这条线
GRANT ALL PRIVILEGES ON mytestdatabase.* TO 'mytestdatabase'@'localhost' IDENTIFIED BY PASSWORD '@password';
(密码散列应为41位十六进制数字)
并不像我预期的那样被解读.
我怎么才能让这件事行得通呢?