Accueil > Programmation > mysql - mariadb > infos mariadb

infos mariadb

Publié le 27 septembre 2023, dernière mise-à-jour le 27 septembre 2023, 0 visites, visites totales.

d’après

https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html

exemples de résultats lorsque mariadb marche

mysqladmin --user=root --password=MotDePasse version

mysqladmin  Ver 9.1 Distrib 10.11.3-MariaDB, for debian-linux-gnu on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version		10.11.3-MariaDB-1
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/run/mysqld/mysqld.sock
Uptime:			56 min 2 sec

Threads: 3  Questions: 2479  Slow queries: 0  Opens: 56  Open tables: 44  Queries per second avg: 0.737

car
/etc/mysql/my.cnf contient socket = /run/mysqld/mysqld.sock
/etc/mysql/my.cnf contient # port = 3306

identique à :

mysqladmin --user=root --password=MotDePasse --protocol=SOCKET --socket=/run/mysqld/mysqld.sock version

mysqladmin  Ver 9.1 Distrib 10.11.3-MariaDB, for debian-linux-gnu on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version		10.11.3-MariaDB-1
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/run/mysqld/mysqld.sock
Uptime:			1 hour 4 min 44 sec

Threads: 3  Questions: 3456  Slow queries: 0  Opens: 56  Open tables: 44  Queries per second avg: 0.889

ici on force le port 3306

mysqladmin --user=root --password=MotDePasse -h 127.0.0.1 --port=3306 version

mysqladmin  Ver 9.1 Distrib 10.11.3-MariaDB, for debian-linux-gnu on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version		10.11.3-MariaDB-1
Protocol version	10
Connection		127.0.0.1 via TCP/IP
TCP port		3306
Uptime:			1 hour 3 min 42 sec

Threads: 3  Questions: 3455  Slow queries: 0  Opens: 56  Open tables: 44  Queries per second avg: 0.903

mysqladmin --user=root --password=MotDePasse variables

mysqladmin: connect to server at 'debdix' failed
error: 'Can't connect to server on 'debdix' (115)'
Check that mariadbd is running and that the socket: '/run/mysqld/mysqld.sock' exists!

mysqladmin --user=root --password=MotDePasse -h $(hostname) version variables

mysqladmin: connect to server at 'debdix' failed
error: 'Can't connect to server on 'debdix' (115)'
Check that mariadbd is running and that the socket: '/run/mysqld/mysqld.sock' exists!

mysqladmin --user=root --password=MotDePasse -h $(hostname) --port=3306 version

mysqladmin: connect to server at 'debdix' failed
error: 'Can't connect to server on 'debdix' (115)'
Check that mariadbd is running and that the socket: '/run/mysqld/mysqld.sock' exists!

[bruno sanchiz]

infos mariadb

Derniers articles modifiés

Programmation

Dans la même rubrique

Mots-clés