MySQL is the most popular database server – odds are your website is using MySQL to store its data. Sometimes we need to check or do other database related work on our website. The default configuration of MySQL server restricts access – only allowing connections from localhost, limiting connections solely to applications hosted on the same server. To enable remote access, we’ll have to modify the server settings to allow connections from external sources, adjust the permissions of the database user, configure the firewall, and so on. In this article, we will demonstrate how to log into remote MySQL server.
We’ll show you, how to install MariaDB on Ubuntu 16.04. MariaDB is a community-developed fork of MySQL. It is a free and open source, very fast, stable and scalable database server, which makes it one of the most used database servers in the world. It is an improved, drop-in replacement for popular MySQL Database Server. In this tutorial, we will show you how to install MariaDB on Ubuntu 16.04. Installing MariaDB on Ubuntu 16.04 is an easy task, and if you carefully follow the steps of this tutorial, you should have MariaDB installed on your Ubuntu 16.04 server in less than 10 minutes. Let’s get started.
We will show you how to install MariaDB on CentOS 7. MariaDB is a community-developed fork of MySQL. MariaDB is a free and open source database software, widely used ranging from websites to banking software. It is an improved, drop-in replacement for MySQL. It is one of the most popular database servers in the world, developed after the acquisition of MySQL by Oracle Inc. to stay free and open source. Installing MariaDB on CentOS 7 is an easy task, just carefully follow the steps of this tutorial and should have MariaDB installed on CentOS 7, in less than 10 minutes. Let’s get started!