Tutorials On Linux, Unix & Open Source
How to configure multiple mysql instance in Ubuntu In this tutorial we will learn,how to configure multiple mysql instance in Ubuntu.Here multiple mysql instance means we can run multiple mysql server in single machine.We expect you have already install mysql-server in your system(if not then run the command apt-get install mysql-server). To configure multiple mysql … Read more
In this tutorial we will learn about how to create multiple mysql instance in CentOS 6.4 and Red Hat 6.4. Multiple instance means in single system we can create multiple MySQL server. These multiple mysql server will run in different ports.In this practical we expect you already have MySQL server installed in your system. To … Read more
In this post we will learn about how to change mysql default port number in linux.This is a simple tip but it has many benefits. Question: What are the benefits of changing the default port no. 3306 in mysql-server ? Answer: For security point of view we generally change the port no. of MySQL Server … Read more
In this tutorial we will learn about how to setup MySQL Master Slave replication in CentOS 6.4.In Master-Slave replication one database server (Master) can replicate the databases to one or more MySQL database Server(slave). The Slave server is not required to be connected always with Master Server, once slave server is up and when you … Read more
While using the mysqldump command in one of the MySQL server I got the error mysqldump: Error: Binlogging on server not active . Below given is the quick solution for it. Details of MySQL Server: MySQL Server: mysql-server-5.5.34 Error: Binlogging on server not active Note: The path of my.cnf file In CentOS and Red Hat … Read more
This is a small tip to find mysql commands history without login into mysql server.When we login into MySQL server,generally we uses up and down arrow key to find the history of MySQL commands. Actually the MySQL commands history are saved in file called .mysql_history located in user’s home directory by which he/she logged into … Read more