Databases

How to Install MariaDB 10.4 on Ubuntu 18.04

July 19, 2019

MariaDB is an open source, fully compatible, relational database management system. It is commonly used as a replacement for MySQL due to its fault tolerance, speed, and scalability. In this tutorial, learn how to install the latest version of MariaDB on Ubuntu 18.04.

Read more

How to Install MariaDB on CentOS 7

July 14, 2019

For CentOS 7 users, MariaDB is the default database system as it replaced MySQL as the default database system. In this tutorial, learn how to install MariaDB on CentOS 7 from the local repository or official repository. The guide also shows you how to secure MariaDB and connect to the database management system from the command line.

Read more

How to Check the MySQL Version in Linux

July 11, 2019

It is essential to know which version of MySQL you have installed. The version number helps to determine if a specific feature is available or compatible with your system. This article provides five options to check your version of MySQL in Linux Operating Systems.

Read more

How to Rename a MySQL Database

May 6, 2019

As an administrator, you may need to rename a database. However, for security, the command to rename a database directly was removed in MySQL 5.1.23. This guide will give three alternate methods to rename a database.

Read more

How to Connect to MySQL Using PHP


To access and add content to a MySQL database, you must first establish a connection between the database and a PHP script. In this guide learn how to use PHP to connect to MySQL.

Read more

How to Connect to MySQL from Windows Command Line

May 3, 2019

MySQL is a popular and open-source relational database application. Many servers make use of MySQL, to connect and use databases. This guide will walk you through using the Windows Command prompt to connect to a MySQL database.

Read more

How to Import and Export MySQL Databases in Linux

April 25, 2019

MySQL is a versatile application. It can be used for something as simple as a product database, or as complex as a Wordpress website. Exporting a database puts them in a dump file that can be transferred to another system. Importing brings an existing dump file into an empty installation of MySQL. This guide will walk you through how to export the database and import it from a dump file in MySQL.

Read more

How To Install MySQL on CentOS 7

February 6, 2019

MySQL is a popular free and open source database management application. It forms part of the LAMP stack (Linux, Apache, MySQL, PHP), a software collection used for servers. This guide will walk you through installing MySQL on CentOS 7 from third-party software repositories.

Read more

How to Install MySQL 8.0 in Ubuntu 18.04

December 12, 2018

MySQL is an open-source relational database server tool for Linux operating systems. It is widely used in modern web-based technology, and it forms part of the popular “LAMP” stack of software.  The LAMP stack includes the Linux operating system, Apache web services, MySQL database (or sometimes MariaDB), and the PHP programming language.

Read more
1 13 14 15