MySQL

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

MySQL Performance Tuning and Optimization Tips

January 15, 2020

The performance of MySQL databases is an essential factor in the optimal operation of your server. This tutorial shows how to avoid the common pitfalls concerning MySQL queries and system setup.

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