How to reset MySQL Root password

  1. service mysqld stop (To stop the currently running MySQL instance)
  2. mysqld_safe --skip-grant &   (To enter into MySQL in safe mode)
  3. use mysql;
  4. update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';  (To set the new root password)
  5. service mysqld restart (To restart the MySQL instance)


Comments

Post a Comment

Popular posts from this blog

Ruby on Rails Installation on Windows 7

Image
Get Ruby and the Development kit from here (this is one click installer) by default you install Ruby and Ruby Gems Next is to set the system environment variable. Quickest way: Open the control panel, search for 'environment', then click ' edit the system environment variables ' , and add the bin(c:\Ruby 187\bin) after a semicolon to the 'Path' variable.          Now type ruby -v in cmd prompt, you could see the ruby version installed. Our next aim is to install Rails. use gem install rails --include-dependencies . Check your rails version too rails -v . You could see the latest rails version installed. Installing Rmagick and ImageMagick. Download the rmagick-win32 package (zip file) . Install the gem by going into the directory it’s extracted into and then executing this: gem install rmagick-2.10.0-x86-mswin32.gem Then install ImageMagick itself, with the .exe that you just extracted as well. Getting started with a samp...
Read more

How to SSH to remote server without entering password each time.

ssh -copy-id  example_user@www.example.com and give password once. Then you will be able to ssh without password next time onwards. Make sure you have a ssh key generated in your local machine. This works for Linux only (not Mac, Windows etc.) For Mac you need to first setup ssh-copy-id command & then copy the ssh key sudo curl https://raw.githubusercontent.com/beautifulcode/ssh-copy-id-for-OSX/master/ssh-copy-id.sh -o /usr/local/bin/ssh-copy-id sudo chmod +x /usr/local/bin/ssh-copy-id ssh-copy-id -i /path/id_rsa.pub example_user@www.example.com   Now you have your ssh-key copied to your server. You can now try your normal ssh login command without entering password
Read more