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.

This article can help you on generating SSH keypair for authentication to your remote machines. The benefits of using SSH keys are the added security in compare with password authentication and the ease that you can you the same keypair to connect to multiple sites and remote machines, by just sharing you public key and keeping your private key secure.

CentOS comes with firewalld by default. It allows you to manage your firewall rules based on zones. This short tutorial will cover only the basic setup with the default ‘public’ zone and how to allow ports in it.

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.

The longly anticipated new version of CentOS – 8.0 is here. The release is based on Red Hat Enterprise Linux (RHEL) 8.0, includes the Linux kernel 4.18 and brings a plenty of new features and improvements.

OpenSSH server comes with a pretty neat builtin SFTP subsystem. It allows you to use SFTP out of the box but it also provides some more advanced features. One commonly used feature is restrict an SFTP user to access only one directory and not see the entire server filesystem, or also known as chrooting (from changing the root of the filesystem tree).

The new Fedora 30 has been released on April 29th. It includes plenty of updates among which GCC 9, Bash 5.0, and PHP 7.3 and more.

You can go through the full change set at: https://fedoraproject.org/wiki/Releases/30/ChangeSet

The new image is already available on CloudBalkan.