Tuesday, December 31, 2013

Ubuntu: How to turn off skip-grant-tables option in Mysql

I wanted to change mysql root password so mistakenly changed skip-grant-tables option.

Below is how to revert it back:

1. Kill mysqld process and restart mysql service

command: sudo killall -9 mysqld

How to create new Public Key in Ubuntu

You can create public key in Ubuntu using below command:

keygen-ssh -t rsa

Keep pressing Enter whenever it asks for Input.

Using Public key:
1. go to .ssh folder

$cd .ssh

2. open id_rsa.pub file using vim and copy it.

$vi id_rsa.pub