Home » Archive by categoryMsyql

How to install and Configure MariaDB on Centos 6

MariaDB is a community-developed branching of the MySQL relational database management system, the impulse being the community fixing of its free status under the GNU GPL. Being a branch of a leading open source application system, it is famous for being led by its original developers and induction...
Continue reading

How to install and configure MySQL workbench on linux system

Install mysql workbench 5.6 MySQL Workbench is a combined and most useful visual tool for developers, database architects, and database administrators. MySQL Workbench provides data modeling, data designing SQL development, and wide-ranging administration tools for server configuration, user administration, data backup, and other useful tools. MySQL Workbench is...
Continue reading

InnoDB engine status showing disabled in Mysql

The InnoDB by default enabled. But sometime it automatically disabled due to uncleanly shutdown or any other reasons. To view the Innodb status in mysql. #mysql -u root -p mysql> show engines; InnoDB |DISABLED 1. To resolve the problem append the below line in my.cnf file. #skip-innodb then...
Continue reading

Recover MySQL root password

If you forgot your root mysql password this tutorial with help you to recover the root user passord Stop the MySQL server process. #service myql stop Start again with no grant tables. #mysqld_safe –skip-grant-tables & Login to MySQL as root. Set new password. # mysql -u root mysql>...
Continue reading

Categorized Tag Cloud