MariaDB is an open source relationaldatabase compatible with MySQL. It has prooven itself as a very stable, well performing and popular solution. It now often the choice for building a LAMP stack (Linux, Apache, MySQL, PHP).

To grant access to an user over an existing database on your MySQL server, start the `mysql` command line client and execute the following query:

To create a new user on your MySQL server, start the `mysql` command line client and execute the following query:

To create a new database on your MySQL server, start the `mysql` command line client and execute the following query:

The MySQL command line client is a neat tool for every developer or sysadmin. It provides quick and simple access to your MySQL databases.

CentOS 8 is here. And it brings a few changes from the Fedora/RHEL world. Like the new default package manager ‘dnf’. Although it is quite familiar for Fedora users, ‘dnf’ comes to kind of replace the well known ‘yum’ in the CentOS8 world.

One of the most popular server side stack on the web today is LAMP. This powerful combination of Apache Web server, MySQL database and PHP running on top of Linux has proven itself. Today’s article is about setting up LAMP on Ubuntu 18.04. A simple task that takes less than five minutes to get a fully working web server.

Read More

Sometimes you might need to remotely access a MySQL database. As a security measure, by default that is prohibitted, but on your own responsibility we’ll show you how you can make it work.

There are two changes you should make on a clean MySQL installation – first enable the MySQL server to listen on all networks and second to create an user allowed to connect from any client.

For years on MySQL is one of the most popular database server. In this short article we’ll help setup your MySQL server on Ubuntu Server 16.04.