As part of our end-to-end integration tests, we need to create several databases.
I’m using the default user
ubuntu with an empty password. In the
database post task, I’m doing:
echo "create database if not exists my_admin; grant all on my_admin.* to 'ubuntu'" | mysql -h localhost -u "ubuntu" --password=""
And get this in return:
ERROR 1133 (42000) at line 1: Can't find any matching row in the user table
What’s the issue with above code? Is it related to: http://stackoverflow.com/questions/12877458/mysql-error-1133-cant-find-any-matching-row-in-the-user-table ?