MySQL

How to Install MySQL on CentOS 8

February 17, 2020

MySQL, the most widely used relational database management system can be installed on CentOS 8 from the default AppStream repository or from the official MySQL developer's repository. This article details both options and instructs how to secure your databases.

Read more

MySQL Docker Container Tutorial: How to Set Up & Configure

February 10, 2020

Deploying MySQL in a container is a fast and efficient solution for small and medium-size applications. Instead of setting up a separate MySQL server, you can deploy a MySQL database container instead. These containers are lightweight and fast to spin up since they share the kernel and libraries of the host while packaging the deployed application.

Read more

How to Create MySQL Database in Workbench

January 29, 2020

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.

Read more

How to List All Users in a MySQL Database

November 18, 2019

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

Read more

How To Create New MySQL User and Grant Privileges

September 18, 2019

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.

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 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 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 4 5 6