Category: MySQL

1

Recover MySQL 5.7 root Password in Redhat/CentOS 7

Database MySQL
You can recover MySQL 5.7 root Password with following 9  easy steps. These commands will work in Redhat/CentOS 7 Step-1: Stop MySQL server systemctl stop…
Read More
3

fixing mysql replication error automatically

Database Linux MySQL
This article is written for those who have already read article “MySQL Replication skip error” . In that article I explained how to find out replication…
Read More
Comments Off on Create database and user in phpMyAdmin

Create database and user in phpMyAdmin

Database MySQL phpMyAdmin
phpMyAdmin is a great tool to manage MySQL and MariaDB database.  Every cPanel allows  phpMyAdmin interface to manage the hosting database. It is often required…
Read More
7

MySQL Replication skip error

Database MySQL
MySQL Replication skip error There are two ways you can configure MySQL replication : normal and GTID based replication. From MySQL 5.6 GTID based replication…
Read More
Comments Off on Remove Duplicate Rows in MySQL

Remove Duplicate Rows in MySQL

Database MySQL
Remove Duplicate Rows in MySQL Remove duplicate rows in MySQL is a common query for many initial MySQL user. I  have been working on MySQL…
Read More
3

Optimize MySQL innodb_buffer_pool_size

Database MySQL
Optimize MySQL innodb_buffer_pool_size InnoDB buffer pool is the size in bytes of the buffer pool, the memory area where InnoDB caches table and index data.…
Read More
2

Optimize MySQL tmp_table_size

Database MySQL
Optimize MySQL tmp_table_size MySQL tmp_table_size is  the maximum size of internal in-memory temporary tables. (The actual limit is determined as the minimum of tmp_table_size and max_heap_table_size.) If…
Read More
Comments Off on Change MySQL Data Directory

Change MySQL Data Directory

Database MySQL
Change MySQL Data Directory In Redhat/CentOS/Fedora MySQL default data directory remains in /var/lib/mysql. Sometimes you need to change MySQL data directory to a new location…
Read More
8

Optimize MySQL table_open_cache

Database MySQL
Optimize MySQL table_open_cache The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires. You can…
Read More
2

Optimize MySQL query_cache_size

Database MySQL
Optimize MySQL query_cache_size The MySQL query_cache_size is an in memory caches that stores the complete result sets of frequent SELECT queries. Instead of issuing the…
Read More