PostgreSQL Database Server have a lot of tools to manage the suite. Creating user is one of the most popular issue to manage Postgres Database. In this tutorial we will examine how to create user with different rights, privileges, database. We will mainly follow createuser tool for these and createuser is a wrapper for the CREATE ROLE Sql statement. By the way we have allready examined the PostgreSQL Database Server installation in the...
PostgreSQL is very popular open source database. It is used by big companies like Google, Facebook etc. PostgreSQL can be used without a cost. In this tutorial we will look how to install PostgreSQL into Linux distributions like Debian, Ubuntu, Mint, Fedora, CentOS, RedHat by using different ways like package management or downloading setup file. Show PostgreSQL Package Version For Ubuntu, Debian, Mint, Kali with Apt In apt-get or apt based...
I have some MySQL databases. I have no previous experience about MySQL. How can list existing databases with bash?MySQL and MariaDB are using same code base and tools. So we can use following instructions to list MariaDB too. Check Database Service First be sure MySQL/MariaDB service is running
$ systemctl status mysql
As we can see from systemctl output the database service is working properly. Login To MySQL Interactive Shell In order to...