Jeff Wilson 
In this tutorial, we will show you how to use MySQLcheck for optimizing and repairing all tables and databases in MySQL. We will talk about mysqlcheck which is a maintenance command-line tool that allows you to check, analyze, repair, and optimize MySQL/MariaDB tables and databases. Repairing MySQL database is not a complicated process, just follow the steps below carefully.
Most people start out with shared hosting. Every shared hosting plan has a control panel with it. The most popular and widely-used shared hosting control panels are cPanel and DirectAdmin. They have great user interfaces and they are easy to work with. Perfect for beginners. Sooner or later, everyone outgrows their shared hosting account and they move to something more powerful, either a VPS (virtual private server) or a dedicated server. When they do the switch, they don’t know what to expect and what do to. In this article, we are going to write about our experience with thousands of customers and everything you need to know about the switch from shared hosting to a VPS.
Today we will show you several Vim Tips and Tricks. The most common file editor in Linux is Vim. That’s right, you can like it or hate it, but it doesn’t matter. It can be found in every Linux, that is out there. Even if there is no other editor installed in the system, you can still use it in its most basic form, Vi, the program which is its predecessor, written by Bill Joy in 1970 for the UNIX operating systems. Vi and Vim are similar in many ways, with the exception that Vim (VI IMproved) was later developed and adjusted to the more modern Linux systems.
People often ignore Vim and find it frustrating. Most of them, know only how to exit from it, :q!. Those of you that know little about Vim is that when you open a text file you can edit it with :i, and save it with :w or :wq (write to file and exit) or :wq! (! stands for do not prompt for confirmation). One other very common command is just `o` without a colon and when in COMMAND MODE which automatically puts you in INSERT mode and into a new line for writing.
Today we’ll show you, how to change the default SSH port on Linux. Changing the default SSH port from the default 22 to another one is one of the first things you should do to secure your Linux VPS. One of the major benefits of changing the default SSH port is to avoid being scanned by the causal port scans.
Thousands of brute-force logins are attempting to gain access to servers around the world trying to login to the default SSH port looking for weak passwords on the default accounts. Some of them will even try to use the usual variants such as port 222 or 2222. If you change the SSH port to a random number, for example, 2569, you will get rid of most of these annoying and sometimes dangerous brute-force attacks. Changing the default SSH port on Linux, is an easy task, carefully follow our tutorial below and you should have it done in less than 10 minutes.
How to install R on Ubuntu 16.04, in few steps. R is an open source programming language which is used for statistical computing and graphics. The R programming language is widely used by statisticians and data miners mostly for data analysis or developing statistical software. In this tutorial, we will help you to install R on a Linux VPS running Ubuntu as an operating system.
We will show you, how to use rsync in Linux. Rsync is a file-copying tool which allows you to copy or synchronize files and directories on a local or remote system. It is fast and offers a large number of options. In this tutorial, we will show you how to use rsync on a Linux VPS.
WHM/cPanel is a great hosting control panel that eases the server administration dramatically. It has a very easy and straightforward interface for everyday use.
However, many people don’t know the difference between WHM and cPanel. So let’s make a brief explanation.
WHM (Web Hosting Manager) is the core program that has administrative access to the back-end of cPanel. With WHM you can create cPanel accounts and set global settings that apply to them or the server. You can also create reseller accounts and offer hosting services to clients or you can use it for your own personal needs.
cPanel, on the other hand, is the website management panel and allows you to create databases, email accounts, FTP users, add-on domains, subdomains etc. Each individual cPanel account controls the settings for that particular account.
Everybody knows about WordPress, Drupal and Joomla, although they are great and they are popular for a reason, there are quite a few other alternatives that you may have never heard of. Thousands of quality developers and designers work hard to create amazing masterpieces of applications. Most of them release their applications for free and they make them open source. The least we can do is spread the word so they can get the attention they well deserve.