Erzwingen des Protokolls auf TCP aufgrund der Optionsspezifikation

Betriebssystem

Linux

Software

9.1 and higher

Fehler Meldung

[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.

Ursache

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.

Lösung

Change the Host from localhost to 127.0.0.1.


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