MariaDB is a popular open-source alternative to MySQL database and is conveniently available in the standard repositories. First, update the packages list on the server with the command below.<\/p>\n\n\n\n
sudo apt update<\/pre>\n\n\n\nOnce the packages list has been updated, run the following command to install the MariaDB server and MariaDB client on your server. You\u2019ll be prompted to confirm whether you want to use storage space. Type Y and press Enter to continue with the installation.<\/p>\n\n\n\n
sudo apt install mariadb-server<\/pre>\n\n\n\nNext, perform the secure installation of MySQL on your server with the following command.<\/p>\n\n\n\n
sudo mysql_secure_installation<\/pre>\n\n\n\nThe command prompt will take you through the wizard containing the questions below. Answer each of them below:<\/p>\n\n\n\n
Change the root password: N\nRemove anonymous user: Y\nDisallow root login remotely: Y\nRemove test database and access to it: Y\nReload Privilege Table Now: Y<\/pre>\n\n\n\nNow that MariaDB is installed and configured, we can create the first database.<\/p>\n\n\n\n
Enter the MySQL client by running the next command.<\/p>\n\n\n\n
sudo mysql<\/pre>\n\n\n\nThen, use the following commands to create a database and grant all permissions on that database to a new database user account.<\/p>\n\n\n\n
mysql > CREATE DATABASE wordpress;\nmysql > GRANT ALL ON wordpress.* TO 'wordpress'@'localhost' IDENTIFIED BY 'password';<\/pre>\n\n\n\nFlush the privilege table and exit from the mysql shell.<\/p>\n\n\n\n
mysql > flush privileges;\nmysql > exit;<\/pre>\n\n\n\nYour database is then set to install WordPress at a later step.<\/p>\n\n\n\n
Installing required PHP extensions<\/h2>\n\n\n\n WordPress works on top of PHP and SQL. To run WordPress on a server seamlessly, install the following required PHP extensions.<\/p>\n\n\n\n
sudo apt install lsphp74-common lsphp74-curl lsphp74-imap lsphp74-json \nlsphp74-mysql lsphp74-opcache lsphp74-imagick lsphp74-memcached lsphp74-redis<\/pre>\n\n\n\nConfiguring OpenLiteSpeed<\/h2>\n\n\n\n Next, you need to configure the OpenLiteSpeed server to host your WordPress site. It requires you to set the right version of the PHP processor, enable the rewrite module and several other features.<\/p>\n\n\n\n
Configure your server to use lsphp74 as a PHP processor instead of the default PHP processor.<\/p>\n\n\n\n
Go to Server Configuration<\/em> > External App<\/em> and click the edit icon as shown below.<\/p>\n\n\n\nHere, you can configure your server to use any specific PHP processor. For this tutorial, we will use lsphp74.<\/p>\n\n\n\n
\nReplace lsphp<\/em> with lsphp74<\/em><\/li>\n\n\n\nReplace uds:\/\/tmp\/lshttpd\/lsphp.sock<\/em> with uds:\/\/tmp\/lshttpd\/lsphp74.sock<\/em><\/li>\n\n\n\nReplace lsphp73\/bin\/lsphp<\/em> with $SERVER_ROOT\/lsphp74\/bin\/lsphp<\/em><\/li>\n<\/ul>\n\n\n\nAfter you make the changes, click the save icon in the top right corner of the panel, as shown in the screenshot above.<\/p>\n\n\n\n
Moving next to configure the rewrite module which is an essential requirement for the WordPress features. Go to the Virtual Hosts<\/em> and click on the view icon.<\/p>\n\n\n\nClick on the General<\/em> tab and edit the General options<\/em> with the edit icon at the top right corner.<\/p>\n\n\n\nIn the Document Root<\/em> field, type $VH_ROOT\/html\/wordpress<\/em> and click the save button at the top right corner.<\/p>\n\n\n\nThen again on the General<\/em> tab of Virtual Hosts<\/em> configuration, click the edit icon next to the Index Files<\/em> section.<\/p>\n\n\n\nIn the Index Files<\/em> field, add index.php<\/em> at the beginning of the section. Then click the save button at the top right corner.<\/p>\n\n\n\nNext, go to the Rewrite<\/em> tab of the Virtual Hosts<\/em> configuration view and edit the Rewrite Control<\/em> options.<\/p>\n\n\n\nSet Enable Rewrite<\/em> and Auto Load from .htaccess<\/em> to Yes<\/em> and click the save icon at the top right corner.<\/p>\n\n\n\nOnce you\u2019ve configured the OpenLiteSpeed server, Click the gracefully restart icon to apply the changes.<\/p>\n\n\n\nDownloading and extracting WordPress<\/h2>\n\n\n\n Now that our server is configured to host WordPress, you should download and install WordPress.<\/p>\n\n\n\n
Navigate to the virtual host root which is \/usr\/local\/lsws\/Example\/html<\/em><\/p>\n\n\n\ncd \/usr\/local\/lsws\/Example\/html\/<\/pre>\n\n\n\nThen download the latest version of WordPress using the wget command below.<\/p>\n\n\n\n
wget https:\/\/wordpress.org\/latest.tar.gz<\/pre>\n\n\n\nLastly, extract the zipped file. This will create a directory called \u2018wordpress\u2019 in \/usr\/local\/lsws\/Example\/html<\/tt><\/p>\n\n\n\ntar xvfz latest.tar.gz<\/pre>\n\n\n\nSetting up file ownership and permissions<\/h2>\n\n\n\n Setting up the right ownership of files and folders will make sure that you do not encounter problems while installing or downloading new themes or plugins.<\/p>\n\n\n\n
First, remove ownership from the wordpress directory.<\/p>\n\n\n\n
sudo chown -R nobody:nogroup \/usr\/local\/lsws\/Example\/html\/wordpress<\/pre>\n\n\n\nThen, 750 permissions were set for the directories and 640 for the files. You can do this with the following commands.<\/p>\n\n\n\n
sudo find \/usr\/local\/lsws\/Example\/html\/wordpress\/ -type d -exec chmod 750 {} \\;\nsudo find \/usr\/local\/lsws\/Example\/html\/wordpress\/ -type f -exec chmod 640 {} \\;<\/pre>\n\n\n\nOnce you configure the right permissions, you\u2019re all set to open your website and install WordPress in your browser.<\/p>\n\n\n\n
Installing WordPress<\/h2>\n\n\n\n At this stage, you can open the WordPress installation wizard in your web browser by going to your domain if set or the IP address of your OpenLiteSpeed server.<\/p>\n\n\n\n
The very first screen will ask you to choose your preferred language. Choose your language and click the Continue<\/em> button.<\/p>\n\n\n\nIn the second screen, WordPress prompts you to keep the database server information and credentials ready. Then just click the Let\u2019s go!<\/em> button.<\/p>\n\n\n\nIn the next screen, fill up the fields as follows:<\/p>\n\n\n\n
\nDatabase name: the database you created through the MySQL shell, wordpress<\/em> in this example.<\/li>\n\n\n\nUsername: Here you need to input the database user<\/li>\n\n\n\n Password: Type in the password of your database user<\/li>\n\n\n\n Database Host: localhost<\/li>\n\n\n\n Table Prefix: wp_ is the default table prefix. However, you can type something else to enhance the security of your website.<\/li>\n<\/ol>\n\n\n\nOnce you fill up all the information, click the Submit button to confirm.<\/p>\n\n\n\nAt this stage, you\u2019ve configured the database connection for the WordPress installation. Next, you need to click the Run the Installation<\/em> button to set up your WordPress site.<\/p>\n\n\n\nNext, you\u2019ll be prompted to input the details of your website, create an administrator account and set a password.<\/p>\n\n\n\n
Select the name of your website and choose an administrator username. It is recommended not to use a generic username such as \u201cadmin\u201d or \u201cadministrator\u201d. A strong password will be generated automatically. Type in your email address and choose whether you want search engines to index your site or not.<\/p>\n\n\n\nOnce you\u2019ve filled up everything and ready, click the Install WordPress<\/em> button. On successful installation, you will be prompted to log in.<\/p>\n\n\n\nLog in using the username and password you just created in the installation wizard. You\u2019ll then see your very own WordPress website\u2019s admin dashboard.<\/p>\n\n\n\nCreating and configuring SSL certificates<\/h2>\n\n\n\n At this stage, you should have successfully installed WordPress on your web server using one of the most powerful server packages. Next, we can obtain and install SSL certificates to add a security layer between your website server and your audience.<\/p>\n\n\n\n
If you have already used Certbot to obtain SSL certificates for your OpenLiteSpeed server, you can use the Certbot client that has already been installed. In that case, you can skip the installation step here and go ahead to obtain certificates for your WordPress site.<\/p>\n\n\n\n
If you do not yet have the Certbot installed, use the steps here to get the client.<\/p>\n\n\n\n
First, update the packages installed on the server.<\/p>\n\n\n\n
sudo apt update<\/pre>\n\n\n\nThen, install the Certbot client using the following command.<\/p>\n\n\n\n
sudo apt install certbot<\/pre>\n\n\n\nOnce you\u2019ve installed the Certbot, go ahead and obtain the SSL certificates for your server using the command below. Note that before you can obtain SSL certificates, you need to have a domain name A record pointing to your OpenLiteSpeed server\u2019s public IP address. You can find out more about\u00a0how to create domain name records<\/a>\u00a0in its guide.<\/p>\n\n\n\nsudo certbot certonly --webroot<\/pre>\n\n\n\nYou will then be prompted to answer the following questions.<\/p>\n\n\n\n
\nEnter Email address: Type in your email address<\/li>\n\n\n\n Accept the terms of service: A<\/li>\n\n\n\n Share your Email Address with EFF: Type Y for yes and N for No.<\/li>\n\n\n\n Enter Domain name: Type your FQDN (fully qualified domain name) here<\/li>\n\n\n\n Input the Web root: \/usr\/local\/lsws\/Example\/html\/wordpress\/<\/li>\n<\/ul>\n\n\n\nOnce you have answered all the questions and validation process is complete, the certificate files will be saved in \/etc\/letsencrypt\/live\/<your-domain>\/<\/em> directory.<\/p>\n\n\n\nNext, configure the WordPress site on your OpenLiteSpeed server to use the SSL certificate. Navigate to the Virtual Host configuration and open the SSL tab. Edit the SSL Private Key & Certificate.<\/p>\n\n\n\nType the fields as follows:<\/p>\n\n\n\n
Private Key File: \/etc\/letsencrypt\/live\/<your-domain>\/privkey.pem\nCertificate File: \/etc\/letsencrypt\/live\/<your-domain>\/fullchain.pem\nChained Certificate: Yes\nCA Certificate Path: \/etc\/letsencrypt\/live\/<your-domain>\/fullchain.pem\nCA Certificate File: \/etc\/letsencrypt\/live\/<your-domain>\/fullchain.pem<\/pre>\n\n\n\nOnce completed, go to Listeners<\/em> and add a new listener.<\/p>\n\n\n\nFill in the fields as follows:<\/p>\n\n\n\n
Listener Name: SSL\nIP Address: ANY\nPost: 443\nBinding:\nEnable REUSEPORT: Not Set\nSecure: Yes<\/pre>\n\n\n\nOnce all set, apply the new settings by clicking the save icon on the right.<\/p>\n\n\n\nNext, view the SSL listener to configure the Virtual host mapping.<\/p>\n\n\n\nAdd a row in Virtual Host Mappings.<\/p>\n\n\n\nChoose the virtual host and type in your domain name. Save the settings using the save button in the top right corner.<\/p>\n\n\n\nOnce you\u2019ve configured the SSL with your OpenLiteSpeed server, click the gracefully restart icon to apply the changes.<\/p>\n\n\n\n
You should now be able to visit your website on https protocol as well.<\/p>\n\n\n\n
Conclusion and next steps<\/h2>\n\n\n\n Congratulations, you should now have a brand new WordPress site set up and secured with SSL certificates. WordPress runs lightning quick on the top of the OpenLiteSpeed web server with little left to be desired.<\/p>\n\n\n\n
You can install the LiteSpeed Cache Plugin to enable server-optimized caching for your WordPress website.<\/p>\n\n\n\n
You can also enable Memcached caching on your server with the following command.<\/p>\n\n\n\n
sudo apt-get install memcached<\/pre>\n\n\n\nLastly, you might wish to install some of the must-have WordPress plugins and choose a WordPress Theme. To get started, head over to your WordPress dashboard.<\/p>\n","protected":false},"author":47,"featured_media":17420,"comment_status":"open","ping_status":"closed","template":"","community-category":[250,277],"class_list":["post-2119","tutorial","type-tutorial","status-publish","has-post-thumbnail","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/upcloud.com\/global\/wp-json\/wp\/v2\/tutorial\/2119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/upcloud.com\/global\/wp-json\/wp\/v2\/tutorial"}],"about":[{"href":"https:\/\/upcloud.com\/global\/wp-json\/wp\/v2\/types\/tutorial"}],"author":[{"embeddable":true,"href":"https:\/\/upcloud.com\/global\/wp-json\/wp\/v2\/users\/47"}],"replies":[{"embeddable":true,"href":"https:\/\/upcloud.com\/global\/wp-json\/wp\/v2\/comments?post=2119"}],"version-history":[{"count":0,"href":"https:\/\/upcloud.com\/global\/wp-json\/wp\/v2\/tutorial\/2119\/revisions"}],"wp:attachment":[{"href":"https:\/\/upcloud.com\/global\/wp-json\/wp\/v2\/media?parent=2119"}],"wp:term":[{"taxonomy":"community-category","embeddable":true,"href":"https:\/\/upcloud.com\/global\/wp-json\/wp\/v2\/community-category?post=2119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"OpenLiteSpeed](\"https:\/\/upcloud.com\/media\/11-openlitespeed-sapi-app.png\")
<\/figure>\n\n\n\n![\"Configuring](\"https:\/\/upcloud.com\/media\/17-openlitespeed-configure-php.png\")
<\/figure>\n\n\n\n![\"Editing](\"https:\/\/upcloud.com\/media\/15-openlitespeed-edit-virtual-host.png\")
<\/figure>\n\n\n\n![\"Editing](\"https:\/\/upcloud.com\/media\/19-openlitespeed-edit-virtual-host-general.png\")
<\/figure>\n\n\n\n![\"OpenLiteSpeed](\"https:\/\/upcloud.com\/media\/2-openlitespeed-virtual-host-general.png\")
<\/figure>\n\n\n\n![\"OpenLiteSpeed](\"https:\/\/upcloud.com\/media\/18-openlitespeed-virtual-host-general.png\")
<\/figure>\n\n\n\n![\"Setting](\"https:\/\/upcloud.com\/media\/4-openlitespeed-virtual-host-index.png\")
<\/figure>\n\n\n\n![\"Enabling](\"https:\/\/upcloud.com\/media\/13-openlitespeed-virtual-host-rewrites.png\")
<\/figure>\n\n\n\n![\"OpenLiteSpeed](\"https:\/\/upcloud.com\/media\/1-openlitespeed-rewrite-control.png\")
<\/figure>\n\n\n\n![\"Restarting](\"https:\/\/upcloud.com\/media\/23-openlitespeed-restart-web-server.png\")
<\/figure>\n\n\n\n![\"Selecting](\"https:\/\/upcloud.com\/media\/20-openlitespeed-wordpress-select-language.png\")
<\/figure>\n\n\n\n![\"Starting](\"https:\/\/upcloud.com\/media\/8-openlitespeed-start-wordpress.png\")
<\/figure>\n\n\n\n![\"WordPress](\"https:\/\/upcloud.com\/media\/22-openlitespeed-wordpress-database-settings.png\")
<\/figure>\n\n\n\n![\"Running](\"https:\/\/upcloud.com\/media\/21-openlitespeed-wordpress-run-install.png\")
<\/figure>\n\n\n\n![\"Installing](\"https:\/\/upcloud.com\/media\/12-openlitespeed-install-wordpress.png\")
<\/figure>\n\n\n\n![\"WordPress](\"https:\/\/upcloud.com\/media\/10-openlitespeed-wordpress-dashboard.png\")
<\/figure>\n\n\n\n![\"Adding](\"https:\/\/upcloud.com\/media\/16-openlitespeed-add-ssl-keys.png\")
<\/figure>\n\n\n\n![\"Saving](\"https:\/\/upcloud.com\/media\/6-openlitespeed-ssl-keys.png\")
<\/figure>\n\n\n\n![\"Adding](\"https:\/\/upcloud.com\/media\/14-openlitespeed-add-listener.png\")
<\/figure>\n\n\n\n![\"Enabling](\"https:\/\/upcloud.com\/media\/9-openlitespeed-listener-enable-secure.png\")
<\/figure>\n\n\n\n![\"OpenLiteSpeed](\"https:\/\/upcloud.com\/media\/5-openlitespeed-ssl-listener.png\")
<\/figure>\n\n\n\n![\"Adding](\"https:\/\/upcloud.com\/media\/3-openlitespeed-add-virtual-host.png\")
<\/figure>\n\n\n\n![\"Setting](\"https:\/\/upcloud.com\/media\/7-openlitespeed-virtual-host-domains.png\")
<\/figure>\n\n\n\n