Mysql

Installer mariadb

https://doc.ubuntu-fr.org/mysql

Vérifier qu’il tourne : 

systemctl status mysql

Sécuriser :

mysql_secure_installation

Créer une base de donnée :

create database squid;

grant select on squid.* to greta@localhost identified by greta;

Créer une table :

CREATE TABLE `passwd` (

  `user` varchar(32) NOT NULL default '',

  `password` varchar(35) NOT NULL default '',

  `enabled` tinyint(1) NOT NULL default '1',

  `fullname` varchar(60) default NULL,

  `comment` varchar(60) default NULL,

  PRIMARY KEY  (`user`)

);

Créer un enregistrement :

insert into passwd values('testuser','test',1,'Test User','for testing purpose');

insert into passwd values('testuser2',md5('test'),1,'Test User','for testing purpose');