Posts Tagged ‘Mysql’

HowTo: Install MySQL Workbench on RHEL 5.x / CentOS 5.x | x86_64

Hello What is MySQL Workbench ? MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X. Sharing article which will help you […]

Read the rest of this entry »

MySQL: Drop all tables from Database using Script / Linux

Hello, Few days back, I got a task to do, Task was Keep the database as it is, So that we do not have to add database users, privileges and everything again and again, Just Drop all the databases tables inside the database. If there are only few tables like 5 or 10 than it […]

Read the rest of this entry »

Reset / Recover MySQL root Password / MySQL / Linux

Hello, Perform this Howto to Reset / Recover root password of MySQL. There are many cases that we used to forget root password of MySQL, So Perform just few steps and you will able to reset root mysql password. Perform below steps to Recover / Reset MySQL Password. 1. Stop MySQL Service [root@linux-support-ahmedabad-tejas-barot ~]# /etc/init.d/mysqld stop […]

Read the rest of this entry »

Change root password of MySQL

To Change root Password of mysql you can change it by using mysqladmin command. if you want to change or update root password then execute this command mysqladmin -u root -p’oldpassword’ password newpassword For example, If old password is tejas, and set new password to tejasbarot, enter: mysqladmin -u root -p’tejas’ password tejasbarot if you […]

Read the rest of this entry »

Installing,Starting Service & Setting root password of My Sql

First set Yum repository of MySQL then install it by using following command yum -y install mysql-server mysql  or yum -y install mysql*  Starting MySQL Server:- Execute Following Command:- chkconfig mysqld on /etc/init.d/mysqld start or service mysqld restart Setting Up root Password:- mysqladmin -u root password NEWPASSWORD Testing MySQL Connectivity  mysql -u root -p. Enjoy […]

Read the rest of this entry »