Jeff Wilson, Author at RoseHosting

How to Install MyWebSQL on Ubuntu 16.04

June 3, 2022July 24, 2018 by Jeff Wilson

In this tutorial we will show you how to set up MyWebSQL on Ubuntu 16.04 server. MyWebSQL is a free and open source web based WYSIWYG client for managing the databases on your server. It provides a simple and intuitive interface with the look and feel of a desktop application. This PHP based application offers rich features amd plenty of tools for database management and it can work with MySQL, PostgreSQL, and SQLite databases. With it’s fast and attractive web interface it is a very good alternative to the popular phpMyAdmin.

How to Install MongoDB on Debian 9

June 3, 2022July 20, 2018 by Jeff Wilson

In today’s article we are going to show you how to install MongoDB on Debian 9. MongoDB is a free and open-source NoSQL document-oriented database which is platform oriented. It stores all data in documents using JSON format (BSON) which makes the data to be highly flexible. MongoDB comes in Community and Enterprise editions. The Enterprise edition provides additional administration, authentication, and monitoring features. Community edition is the free and open source release of MongoDB and we will install it in this tutorial on a Debiab 9 VPS.

How to List All Running Services in Linux

June 3, 2022July 19, 2018 by Jeff Wilson

Linux-based operating systems, like all other operating systems, have processes and services that run while the machine is on. These range from various operating system services, to the command line, to different services/daemons designed to maintain the system and keep it running smoothly. Most services are vital to a process’ normal operation, ranging from helper services to special services designed to handle input, improve performance, offload resources, etc. Processes are also the backbone of a computer’s core functionality, making it important to have the resources for them all.

How to Configure WordPress to use a Remote Database

June 3, 2022July 18, 2018 by Jeff Wilson

WordPress is the most popular content management system (CMS) based on PHP and MySQL. When your WordPress CMS grows in traffic and you have outgrown your current server resources, a professional solution is to host your database on a separate database server. With this solution, you can optimize your database and your web server independently and both servers can grown on it’s own machine. In this tutorial we will guide you on how to configure WordPress to use a remote database, on a CentOS 7 based VPS.

How to (Safely) Add Code to functions.php in WordPress

October 4, 2022July 17, 2018 by Jeff Wilson

Scouring the Internet for solutions to WordPress problems will inevitably bring you to sites that ask you to insert some piece of code or the other into functions.php. If you’re new to WordPress, this can be a confusing thing. By default, WordPress doesn’t have any obvious interface for you to insert code. And besides…copy-pasting stuff into your installation is dangerous. In this tutorial, we’ll show you how to safely install code into WordPress’s functions.php file. Let’s go.

How To Install WordPress with LAMP Stack on Ubuntu 16.04

June 3, 2022July 16, 2018 by Jeff Wilson

WordPress is one of the world’s most popular content management systems (CMS). It is a free and open-source platform, which is used by millions of people for running blogs, business websites, e-commerce stores and much more.

It is a powerful and very easy to use website creation tool. With a large variety of plugins and themes to choose from, it provides very high customization options and almost endless possibilities for you to develop and make a unique, one of a kind website.

In this tutorial, we will show you how to install the latest WordPress version on your Ubuntu 16.04 VPS. We will also show you how to install and configure a fully functional LAMP stack, consisting of Ubuntu 16.04 operating system, Apache web server, MySQL database server and PHP 7. Let’s get started.

Basic MySQL Database Administration on Linux VPS – Part 2

December 29, 2022July 12, 2018 by Jeff Wilson

In this tutorial, we will show you how to insert into and manipulate data in your tables. To find out how to create and manage databases and tables you can check out our previous tutorial: Basic MySQL database administration on a Linux VPS. If your Linux VPS is up and running and has MySQL installed, then you are good to go.

How to Schedule Cron Jobs in cPanel

April 5, 2023July 10, 2018 by Jeff Wilson

A cron job is a Linux command that’s executed at regular intervals. These “jobs” can be scheduled via the command line, but it’s much easier to do it via the cPanel GUI interface. cPanel also conveniently shows the number of existing cron jobs, and it can also send the output of the command via e-mail. In this tutorial, we’ll show you how to schedule cron jobs easily and efficiently.