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

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