20 mysqladmin Commands for MySQL/MariaDB Database Administration

mysqladmin is a command-line database administration utility that comes with MySQL/MariaDB server. It’s used by DBAs to perform basic MySQL tasks such as setting the root password, changing the root password, monitoring mysql processes, reloading privileges, creating/dropping databases, checking server status, show usage statistic, kill running queries, etc.  Here are 20 of the most important […]

The post 20 mysqladmin Commands for MySQL/MariaDB Database Administration appeared first on Linux Today.

20 mysqladmin Commands for MYSQL/MariaDB Database Administration

The post 20 mysqladmin Commands for MYSQL/MariaDB Database Administration first appeared on Tecmint: Linux Howtos, Tutorials & Guides .mysqladmin is a command-line database administration utility that comes with MySQL/MariaDB server, which is used by D…

How to Install MySQL 8.0 Community Edition on Ubuntu 20.04 LTS

MySQL is a free, open-source database management system. Learn how to install MySQL 8.0 Community Edition on Ubuntu 20.04 LTS here.
The post How to Install MySQL 8.0 Community Edition on Ubuntu 20.04 LTS appeared first on Linux Today.

Adminer – A Full-Featured MySQL Database Management Tool

The post Adminer – A Full-Featured MySQL Database Management Tool first appeared on Tecmint: Linux Howtos, Tutorials & Guides .Formerly phpMyAdmin, Adminer is a front-end database management tool written in PHP. Unlike phpMyAdmin, it only comprises a s…

How to Install LAMP stack on Ubuntu 22.04

The LAMP is a shortcut to Linux, Apache, MySQL, and PHP. Learn how to install LAMP stack on Ubuntu 22.04 in this tutorial.
The post How to Install LAMP stack on Ubuntu 22.04 appeared first on Linux Today.

MySQL Backup and Restore Commands for Database Administration

The post MySQL Backup and Restore Commands for Database Administration first appeared on Tecmint: Linux Howtos, Tutorials & Guides .This article shows you several practical examples on how to perform various backup operations of MySQL/MariaDB databases…

How to Install MariaDB in RHEL and Debian Systems

MariaDB is a binary drop-in replacement for MySQL. Learn how to install MariaDB in RHEL and Debian systems in this tutorial.
The post How to Install MariaDB in RHEL and Debian Systems appeared first on Linux Today.

How to Install MySQL Community on Debian 11 Bullseye

The following tutorial will teach you how to install MySQL Community on Debian 11 Bullseye using the MySQL official APT repository.
The post How to Install MySQL Community on Debian 11 Bullseye appeared first on Linux Today.

8 Best MySQL/MariaDB GUI Tools for Linux in 2024

The post 8 Best MySQL/MariaDB GUI Tools for Linux in 2024 first appeared on Tecmint: Linux Howtos, Tutorials & Guides .MySQL is one of the most widely-used open-source relational database management systems (RDBMS), that has been around for a long time…

Millions of MySQL Servers Are Publicly Exposed

More than 3.6 million MySQL servers are publicly exposed on the internet, security researchers noted this week. Learn more here.
The post Millions of MySQL Servers Are Publicly Exposed appeared first on Linux Today.

How to Install osTicket on AlmaLinux

osTicket is an open-source support ticketing system written in PHP which supports MySQL or PostgreSQL. Learn how to install osTicket on AlmaLinux.
The post How to Install osTicket on AlmaLinux appeared first on Linux Today.

Select Data from a Database Using MySQL Logical Operators in PHP

This tutorial explains how to filter data from a MySQL database table using MySQL logical operators. Learn more here.
The post Select Data from a Database Using MySQL Logical Operators in PHP appeared first on Linux Today.

How To Select And Filter Data From a MySQL Database Using PHP In XAMPP

In this guide, we will discuss how to select the records from a MySQL database based on specific conditions with the WHERE clause and the SELECT command using PHP in XAMPP stack.
The post How To Select And Filter Data From a MySQL Database Using PHP In…

How to Install dbWatch to Monitor MySQL Performance in Linux

The post How to Install dbWatch to Monitor MySQL Performance in Linux first appeared on Tecmint: Linux Howtos, Tutorials & Guides .
dbWatch is a powerful, multi-platform, fully-featured, and enterprise-grade SQL database monitoring and management tool …

How to Create MySQL Database and Table Using PHP in XAMPP

This guide explains how to create a MySQL database and table using PHP and also how to create databases and tables via the XAMPP stack.
The post How to Create MySQL Database and Table Using PHP in XAMPP appeared first on Linux Today.

Import Multiple SQL Files In MySQL

If you are manually migrating your website or simply need to import certain SQL files into your database, this article will show you how to import multiple SQL files in mySQL. We will use both a graphical interface and MySQL command-line.

The post Im…

How to Install UVdesk Helpdesk System on Rocky Linux 8

UVdesk is an open-source SaaS-based helpdesk system. In this tutorial, learn how to install UVdesk on Rocky Linux 8 using Nginx, MySQL, and PHP.
The post How to Install UVdesk Helpdesk System on Rocky Linux 8 appeared first on Linux Today.

How to Install Passbolt Password Manager on Rocky Linux

Passbolt is a free and open-source password manager based on PHP, MySQL, and OpenPGP. Learn how to install Passbolt password manager on Rocky Linux here.
The post How to Install Passbolt Password Manager on Rocky Linux appeared first on Linux Today.

How to Enable MySQL/MariaDB Query Logging

When using a database, it often happens that developers want to know what’s going on behind the scenes. Learn how to enable MySQL/MariaDB query logging and save queries to a file here.
The post How to Enable MySQL/MariaDB Query Logging appeared first o…

How to Upgrade MySQL on Ubuntu

In this tutorial, we’ll show you how to upgrade MySQL to a newer version. This tutorial was written and tested for Ubuntu.
The post How to Upgrade MySQL on Ubuntu appeared first on Linux Today.