SQL databases#
- SQL#
(Structured Query Language) A computer language for searching information in a relational database. — 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#
It is possible to connect to the SQL server directly from the command line. To do this, you must first connect to the server using SSH. Then, the command to start a SQL shell is the following:
mariadb
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.
Important
It is generally unnecessary to enter your password, as local connections will prefer to use the “Unix socket”, and thus authenticate automatically. This is particularly the case for PHP.
Not entering a password improves the security of your CLUB1 account, since it prevents it from being saved in plain text on the server.
field |
value |
|---|---|
host |
|
port |
|