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 to create a database first and then create a user who have full permission on that database only. Here I show step by step how to create database and user in

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 is started. However, you can again explore how to setup MySQL Replication on the the following links replication-howto replication-gtids-howto Sometimes, replication on Slave server is stopped for many a reasons

Install OCI8 on CentOS/Redhat/Fedora The post will describe how to Install OCI8 on CentOS/Redhat/Fedora in step by step. The easiest way to configure PHP to access Oracle Database is to use Oracle Instant Client libraries. This note describes how to install PHP with the OCI8 Extension and Oracle Instant Client on CentOS/Redhat/Fedora. OCI8 is the PHP

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. The larger you set this value, the less disk I/O is needed to access the same data in tables more than once. On a dedicated database server, you might set

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 an in-memory temporary table exceeds the limit, MySQL automatically converts it to an on-disk MyISAM table. The on-disk table is expensive and affects your database performance. The temporary table may

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 query again to the database engine, MySQL retrieves the result set from the cache and returns that to the client. The bigger query_cache_size can cache more result set. Query has

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 I will discuss with some important MySQL system variables which mostly affect MySQL performance. Properly tuned important MySQL system variables will give you a great database experience. We know that

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 sometimes MySQL table become inaccessible due to some errors and need to be repaired. “Repair WordPress Database” is an easy procedure but may save you at your very crucial moment.