mysql shell client can't connect to maxscale

[Piet Schee]

i just moved from haproxy to maxscale 1.0.5 in front of a 3 node mariadb 10.0.17 galera cluster on Ubuntu 14.04.

now it seems the mysql shell client is broken, when connecting to maxscale:

mysql -uroot -ppassword -h mysql.local.net mydatabase -e "show tables;"
ERROR 1045 (28000): Access denied for user 'root'@'192.168.10.31' (using password: YES) to database 'mydatabase'

when i connect to one of the mariadb servers directly it works:

mysql -uroot -ppassword -h mysql1.local.net mydatabase -e "show tables;"
+--------------------------+
| Tables_in_mydatabase     |
+--------------------------+
| table1                   |
| table2                   |
+--------------------------+


In skygw_msg1.log i also found some entries like:

"2015-03-16 15:09:01 Galera Service: login attempt for user testuser, user not found."

whats the problem here?




My MaxScale.cnf looks like this:

# maxscale.cnf for galera cluster

[maxscale]
threads=4

[Galera Service]
type=service
router=readconnroute
router_options=synced
servers=mysql1, mysql2, mysql3
user=maxscale
passwd=maxscale

[Galera Listener]
type=listener
service=Galera Service
protocol=MySQLClient
address=192.168.10.250
port=3306

[mysql1]
type=server
address=192.168.10.31
port=3306
protocol=MySQLBackend

[mysql2]
type=server
address=192.168.10.32
port=3306
protocol=MySQLBackend

[mysql3]
type=server
address=192.168.10.33
port=3306
protocol=MySQLBackend

[Galera Monitor]
type=monitor
module=galeramon
servers=mysql1, mysql2, mysql3
user=maxscale
passwd=maxscale
monitor_interval=10000

[CLI]
type=service
router=cli

[CLI Listener]
type=listener
service=CLI
protocol=maxscaled
address=localhost
port=6603

[Mahnaz Talebi]

I think that you must add port number (-P4006) to mysql command

[Rene Bormann]

There is also an enable root option

enable_root_user=1

https://mariadb.com/kb/en/mariadb-enterprise/maxscale/maxscale-configuration-usage-scenarios/