MySQL – Techinfobest

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…

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…

Comments Off

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…

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…

Comments Off

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…

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.…

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…

Comments Off

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…

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…

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…

Comments Off

MySQL system variables

Database MySQL

Important MySQL System Variables MySQL is mostly used open source database which is very fast and effective when you perfectly configure it. In this article…

Comments Off

Repair WordPress Database by PhpMyAdmin

Database MySQL WordPress

Repair WordPress Database by PhpMyAdmin This post will describe how to “Repair WordPress Database by PhpMyAdmin” in step by step. WordPress use MySQL database; and…

Comments Off

Optimize WordPress Database by PhpMyAdmin

Optimize WordPress Database by PhpMyAdmin This post will describe how to “Optimize WordPress Database by PhpMyAdmin” in step by step. Now a days, many people…

mysql Optimization WordPress

Comments Off

Fastest way to select a random row from a big MySQL table

Database MySQL

Fastest way to select a random row from a big MySQL table In this article I will try to explain the “Fastest way to select…

database mysql random row

MySQL Version Upgrade in Redhat/CentOS from 5.1 to latest

Database MySQL

MySQL Version Upgrade in Redhat/CentOS from 5.1 to latest If you follow traditional procedure for “MySQL Version Upgrade in Redhat/CentOS from 5.1 to latest” ,…

database mysql