A question can only have one accepted answer. Are you sure you want to replace the current answer with this one?
You previously marked this answer as accepted. Are you sure you want to unaccept it?
You could follow the steps from this video on how to host multiple WordPress websites on the same server with Apache Virtual Hosts:
Essentially, what needs to happen is:
mv wordpress /var/www/your_site.com
chown -R www-data:www-data /var/www/your_site.com
sudo cp /etc/apache2/sites-available/000-default.conf /etc/apache2/sites-available/your_site.conf
sudo apachectl -t
Syntax OKreload Apache:
sudo systemctl reload apache2
Then run the following queries:
CREATE DATABASE wp_site; CREATE USER 'wp_site'@'%' IDENTIFIED BY 'use_secure_password_here'; GRANT ALL PRIVILEGES ON wp_site.* TO 'wp_site'@'%' WITH GREANT OPTION;
Hope that this helps.