Have you ever forgotten your WordPress administrator password and did not have access to your e-mail account or haven’t configured …
In this article, we will show you how to configure remote and secure connections for MySQL on Ubuntu 16.04 VPS. If you are using an unencrypted connection to connect to your remote MariaDB/MySQL server, then everyone with access to the network could monitor and analyze the data being sent or received between the client and the server. This guide should work on other Linux VPS systems as well but was tested and written for an Ubuntu 16.04 VPS.
We’ll show you, how to install LEMP on Ubuntu 16.04. LEMP stack (Linux, Nginx, MySQL, PHP) should not be confused with the popular LAMP stack (Linux, Apache, MySQL, PHP) . This tutorial is for the LEMP (Nginx) stack and it’s commonly used on Ubuntu 16.04 servers. Installing LEMP on Ubuntu 16.04, should not take more then 10 min. Let’s start with the installation of LEMP on Ubuntu 16.04:
We’ll show you How to Install LAMP on Ubuntu 16.04. LAMP (Linux, Apache, MySQL, PHP) is a combination of open source software, typically installed on a server used for hosting dynamic websites and web applications. It includes the Linux operating system, the Apache web server, MySQL for data storage and management and PHP for handling the dynamic content. Installing LAMP on Ubuntu 16.04 is an easy task, just follow the steps below carefully.
MySQL is an open source relational database managed system (RDBMS) that enables users and applications to store, organize, and retrieve their data. It has an access control system that consists of permissions that the users can have within tables and databases. In this tutorial, we will explain how to create a new user in MySQL, and grant permissions to that use. Creating a new user in MySQL database and granting permissions is an easy task if you follow this tutorial carefully.
phpMyAdmin is the most popular and most widely used web-based database management tool. It is a free and open-source PHP application, that allows the users to manage single or multiple SQL database servers, locally or on a remote server using a web browser with easy to use graphic user interface. Today, we are going to teach you, how to install phpMyAdmin on Ubuntu 16.04.
Many developers need to interact and manipulate with their databases, but not all of them are comfortable with SQL commands, and this is where phpMyAdmin comes in handy. You e can easily create, rename, delete and edit databases, tables, or fields, execute SQL commands. You can easily import and export tables, create and modify users, and so on, all via an easy-to-use GUI. Installing phpMyAdmin on Ubuntu 16.04 is an easy task if you carefully follow the steps below.
We have an updated version of this tutorial – How to Install phpMyAdmin on Ubuntu 20.04
We’ll show you, how to secure LEMP stack. LEMP, it stands for Linux, (EngineX) NGINX, MariaDB (or MySQL) and PHP. Due to its flexibility and simplicity, NGINX slowly takes over the Internet. In this tutorial, we will attempt, through examples of bad and good practices, to go through the steps of properly securing your Linux web server. So what is the term Security? Often you can hear the IT Engineers saying “Our network is secure” or “Our servers are secure” however, those sentences although widely used are technically not correct, as in many books and publications you can find that Security as a term is not a static value, but rather a degree. From Wikipedia the definition is:
“Security is the degree of resistance to, or protection from harm. It applies to any vulnerable and/or valuable asset, such as a person, dwelling, community, item, nation, or organization.”
In terms of servers or applications, one should always be aware that the more secure their server or application is, the less accessible it becomes (it is harder to be accessed).
Of course, the best example for this is the proverb:
“The most secure server is the one that is switched off.”.
As ridiculous as it may sound, this is occasionally practiced by some organizations today, where their most secure servers are kept offline and/or in totally closed networks and are powered on only when they need to be.
We’ll show you, how to set up MySQL Cluster on Ubuntu. The MySQL NDB Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (Network DataBase). We will use a total of 4 virtual servers, one for the management, one SQL node and two data nodes: