{"id":1783,"date":"2022-12-11T15:50:09","date_gmt":"2022-12-11T14:50:09","guid":{"rendered":"https:\/\/www.klokocka.info\/?p=1783"},"modified":"2023-08-04T21:17:12","modified_gmt":"2023-08-04T19:17:12","slug":"apache-multiple-domains-mysql-wordpress","status":"publish","type":"post","link":"https:\/\/www.klokocka.info\/?p=1783","title":{"rendered":"Apache multiple domains, MySQL, WordPress"},"content":{"rendered":"\n

Original Link<\/a><\/strong><\/p>\n\n\n\n

Install Apache webserver<\/p>\n\n\n\n

<\/p>\n\n\n\n

sudo apt-get install apache2<\/pre>\n\n\n\n
Make directory structure for two domains, change ownership and making webs directories accesible<\/p>\n\n\n\n
sudo mkdir -p \/var\/www\/domain1.com\nsudo mkdir -p \/var\/www\/domain2.com\n\nsudo chown -R $USER:$USER \/var\/www\/domain1.com\nsudo chown -R $USER:$USER \/var\/www\/domain2.com\n\nsudo chmod -R 755 \/var\/www<\/pre>\n\n\n\n
Create the virtual hosts configuration files for two sites<\/p>\n\n\n\n
<VirtualHost *:80>\nServerAdmin webmaster@localhost        \nServerName alarmynakolo.cz\n        ServerAlias www.domain1.com\n        DocumentRoot \/var\/www\/domain1.com\n\tErrorLog ${APACHE_LOG_DIR}\/error.log\n\tCustomLog ${APACHE_LOG_DIR}\/access.log combined\n<\/VirtualHost><\/pre>\n\n\n\n
<VirtualHost *:80>\n\tServerAdmin webmaster@localhost\n\tServerName domain2.com\n\tServerAlias www.domain2.com\n\tDocumentRoot \/var\/www\/domain2.com\n\tErrorLog ${APACHE_LOG_DIR}\/error.log\n\tCustomLog ${APACHE_LOG_DIR}\/access.log combined\n<\/VirtualHost>\n<\/pre>\n\n\n\n
Enable seite configurations<\/p>\n\n\n\n
sudo a2ensite domain1.com.conf\nsudo a2ensite domain2.com.conf\nsystemctl reload apache2<\/pre>\n\n\n\n
Install WordPress (Link<\/a><\/strong>)<\/p>\n\n\n\n
sudo apt update && sudo apt upgrade\n\/\/mariadb\nsudo apt install mariadb-server mariadb-client\n\n\/\/mySQL\nhttps:\/\/www.digitalocean.com\/community\/tutorials\/how-to-install-mysql-on-ubuntu-20-04\nsudo apt install mysql-server\nsudo systemctl start mysql.service\nsudo mysql\nALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';\n\nsudo mysql_secure_installation    (change root password)\napt install php php-mysql<\/pre>\n\n\n\n
Database<\/p>\n\n\n\n
mysql -u root -p\nCREATE DATABASE wp_domain1_com;\nCREATE DATABASE wp_domain2_com;\nCREATE USER 'WordPressUser'@'localhost' IDENTIFIED BY 'YouRSecPASSword123';\nGRANT ALL ON wp_domain1_com.* TO 'WordPressUser'@'localhost'\nGRANT ALL ON wp_domain2_com.* TO 'WordPressUser'@'localhost'\nFLUSH PRIVILEGES;\nexit\n\n\/\/restore database from dump .sql file\nmysql -u root -p wp_domain1_com < \/home\/klokan\/Desktop\/_dbs\/domain1.sql\n\n\/\/phpMyAdmin\nsudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl\nsudo phpenmod mbstring\nsystemctl reload apache2\n\nsudo systemctl restart mysql\nsudo snap install mysql-workbench-community\nsnap connect mysql-workbench-community:password-manager-service\nsnap connect mysql-workbench-community:ssh-keys\nsnap connect mysql-workbench-community:cups-control\nsnap connect mysql-workbench-community:removable-media\nsudo apt install dbus-x11\n\nsudo mysql-workbench-community\n\n<\/pre>\n\n\n\n
Additional settings<\/h4>\n\n\n\n
Support for image editing in wordpress media\nhttps:\/\/linux.how2shout.com\/how-to-install-php-imagemagick-on-ubuntu-22-04\/<\/pre>\n","protected":false},"excerpt":{"rendered":"
Original Link Install Apache webserver Make directory structure for two domains, change ownership and making webs directories accesible Create the virtual hosts configuration files for two sites Enable seite configurations Install WordPress (Link) Database Additional settings<\/p>\n","protected":false},"author":1,"featured_media":1784,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"kt_blocks_editor_width":"","pgc_sgb_lightbox_settings":"","footnotes":""},"categories":[8],"tags":[],"class_list":["post-1783","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-nezarazene"],"_links":{"self":[{"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/posts\/1783","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1783"}],"version-history":[{"count":11,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/posts\/1783\/revisions"}],"predecessor-version":[{"id":2044,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/posts\/1783\/revisions\/2044"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/media\/1784"}],"wp:attachment":[{"href":"https:\/\/www.klokocka.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1783"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1783"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}