SQL databases#
- SQL#
(Structured Query Language) Langage informatique permettant de chercher des informations dans une base de données relationnelle. — Wikipedia, Doc MariaDB
A MariaDB instance, common to all members, is present on the CLUB1 server. Access is optional and can be added when creating the member account or later on request.
Personal databases#
You can create as many personal SQL databases as you want. These should have a name starting with your username followed by _. For example if lisa wants to create a database flarum, she will have to name it lisa_flarum.
There is currently no limit to the number of personal databases, nor to the amount of data they can contain.
Web interface#
A Web management interface provided by phpMyAdmin is available at the following address: https://phpmyadmin.club1.fr
Command line interface#
Il est possible de se connecter au serveur SQL directement depuis la ligne de commande. Pour cela, il faut tout d’abord se connecter au serveur en SSH. Ensuite, la commande pour démarrer un shell SQL est la suivante (votre mot de passe CLUB1 sera demandé) :
mysql -p
From this shell it is possible to launch any SQL command.
Connection information#
The MariaDB instance of CLUB1 is not accessible from outside. It is therefore only possible to connect to it from a process running on the same server.
field |
value |
|---|---|
host |
|
port |
|