Install Mysql plugin for ruby on rails

Installing Mysql Plugin for ruby on rails .
requirements
*) Install Mysql ,Mysql-development module, mysql client through apt-get , yum or up2date

Next intall mysql plugin using gem command

desktop:~# gem install mysql -- --with-mysql include=/usr/include/mysql --with-mysql-lib=/usr/lib/mysql --with-mysql-config --no-rdoc --no-ri
Bulk updating Gem source index for: http://gems.rubyforge.org
Select which gem to install for your platform (i486-linux)
1. mysql 2.7.3 (mswin32)
2. mysql 2.7.1 (mswin32)
3. mysql 2.7 (ruby)
4. mysql 2.6 (ruby)
5. mysql 2.5.1 (ruby)
6. Cancel installation
> (Enter option as require )


Thats it.... Now you can able to connect the mysql through ruby.

resetting the mysql root password

to reset the mysql root password.

login as the root and follow the steps

service mysql stop

wait until MySQL shuts down. Then run

mysqld_safe --skip-grant-tables &

then you will be able to login as root with no password.

mysql -uroot mysql

In MySQL command line prompt issue the following command:

UPDATE user SET password=PASSWORD("abcd") WHERE user="root";
FLUSH PRIVILEGES;

At this time your root password is reset to "abcd" and MySQL will now
know the privileges and you'll be able to login with your new password:

mysql -uroot -pabcd mysql


Enjoy .............