Installing SubjectPlus 4.2 on Ubuntu 16.04 LTS

SubjetcPlus is a free and open source tool to help you manage several interrelated parts of your library data

sudo apt update

sudo apt install mysql-server

sudo systemctl start mysql.service

then
CREATING USERS AND DATABASES

To create a MySQL database and user, follow these steps: At the command line, log in to MySQL as the root user:

mysql -u root -p

Type the MySQL root password, and then press Enter

CREATE DATABASE subjectplus;

CREATE USER sp@localhost;

SET PASSWORD FOR sp@localhost= PASSWORD("yourpassword");

GRANT ALL  ON `sp`.* TO `sp`@`localhost` IDENTIFIED BY 'yourpassword';

GRANT ALL PRIVILEGES ON subjectplus.* TO sp@localhost IDENTIFIED BY 'password';

FLUSH PRIVILEGES;

SHOW DATABASES;

View All MySQL Databases

To view the database you’ve created simply issue the following command:

exit 

Your result should be similar to this:

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| spdb               |
| mysql              |
| test               |
| tutorial_database  |
+--------------------+
4 rows in set (0.00 sec)

sudo service apache2 restart

sudo service mysql restart

apt-get install unzip

mkdir -p /var/www/html/sp

wget https://github.com/subjectsplus/SubjectsPlus/archive/master.zipunzip -q /var/www/html/sp/master.zip




chown -R www-data.www-data /var/www/html/spchmod -R 755 /var/www/html/sp

URL http://localhost/sp/SubjectsPlus-master/