Music Database System

Course Code : CO301

Course : Database Management Systems

Overview

To run the project :

For Windows

1. Install WampServer (https://sourceforge.net/projects/wampserver/files/latest/download)

2. Download the code as zip ("Music-Database-System.zip"), extract it and copy it to C:\wamp64\www

3. Go to http://localhost/phpmyadmin/, login with username = "root" (there is no password)

4. Import db_music.sql to phpMyAdmin

5. Go to http://localhost/Music-Database-System/

For Ubuntu

1. Install LAMP and phpMyAdmin in Ubuntu.

2. To put files in /var/www/html you need root permission. For that, set the root password (if already not set):
   sudo passwd root
   Now login as root:
   su root
   Give permission to the folder:
   sudo chmod 755 -R /var/www/html
   or
   sudo chmod 755 /var/www/html
   

3. Run the following commands:
   cd /etc/apache2
nano apache2.conf


   Change the below code:
   <Directory /var/www/>
Options Indexes FollowSymLinks
AllowOverride None
Require all granted
   
   as:
   <Directory /var/www/>
Options Indexes FollowSymLinks
AllowOverride All
Require all granted



4. Enable rewrite mode:
   sudo a2enmod rewrite
   Restart apache server:
   sudo service apache2 restart
   

5. Download the code as zip ("Music-Database-System.zip"), extract it and copy it to /var/www/html/

6. Go to http://localhost/phpmyadmin/, login with username = "root" (there is no password)

7. Import db_music.sql to phpMyAdmin

8. Go to http://localhost/Music-Database-System/