mariadb
Ceci est une ancienne révision du document !
Table des matières
MariaDB
Commande
~# apt-get install mariadb-server mariadb-client
La version installée est la 1:10.11.3-1.
Contrôle
Lancement du client
root@mysql:~# dpkg -l | grep mariadb ii libdbd-mariadb-perl 1.22-1+b1 amd64 Perl5 database interface to the MariaDB/MySQL databases ii libmariadb3:amd64 1:10.11.3-1 amd64 MariaDB database client library ii mariadb-client 1:10.11.3-1 amd64 MariaDB database client binaries ii mariadb-client-core 1:10.11.3-1 amd64 MariaDB database core client binaries ii mariadb-common 1:10.11.3-1 all MariaDB common configuration files ii mariadb-plugin-provider-bzip2 1:10.11.3-1 amd64 BZip2 compression support in the server and storage engines ii mariadb-plugin-provider-lz4 1:10.11.3-1 amd64 LZ4 compression support in the server and storage engines ii mariadb-plugin-provider-lzma 1:10.11.3-1 amd64 LZMA compression support in the server and storage engines ii mariadb-plugin-provider-lzo 1:10.11.3-1 amd64 LZO compression support in the server and storage engines ii mariadb-plugin-provider-snappy 1:10.11.3-1 amd64 Snappy compression support in the server and storage engines ii mariadb-server 1:10.11.3-1 amd64 MariaDB database server binaries ii mariadb-server-core 1:10.11.3-1 amd64 MariaDB database core server files root@mysql:~# mariadb Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 31 Server version: 10.11.3-MariaDB-1 Debian 12 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)]>
...
~# mysql -u root -pazerty mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 47 Server version: 5.5.44-0+deb8u1 (Debian) Copyright (c) 2000, 2015, 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 host,user from user; +-----------------+------------------+ | host | user | +-----------------+------------------+ | 127.0.0.1 | root | | ::1 | root | | localhost | debian-sys-maint | | localhost | root | +-----------------+------------------+ 4 rows in set (0.00 sec) mysql> quit Bye ~#
Noter l'absence de blanc entre -p et le mot de passe.
“mysql” est le nom de la base de données interne à mySQL.
mariadb.1688469300.txt.gz · Dernière modification : 2023/07/04 11:15 de pascal