MariaDB server is a community developed fork of MySQL server. Started by core members of the original MySQL team, MariaDB is designed as a drop-in replacement of MySQL(R) with more…
Databases
-
-
Centos/RedhatDatabasesLinux
How To Reset MySQL or MariaDB Root Password On CentOS 7 / RHEL 7
by Lotfi Waderni January 15, 2019In this tutorial we will cover how to reset the root password of MySQL and MariaDB on CentOS 7 / RHEL 7 Step 1 – Checking the version of Database…
-
Centos/RedhatDatabasesLinux
How To install PostgreSQL 11 on CentOS 7 / RHEL 7
by Lotfi Waderni January 9, 2019What is PostgreSQL? PostgreSQL is a powerful, open source object-relational database system ( ORDBMS ). Unlike other relational database systems, PostgreSQL (Postgres) allows users to create unique operators, complex data…
-
DatabasesLinuxUbuntu
How To Install PostgreSQL 11 on Ubuntu 18.04 LTS / 16.04 LTS
by Lotfi Waderni January 7, 2019What is PostgreSQL? PostgreSQL is a powerful, open source object-relational database system ( ORDBMS ). Unlike other relational database systems, PostgreSQL (Postgres) allows users to create unique operators, complex data…
-
DatabasesLinuxUbuntu
How to install PgAdmin 4 in Server Mode as a Web Application using WSGI on Ubuntu 18.04 LTS / Ubuntu 16.04 LTS
by Lotfi Waderni August 31, 2018PgAdmin is the leading graphical Open Source management, development and administration tool for PostgreSQL. PgAdmin 4 is a rewrite of the popular pgAdmin3 management tool for the PostgreSQL database. In…
-
DatabasesLinux
How to Setup a Logical Replication on PostgreSQL 10
by Lotfi Waderni November 14, 2017PostgreSQL is a powerful, open source object-relational database system ( ORDBMS ). Unlike other relational database systems, PostgreSQL allows users to create unique operators, complex data types, aggregate functions, data…
-
Centos/RedhatDatabasesLinux
How to Install MariaDB 10.3 on CentOS 7 / RHEL 7
by Lotfi Waderni October 31, 2017MariaDB server is a community developed fork of MySQL server. Started by core members of the original MySQL team, MariaDB is designed as a drop-in replacement of MySQL(R) with more…
-
DatabasesLinuxUbuntu
How To Install and Use PostgreSQL 10 on Ubuntu 16.04 LTS
by Lotfi Waderni October 31, 2017PostgreSQL is a powerful, open source object-relational database system ( ORDBMS ). Unlike other relational database systems, PostgreSQL (Postgres) allows users to create unique operators, complex data types, aggregate functions,…
-
Centos/RedhatDatabasesLinux
How To Install PostgreSQL 10 on CentOS 7 / RHEL 7
by Lotfi Waderni October 31, 2017PostgreSQL is a powerful, open source object-relational database system ( ORDBMS ). Unlike other relational database systems, PostgreSQL allows users to create unique operators, complex data types, aggregate functions, data…
-
DatabasesLinux
How to Connect to a PostgreSQL database using PgAdmin4
by Lotfi Waderni October 8, 2017There are a number of front-end tools available for connecting to, and working with, the PostgreSQL database. Among the most popular are psql, a command-line tool for querying the database,…