Can CLI mariadb 10.5 environment connect using 10.5 mysql cli to mariadb 5.5

You are viewing an old version of this question. View the current version here.

We have a new install of mariadb 10.5. I am trying to use the mysql cli from that server to connect to an older mariadb server running mariadb 5.5.

Are there any issues with using "mysql" cli connecting from new 10.5 server to older 5.5 server ?

...john

Answer

There shouldn't be, as demonstrated below.

$   podman pod create --name  crossversion
c442ca0aaac1ba874a3f01061177222ea792687ca9b539915698f984cac95f2e

$ podman run --env MYSQL_ROOT_PASSWORD=bob --pod crossversion --name m55  -d  mariadb:5.5 
4fc2c331fe22224feee9c11625f71d22abd3f508c9b3019bfcd245a6bb09264c

$ podman run  --pod crossversion --name m105 -ti --rm mariadb:10.5  mysql --host localhost --port 3306 --protocol tcp --user root --password=bob
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1
Server version: 5.5.64-MariaDB-1~trusty mariadb.org binary 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.

MariaDB [(none)]> \s
--------------
mysql  Ver 15.1 Distrib 10.5.16-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Connection id:		1
Current database:	
Current user:		root@127.0.0.1
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server:			MariaDB
Server version:		5.5.64-MariaDB-1~trusty mariadb.org binary distribution
Protocol version:	10
Connection:		localhost via TCP/IP
Server characterset:	latin1
Db     characterset:	latin1
Client characterset:	latin1
Conn.  characterset:	latin1
TCP port:		3306
Uptime:			47 sec

Threads: 1  Questions: 4  Slow queries: 0  Opens: 0  Flush tables: 2  Open tables: 26  Queries per second avg: 0.085

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.