Welcome to the MySQL Knowledge Base and Tutorial
phpMyAdmin : What is phpMyAdmin?
phpMyAdmin is one of the most popular applications, free and open source tool written in PHP, Intended to handle the administrationRead More »
How Does MySQL Replication Works?
Of course, there are many aspects of MySQL replication, but my main focus will be the logistics – how replicationRead More »
mysqldump - MySQL Database Backup and restore program
What is mysqldump The mysqldump client is a utility that performs logical backups, producing a set of SQL statements that can be runRead More »
How to reset mysql root password
it is quiet easy to reset mysql root password, here are the steps SSH as root to your machine TurnRead More »
save mysql sqery output into txt file
You just need to modify the query and login credential then run the below command of database server . mysqlRead More »
Reset mysql root password
Steps to reset the mysql root password Step # 1 : Stop mysql service # /etc/init.d/mysql stop Step # 2: StartRead More »
MySQL Master-Master-Slave-Slave Replication
Here we are going to create a Master -> Master -> Slave -> Slave replications architecture. I am expecting here , youRead More »
convert time in seconds to HH:MM:SS format in MySQL?
You can use MySQL function SEC_TO_TIME(). Example: SELECT SEC_TO_TIME(2378); Output is: 00:39:38Read More »
Resolved : mysql replica : Relay log read failure: Could not parse relay log event entry.
I’m not sure what the root cause may be. But to recover from this situation, you’d want to instruct MySQLRead More »
Failed to connect to MySQL-asterisk
Files need to check are: /etc/asterisk/res_odbc.conf /etc/odbcinst.ini To resolve this , You have to check the correct configuration of aboveRead More »
Import large csv file using phpMyAdmin
Getting Error while upload large file from phpMyAdmin: Soution: change the memory limit in php.ini file both upload_max_filesize and post_max_size also. Then restart the httpdRead More »
MySQL Skip Duplicate Replication Errors : skip replication error
Normally MySQL replication will stop whenever there is an error running a query on the slave. This happens in order for usRead More »
unauthenticated user in MYSQL process list
Some time in mysql process list you may see “unauthenticated user” increasing up it look like: | 1004 |Read More »
Managing Views in MySQL : Showing mysql view definition
Summary: in this tutorial, you will learn how to manage views in MySQL including displaying, modifying and removing views. Show view definitionRead More »
mysql create user and grant permission
Create user CREATE USER ‘super’@’%’ IDENTIFIED BY PASSWORD ‘*01A6717B58FF5C7EAFFF6CB7C96F7428EA65FE4C’; Grant Permission: GRANT ALL ON *.* TO easy@’10.0.20.212′; Flush Privileges: FLUSH PRIVILEGESRead More »