The default MongoDB install with no password for accessing databases. You can enforce authentication in the MongoDB server to add an extra layer of security. You may have controlled MongoDB server to accept request from your local area network only, but still there are chances for the hacker to inject malicious script to your...
phpMyadmin is the best web based client for accessing MySQL servers. It is freely available to download and install on your server. You can host this on any server running with Apache and PHP. The phpMyAdmin is written on PHP. The current phpMyAdmin version is compatible with PHP 7.1 and newer and MySQL 5.5...
MariaDB is an opensource relational database server. Which is made by the original developers of MySQL. MariaDB intended to maintain high compatibility with the MySQL server, APIs and commands. This tutorial will help you to install Mariadb database server on your Ubuntu 20.04 LTS system. Prerequisites Running Ubuntu 20.04 system Login access with root...
MySQL is the popular relational database management system. This tutorial will help you to install and secure MySQL database server on your Ubuntu 20.04 LTS system. You may like: How to Install phpMyAdmin on Ubuntu 20.04 Prerequisites Before continuing for MySQL installation on Ubuntu 20.04: Login to Ubuntu as sudo privileged user For the...
The current phpMyAdmin version is compatible with PHP 7.1 and newer and MySQL 5.5 and newer. This tutorial will help you with the installation and configuration of phpMyAdmin on the CentOS 8 Linux system. Step 1 – Prerequisites We are assuming you already have installed the MySQL server on CentOS 8 operating system. So...
PostgreSQL is an open-source object-relational, highly scalable, SQL compliant database management system. PostgreSQL is developed at the University of California at Berkeley Computer Science Department. This article will help you to install PostgreSQL server on CentOS 8 or RHEL 8 Linux systems. Setup DNF Repository First of all, You need to configure the PostgreSQL...
MariaDB 10.4 stable version has been released. It is an enhanced, drop-in replacement for MySQL. MariaDB can be an better choice for choice for database professionals looking for a robust, scalable, and reliable SQL server. MariaDB has a number of updated features over MySQL. Use below links to read features comparison between MariaDB and...
As today, Debian Buster is the latest release available for the Debian operating systems. Which is also known as Debian 10. The newer Debian release has MariaDB as default in their repositories. Now, this tutorial will help you to install MySQL 8 or MySQL 5.7 on Debian 10 (Buster) Linux systems. Step 1 –...
PostgreSQL is an open-source object-relational database system. PostgreSQL 11 is the latest version available for the installation on Debian systems. It is one of the leading database server used for production servers. This tutorial will help you to install the PostgreSQL database server on Debian 10 Buster Linux systems. Installing pgAdmin4 on Debian 10...
The sp_rename stored procedure is used to rename a column name in a table in MSSQL server database. Syntax: Here is the syntax of the sp_rename stored procedure. [crayon-5f6984393e2c8211360099/] Caution: Changing any part of an object name could break scripts and stored procedures. Example: For example, I have a table named Accounts in the...