Projet e-stock  1.0
BTS SN-IR 2019
Installation

Fabrication

$ qmake
$ make
$ sudo make install

Base de données

Serveur MySQL

$ sudo apt install mysql-server

e-stock

$ mysql -uroot -ppassword -hlocalhost < e-stock-v0.2.sql

Compte gestionnaire

$ mysql -uroot -ppassword -hlocalhost
mysql> CREATE USER 'gestionnaire'@'%' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON `e-stock`.* TO 'gestionnaire'@'%';
mysql> FLUSH PRIVILEGES;

Accès distant

$ sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
bind-address 0.0.0.0

Redémarrage

$ sudo systemctl restart mysql.service

Vérification

$ sudo systemctl status mysql.service