Forcing protocol to TCP due to option specification

Operatingsystem

Linux

Software

9.1 and higher

Error message

[Start] Backing up database "archive" to "/root/.temp/1647754003795/SpoolArea/MariaDB/archive.sql"
WARNING: Forcing protocol to TCP due to option specification. Please explicitly state intended protocol.

Cause

If hostname is not specified or hostname is localhost, then Unix sockets are used.
In other cases (hostname is given and it's not localhost) then a TCP/IP connection through the port option is used.
Note that localhost is a special value. Using 127.0.0.1 is not the same thing. The latter will connect to the mysqld server through TCP/IP.

Solution

Change the Host from localhost to 127.0.0.1.


For more information see:
mariadb.com/kb/en/mysql-command-line-client/