Ok merci, j'ai fait la modification dans le fichier, bien enregistré.
Ensuite en voulant relancer le service mysql:
root@ns35957:~# sudo systemctl start mysql
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
Et là ça me sort une tonne de lignes... voici un extrait:
root@ns35957:~# systemctl status mariadb.service
● mariadb.service - MariaDB 10.1.44 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Fri 2020-04-03 17:21:05 CEST; 3min 23s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 22935 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=
Process: 22852 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/gale
Process: 22845 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, s
Process: 22834 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, st
Main PID: 22935 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
avril 03 17:21:04 ns35957 systemd[1]: Starting MariaDB 10.1.44 database server...
avril 03 17:21:05 ns35957 mysqld[22935]: 2020-04-03 17:21:05 139626822605952 [Note] /usr/sbin/mysqld (mysq
avril 03 17:21:05 ns35957 mysqld[22935]: 2020-04-03 17:21:05 139626822605952 [Warning] Can't create test f
avril 03 17:21:05 ns35957 mysqld[22935]: [87B blob data]
avril 03 17:21:05 ns35957 mysqld[22935]: 2020-04-03 17:21:05 139626822605952 [ERROR] Aborting
avril 03 17:21:05 ns35957 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
avril 03 17:21:05 ns35957 systemd[1]: mariadb.service: Failed with result 'exit-code'.
avril 03 17:21:05 ns35957 systemd[1]: Failed to start MariaDB 10.1.44 database server.
lines 1-20/20 (END)
