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. 1. Login to your VPS via SSH ssh my_sudo_user@my_server The steps in this tutorial assume that you have installed MySQL 5.7 with […]
10 Older Entries »
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: 1. Update the server Make sure that all installed packages on your Ubuntu 16.04 VPS are up to date. apt-get update && apt-get upgrade You can also configure automatic updates. 2. Install Nginx on […]
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. Requirements SSH access with root privileges to your server, as well as Ubuntu 16.04 is required for you to be able to complete all the steps in this […]
In this tutorial, we will explain how to create a new user in MySQL, and grant permissions to that user in MySQL. 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, we will take a look at some of the options this access control system offers later in this tutorial. Creating a new user in MySQL database and granting permissions is an easy task if you follow this […]
Installing phpMyAdmin on an Ubuntu 16.04 is an easy task if you carefully follow the steps bellow. phpMyAdmin is one of the most popular and widely used web-based database management tools. It 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 (GUI). phpMyAdmin is very handy and useful. We can easily create, rename, delete and edit databases, tables or fields, execute SQL commands, import and export tables, create and modify users, etc., all via an easy-to-use GUI. To install phpMyAdmin on […]
Welcome to the first day of the Percona Live Open Source Database Conference: Percona Live 2017 tutorials day! While technically the first day of the conference, this day focused on provided hands-on tutorials for people interested in learning directly how to use open source tools and technologies.
Today attendees went to training sessions taught by open source database experts and got first-hand experience configuring, working with, and experimenting with various open source technologies and software.
The first full day (which includes opening keynote speakers and breakout sessions) starts Tuesday 4/25 at 9:00 am.
Some of the …[Read more]
This is the second and final part of a tutorial on how to test a Python/Flask web app with Selenium webdriver. We are testing Project Dream Team, an existing CRUD web app. Part One introduced Selenium WebDriver as a web browser automation tool for browser-based tests. By the end of Part One, we had written tests for registration, login, performing CRUD operations on departments and roles, as well as assigning departments and roles to employees.
In Part Two, we will write tests to ensure that protected pages can only be accessed by authorised users. We will also integrate our app with CircleCI, a continuous integration and delivery platform. I have included a demo video showing all the tests running, so be sure to check it out!
Permissions …[Read more]
AdonisJs is a MVC Framework for Node that is greatly inspired by the Laravel framework and borrows some of it concepts. AdonisJs follows the software paradigm of conventions over configuration which allows you focus on building your application rather than waste time on configurations. AdonisJs uses ES2015 Generators which removes the unnecessary callbacks from your code.
To explore more about AdonisJs, checkout this tutorial by the creator of Adonis: Meet AdonisJs! A Laravel-style MVC Framework for Node.js.
In this tutorial, we'll to be building a support ticket application. Some times ago, I did a tutorial on …[Read more]
Ever wondered how to write tests for the front-end of your web application? You may already have functional back-end tests, for example to ensure that your models and views are working. However, you may be unsure how to simulate a user of your app for testing. How can you test front-end functions like registration and logging in, which are done in a browser?
In this two-part tutorial, I will show you how to write front-end tests for an existing Python/Flask web application. You should therefore already have a functional application, along with a virtual environment with the necessary software dependencies installed. We will use Project Dream Team, a CRUD web app I built in a three-part tutorial (here is Part One, Part Two and …[Read more]
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 […]
10 Older Entries »