Databases

Workbench is a cross-platform, open-source, visual tool for database management. It provides a user-friendly GUI in which you can create and maintain databases. Learn how to create a MySQL database and table in Workbench, as well as how to add data to a table.

This simple tutorial analyses the commands used to list all user accounts in MySQL. Learn about additional options that help you focus your search.

MySQL is a database application for Linux. It’s part of the LAMP (Linux, Apache, MySQL, PHP) stack that powers many features on the internet. A MySQL installation starts by default with a root user, but it’s better to create a specific user account that’s non-root.

ClickHouse is an open-source column-oriented database management system. It is a fast, scalable, and efficient software to use for data analysis updated in real-time. If you are interested in getting started with the software, this article will guide you how to install and use ClickHouse on your CentOS 7 server.

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.

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.

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.

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.

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.