Skip to content
  • Home
  • About
  • eBooks
  • Shop
  • Donate
  • Linux Online Courses
  • Subscribe to Newsletter
  • Linux Hosting
  • A-Z Linux Commands
  • Get Involved
    • Testimonials
    • Join TecMint
    • Submit Article Request
    • Suggest an Update
Tecmint: Linux Howtos, Tutorials & Guides
  • Linux Distro’s
    • Best Linux Distros
    • RedHat Distributions
    • Linux Distros for Beginners
    • Linux Server Distros
    • Debian Distributions
    • Ubuntu Distributions
    • Arch Linux Distros
    • Rolling Linux Distros
    • KDE Linux Distros
    • Secure Linux Distros
    • Linux Distros for Old PC
    • New Linux Distros
    • Linux Distros for Kids
    • Linux Distros for Windows Users
  • FAQ’s
  • Programming
    • Shell Scripting
    • Learn Python
    • Learn Awk
  • Linux Commands
  • Linux Tricks
  • Best Linux Tools
  • Certifications
    • RHCE Exam
    • RHCSA Exam
    • LFCE Exam
    • LFCS Exam
    • Ansible Exam
  • Guides
    • Hadoop Series
    • Docker Series
    • Postfix Mail
    • XenServer Series
    • RHEV Series
    • Clustering Series
    • LVM Series
    • RAID Series
    • KVM Series
    • iSCSI Series
    • Zentyal Series
    • Ansible Series
    • Django Series
    • Create GUI Apps
  • Monitoring Tools
    • Nagios
    • Zabbix
    • Cacti
    • Observium
    • Monitorix
    • Collectd
    • Collectl
    • MySQL Monitoring

MySQL Tips

Transfer All MySQL Databases to New Server

How to Transfer All MySQL Databases From Old to New Server

12 Comments

Transferring or Migrating a MySQL/MariaDB database between servers usually takes only few easy steps, but data transfer can take some time depending on the volume of data you would like to transfer. In this

Install Latest MySQL in CentOS

How to Install MySQL 8.0 on RHEL/CentOS 8/7 and Fedora 30

107 Comments

MySQL is an open-source free relational database management system (RDBMS) released under GNU (General Public License). It is used to run multiple databases on any single server by providing multi-user access to each created

Change MySQL Port in CentOS and Ubuntu

How to Change Default MySQL/MariaDB Port in Linux

Leave a comment

In this guide we’ll learn how to change the default port that MySQL/MariaDB database binds in CentOS 7 and Debian-based Linux distributions. The default port that MySQL database server is running under Linux and

Check MySQL Database Size in Linux

How to Check MySQL Database Size in Linux

Leave a comment

In this article, I will show you how to check the size of MySQL/MariaDB databases and tables via the MySQL shell. You will learn how to determine the real size of a database file

MySQL/MariaDB Security Best Practices

12 MySQL/MariaDB Security Best Practices for Linux

3 Comments

MySQL is the world’s most popular open source database system and MariaDB (a fork of MySQL) is the world’s fastest growing open source database system. After installing MySQL server, it is insecure in it’s

Connect Mysql Without Root Password

How to Connect to MySQL Without Root Password on Terminal

6 Comments

Normally while installing MySQL/MariaDB database server on Linux, it’s recommended to set a MySQL root user password to secure it, and this password is required to access the database server with root user privileges.

Test PHP MySQL Database Connection

How to Test PHP MySQL Database Connection Using Script

12 Comments

MySQL is a popular database management system while PHP is a server-side scripting language suitable for web development; together with Apache or Nginx HTTP servers, are the different components of the LAMP (Linux Apache

MyCLI - A MySQL Client with Auto-completion and Syntax-highlighting

MyCLI – A MySQL/MariaDB Client with Auto-completion and Syntax-highlighting

2 Comments

MyCLI is an easy-to-use command line (CLI) interface for the popular database management systems: MySQL, MariaDB, and Percona with auto-completion and syntax highlighting. It is built using prompt_toolkit and requires Python 2.7, 3.3, 3.4,

Change a Default MySQL/MariaDB Data Directory in Linux

How to Change a Default MySQL/MariaDB Data Directory in Linux

20 Comments

After installing the components of a LAMP stack on a CentOS/RHEL 7 server, there are a couple of things you may want to do. Some of them have to do with increasing the security

Post navigation
Newer posts
← Previous 1 2

Over 3,500,000+ Readers

Join TecMint on Facebook Follow TecMint on Twitter Join TecMint on LinkedIn Follow TecMint on Instagram Follow TecMint via RSS Feed Subscribe to TecMint Newsletter
A Beginners Guide To Learn Linux for Free [with Examples]
Red Hat RHCSA/RHCE 8 Certification Study Guide [eBooks]
Linux Foundation LFCS and LFCE Certification Study Guide [eBooks]

Learn Linux Commands and Tools

How to Get Hardware Information with Dmidecode Command on Linux

How to Install and Use Chrony in Linux

Let Sudo Insult You When You Enter Incorrect Password

How to Download Files to Specific Directory Using Wget

10 Useful du (Disk Usage) Commands to Find Disk Usage of Files and Directories

How to Christmassify Your Linux Terminal and Shell

Join TecMint Weekly Newsletter

If You Appreciate What We Do Here On TecMint, You Should Consider:

Support Us

Linux Server Monitoring Tools

screenFetch – An Ultimate System Information Generator for Linux

20 Command Line Tools to Monitor Linux Performance

pyDash – A Web Based Linux Performance Monitoring Tool

Duf – A Better Linux Disk Monitoring Utility

How to Setup Central Logging Server with Rsyslog in Linux

ngrep – A Network Packet Analyzer for Linux

Learn Linux Tricks & Tips

Find Out All Live Hosts IP Addresses Connected on Network in Linux

Let Sudo Insult You When You Enter Incorrect Password

How to Find a Specific String or Word in Files and Directories

Find Top 15 Processes by Memory Usage with ‘top’ in Batch Mode

How to Enable, Disable and Install Yum Plug-ins

How to Count Word Occurrences in a Text File

Best Linux Tools

4 Best Linux Apps for Downloading Movie Subtitles

7 Best Command-Line Email Clients for Linux in 2020

16 Open Source Cloud Storage Software for Linux in 2020

Top 6 Partition Managers (CLI + GUI) for Linux

10 Best Media Server Software for Linux in 2019

4 Best Linux Boot Loaders

  • Donate to TecMint
  • Contact Us
  • Advertise on TecMint
  • Linux Services
  • Copyright Policy
  • Privacy Policy
  • Career
  • Sponsored Post
Tecmint: Linux Howtos, Tutorials & Guides © 2021. All Rights Reserved.

The material in this site cannot be republished either online or offline, without our permission.

Hosting Sponsored by : Linode Cloud Hosting

Scroll back to top