• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
sharadchhetri

sharadchhetri

Tutorials On Linux, Unix & Open Source

  • Home
  • Linux Commands
  • Resources
    • Learn Linux
  • My WordPress plugins

mysql

How to configure multiple mysql instance in Ubuntu

December 4, 2013 by Sharad Chhetri 18 Comments

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 […]

Filed Under: Linux, mysql Tagged With: mysql, mysql multiple instance, ubuntu

How to create multiple mysql instance in CentOS 6.4 and Red Hat 6.4

December 2, 2013 by Sharad Chhetri 12 Comments

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 […]

Filed Under: Linux, mysql Tagged With: mysql, mysql multiple instance

Change mysql default port number in linux

November 25, 2013 by Sharad Chhetri 2 Comments

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 […]

Filed Under: Linux, mysql Tagged With: mysql

Setup MySQL master slave replication in CentOS 6

November 21, 2013 by Sharad Chhetri 11 Comments

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 […]

Filed Under: Linux, mysql Tagged With: master-slave, mysql

mysqldump Error Binlogging on server not active

November 21, 2013 by Sharad Chhetri Leave a Comment

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 […]

Filed Under: mysql Tagged With: mysql, mysqldump

Find mysql commands history without mysql server login

November 19, 2013 by Sharad Chhetri Leave a Comment

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 […]

Filed Under: Linux, mysql Tagged With: mysql

  • « Go to Previous Page
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to page 4
  • Go to Next Page »

Primary Sidebar

Our Social Media Presence

  • Facebook
  • GitHub
  • Twitter

Linux Command

What is Linux Internal And External Command

Linux Basic Commands With Examples For Every Beginner

tr command to convert lines to space , tab and vertical tab

smbpasswd command not found on CentOS 7 and RHEL 7

Solution : semanage command not found

Unix / Linux : How to print duplicate lines from file

More Posts from this Category

You Might Like These Articles!

simplecodesyntax wordpress plugin

SimpleCodeSyntax : My Another WordPress Plugin

Install Nginx

How To Install Nginx On Ubuntu 22.04 LTS

Install Latest Git package in Ubuntu Operating System

How To Always Install Latest Git Package In Ubuntu Operating System

Bash script for installing VirtualBox on Ubuntu 22.04 LTS Desktop

Install VirtualBox On Ubuntu 22.04 LTS Desktop (Bash Script)

libfuse

dlopen(): error loading libfuse.so.2 – Got Error On Ubuntu

Failed to open/create the internal network

VirtualBox Error: Failed to open/create the internal network

Always Useful Tips And Tricks

Run the script using nohup without hitting enter key two times

Yum Error database disk image is malformed

Keep logs of user after sudo su – : Secondary Logging

How to create a file with cat command

safest method to remove softlink in linux

Recover Linux Grub Password in linux rescue mode CentOS/Red Hat

rsync all files,hidden files,symlinks,hardlinks to remotes Linux Server

Explore 90+ Article On "Linux Tips And Tricks"

Copyright © 2023 ยท
The material in this site cannot be republished either online or offline, without our permission.
Proudly Blogging From Bharat.

  • Contact
  • About Me
  • My WordPress plugins
  • Privacy Policy