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.
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.
In this tutorial, we will show you how to set up Apache virtual hosts on Debian 9. Apache is a free and open source web server. It is the most popular and widely used web server in the world, and it is commonly used in Linux servers. It is developed and maintained by Apache Software Foundation, over half of all servers around the world are running this fast and secure web server.
We’ll show you how to fix serve static content from a cookieless domain error. When using a website analyzer tool such as PageSpeed Insights, GTMetrix, Pingdom, or Uptrends, a warning will often appear that says “Serve Static Content From a Cookieless Domain”. What this means is that your web server is setting cookies – this causes all future HTTP requests to include this cookie, creating unwanted network traffic. This in turn only slows down the speed of your website when a user tries to access it. If you need your website to be as fast as possible, switching to a cookieless domain is the way to go. A cookieless domain does not accept any cookies from any browsers, keeping the overall network traffic lower. The goal is to serve all static content – such as images, javascript, CSS, and more – all through a static, cookieless domain, which helps improve the speed at which these resources are downloaded.
In this article, we will show you how to enable proxy settings for yum command on CentOS 7. Yum is a package management tool that works with RPM packages. It is available on RedHat Enterprise Linux, CentOS, and older versions of Fedora, and it is the most convenient way to handle OS packages and their dependencies on these operating systems.
When a server can only be accessed through proxy servers, you need to configure yum to use a proxy server so you can install a RPM package, or update the currently installed yum packages.
To configure a proxy server so the system user can access and use yum commands is a fairly easy and straight-to-the-point task, and it shouldn’t take more than 5 minutes to configure it. Let’s get started.
XML-RPC is a remote procedure call protocol that allows anyone to interact with your WordPress website remotely. In other words, it’s a way to manage your site without having to log in manually via the standard “wp-login.php” page. It’s widely used by plugins, most famously by Automattic’s own Jetpack plugin. These days, however, the word “XML-RPC” has gotten a bad name. In this tutorial, we will explain what is WordPress XML-RPC and how to stop an XML-RPC attack on your WordPress website.
In this article we will show you how to install Anaconda Python on an Ubuntu 16.04 server. Anaconda is a free and open source package manager for the Python and R programming languages, and it is mainly used for machine learning and data science related applications. Anaconda comes with more than 1000 open-source packages and it works on all major operating systems including Linux, Mac OS and Windows. Installing Anaconda on Ubuntu 16.04 is fairly easy and straight to the point task, and it shouldn’t take more then 10 minutes to install it. Let’s get started.
This tutorial explains the process of installing one of the most popular open-source applications for managing MySQL databases – phpMyAdmin. phpMyAdmin is a free and open source web-based application written in PHP, used to easily manage MySQL databases through your favorite web browser instead of the MySQL command line interface. phpMyAdmin allows users to create, modify, rename and delete databases, tables or fields, execute SQL commands through the browser, import and export tables to a wide range of formats, create users and modify their privileges, and much more… We are going to install phpMyAdmin on a CentOS 7 VPS with Apache, MariaDB, and PHP