'ERROR 1045 (28000): Access denied' if connecting to maxscale using a specific database

[thomas...@gmail.com]

My maxscale setup seems to be operating just fine as long as I do not include a default database when connecting.

For example, if I connect with the following:

mysql -h<hostname> -u<username> -p

I can connect just fine through maxscale (after putting in my password at the prompt)

However, If I add a database name like so:

mysql -h<hostname> -u<username> -p -D<database>

I get the following error:

ERROR 1045 (28000): Access denied for user '<user>'@'<myip>' (using password: YES) to database '<database>'

and in the maxscale logs I get the following:

RW Split Router: Unable to load database grant information, MaxScale authentication will proceed without including database permissions. To correct this GRANT select permission on msql.db to the user <user>.

msql.db looks like a typo for mysql.db, but just in case I added select permission to both mysql.user and mysql.db for user <user> to no avail. Also none of the users in mysql.user filter off host (all use %).

Is this a configuration issue? a bug? Is there a workaround?
Thank you for your time.

[thomas...@gmail.com]

Well, I found my answer. The user account also needs GRANT SHOW DATABASES permission. Everything looks to be working now.