MySql error trying to create a DB

mysql

#1

Hi there,

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 ?

Many thanks,
Victor


#2