How To Solve Forgot MySQL / MariaDB Root Password
In this article. learn how to reset forgotten mysql / MariaDB root password. Also learn some tips to prevent and manage such situation.
-
-
Upgrading MySQL 5.1 to 5.6 service failed to start
Recently we got the system which has MySQL server version 5.1 was running. It was good chance for me to reproduce the issue and show practical answer on question asked on stackoverflow. Operating System: CentOS 6.5Arch : x86_54 Symptom MySQL service failed to start after upgrading from MySQL 5.1 to 5.6 version. Given below is…
-
Install MariaDB Server 10.0 on Ubuntu 14.04 LTS ( Trusty Tahr )
The post will explain, how to install MariaDB Server 10.0 on Ubuntu 14.04 LTS (Trusty Tahr) . MariaDB which is now a days very popular. It is fork of MySQL and best alternate of MySQL. Red Hat has already announced the MariaDB as default Database in Verion RHEL 7.0. I surely suggest you to know…
-
Install MariaDB Server on CentOS 7 / RHEL 7
In this tutorial we will learn, how to install MariaDB Server on CentOS 7 / RHEL 7 . Before the stable release of RHEL 7, it was confirmed the MariaDB will be default database. This is one of the major changes we have observed in this RHEL 7/CentOS 7 stable release. Whereas MySQL server still…
-
How to install MySQL Server 5.6 on CentOS 7 / RHEL 7
In this tutorial we will learn, how to install MySQL Server 5.6 on CentOS 7 / RHEL 7 . In our previous post, we have installed MySQL Server 5.6 on CentOS 6.x/RHEL 7.x. In CentOS 7/ RHEL 7 , now MariaDB is introduced as a defualt database. Still many Organisations/Company would like to continue with…
-
mysqldump: Got error: 145: Table ‘./DB/table-name’ is marked as crashed
It was time to take backup of mysql database of my server. I run the command mysqldump with some options and found the error, ” mysqldump: Got error: 145: Table ‘./DB/table-name’ is marked as crashed and should be repaired when using LOCK TABLES ” I have seen this error before but not written on this…
-
How to install mysql server 5.6 on Ubuntu 14.04 LTS ( Trusty Tahr )
In this practical we will learn, how to install mysql server 5.6 on Ubuntu 14.04 LTS ( Trusty Tahr ).At the time of writing this post, MySQL Server has 5.6 version as stable release (release date – 11 April 2014). MySQL is a open source relational database management system (RDBMS). It is popularly used in…
-
Install MongoDB server on Ubuntu 12.04 LTS
In this tutorial we will learn,how to install MongoDB server on Ubuntu 12.04 LTS. MongoDB is one the popular nosql database.It is a cross-platform document-oriented database system.MongoDB has its interactive shell called mongo .In recent years,many companies started using MongoDB.To know about more details on MongoDB,you can visit the Wikipedia link How to install MongoDB…
-
Install Mariadb 5.5 on Ubuntu 12.04 LTS
In this tutorial we will learn, how to install Mariadb 5.5 on Ubuntu 12.04 LTS. After the Sun Microsystems has been acquired by Oracle, we got a new fork of MySQL i.e MariaDB . MariaDB is led by its original developers. MariaDB has XtraDB storage engine for replacing InnoDB .It also has new storage engine…
-
Another MySQL daemon already running with the same unix socket
In this post ,I am sharing the error message ” Another MySQL daemon already running with the same unix socket “. The error found in our own sharadchhetri.com blog while restarting the MySQL server.It is at 6:55 PM IST,I noticed the weird error message on blog,”Error establishing a database connection”.I log into the server and…
-
How to set delay replication in MySQL slave server
In this tutorial we will learn how to set delay replication in MySQL Master Slave replication. After setting this configuration,slave server deliberately lag behind the Master server as per the delay time you have set. The MySQL server version 5.6 has this feature and it has some benefits which will discuss in this post. Set…
-
How to enable logging in Postgresql 9.2 and 9.1
In this post we will learn how to enable logging in Postgresql 9.2 and 9.1.It is a quick method to enable logging in Postgresql 9.2 and 9.1.We will do changes in postgresql.conf file. Path in Postgresql 9.1 : /etc/postgresql/9.1/main/postgresql.conf Path in Postgresql 9.2 : /etc/postgresql/9.2/main/postgresql.conf To enable the log for all queries in Postgresql,follow the…
-
How to configure multiple mysql instance in Ubuntu
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…
-
How to create multiple mysql instance in CentOS 6.4 and Red Hat 6.4
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…
-
Change mysql default port number in linux
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…
