[maxscale]

threads=auto

...

[server3]

type=server

address=127.0.0.1

port=3308

protocol=MariaDBBackend

...

[Monitor]

type=monitor

module=mariadbmon

servers=server3

user=myuser

passwd=mypwd

monitor_interval=100

...

[RW-Service]

type=service

router=readwritesplit

servers=server3

user=myuser

passwd=mypwd

enable_root_user=1

...

[RWS-Listener]

type=listener

service=RW-Service

protocol=MariaDBClient

port=4006

address=127.0.0.1

...

MySQL [(none)]> select user, host, password from mysql.user where user like 'u1';

+------+-----------+-------------------------------------------+

| user | host      | password                                  |

+------+-----------+-------------------------------------------+

| u1   | localhost | *556BEF296211C2AF58F53DA3EDDD0A3371B6ECD5 |

| u1   | %         | *556BEF296211C2AF58F53DA3EDDD0A3371B6ECD5 |

+------+-----------+-------------------------------------------+

2 rows in set (0.001 sec)

[openxs@fc23 maria10.3]$ bin/mysql -uu1 -pu1 --host=127.0.0.1 --port=4006

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MySQL connection id is 7

Server version: 10.2.12 2.2.15-maxscale Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> select current_user();

+----------------+

| current_user() |

+----------------+

| u1@localhost   |

+----------------+

1 row in set (0.000 sec)

MySQL [(none)]> select version();

+-----------------+

| version()       |

+-----------------+

| 10.3.13-MariaDB |

+-----------------+

1 row in set (0.000 sec)

MySQL [(none)]> select @@port, @@socket;

+--------+-------------------+

| @@port | @@socket          |

+--------+-------------------+

|   3308 | /tmp/mariadb.sock |

+--------+-------------------+

1 row in set (0.000 sec)

MySQL [(none)]> exit

Bye

[openxs@fc23 maria10.3]$ ../8.0/bin/mysql -uu1 -pu1 --host=127.0.0.1 --port=4006

mysql: [Warning] Using a password on the command line interface can be insecure.

ERROR 1045 (28000): Access denied for user 'u1'@'127.0.0.1' (using password: NO)

[openxs@fc23 maria10.3]$ ../8.0/bin/mysql -uu1 -pu1 --host=127.0.0.1 --port=3308

mysql: [Warning] Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 30

Server version: 5.5.5-10.3.13-MariaDB Source distribution

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select current_user();

+----------------+

| current_user() |

+----------------+

| u1@localhost   |

+----------------+

1 row in set (0.00 sec)

mysql> \s

--------------

../8.0/bin/mysql  Ver 8.0.15 for Linux on x86_64 (Source distribution)

Connection id:          30

Current database:

Current user:           u1@localhost

SSL:                    Not in use

Current pager:          stdout

Using outfile:          ''

Using delimiter:        ;

Server version:         5.5.5-10.3.13-MariaDB Source distribution

Protocol version:       10

Connection:             127.0.0.1 via TCP/IP

Server characterset:    latin1

Db     characterset:    latin1

Client characterset:    latin1

Conn.  characterset:    latin1

TCP port:               3308

Uptime:                 36 min 54 sec

Threads: 8  Questions: 17017  Slow queries: 0  Opens: 22  Flush tables: 1  Open tables: 16  Queries per second avg: 7.686

--------------