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

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

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 implement Log File Rotation in Linux Servers

NB: We are using CentOS Servers Switch to root user cd /etc/logrotate.d/  (by default we will be having this directory in our server) create a new file project-logs   vi project-logs Add the following piece of code to this file             /folder-path-of-your-log/*.log {                size=10M                missingok                rotate 20                compress                delaycompress                notifempty                copytruncate               daily           }       5.   logrotate -f /etc/logrotate.d/        This will create new log ...
Read more