mysql how to reset passwords with a few commands

The commands below will help you reset any mysql user password.

use mysql;

update user set password=PASSWORD('thenewpass') where User='theusername';

flush privileges;

 

  1. The first line says to use the "mysql" database which contains all the user info.
  2. the second update line sets the new password "thenewpass" for the user "theusername".
  3. the third line flushes privileges this is necessary otherwise the new password will not work or actually be applied.

Tags:

mysql, reset, passwords, commandsthe, commands, user, password, update, thenewpass, theusername, flush, privileges, quot, database, contains, info, flushes, applied,

Latest Articles

  • Linux Ubuntu Cannot Print Large Images
  • Cannot Print PDF Solution and Howto Resize
  • Linux Console Login Screen TTY Change Message
  • Apache Cannot Start Listening Already on 0.0.0.0
  • MySQL Bash Query to pipe input directly without using heredoc trick
  • CentOS 6 and 7 / RHEL Persistent DHCP Solution
  • Debian Ubuntu Mint rc-local service startup error solution rc-local.service: Failed at step EXEC spawning /etc/rc.local: Exec format error
  • MySQL Cheatsheet Guide and Tutorial
  • bash script kill whois or other command that is running for too long
  • Linux tftp listens on all interfaces and IPs by DEFAULT Security Risk Hole Solution
  • python import docx error
  • Cisco Unified Communications Manager Express Cheatsheet CUCME CME
  • Linux Ubuntu Debian Missing privilege separation directory: /var/run/sshd
  • bash how to count the number of columns or words in a line
  • bash if statement how to test program output without assigning to variable
  • RTNETLINK answers: Network is unreachable
  • Centos 7 how to save iptables rules like Centos 6
  • nfs tuning maximum amount of connections
  • qemu-kvm error "Could not initialize SDL(No available video device) - exiting"
  • Centos 7 tftpd will not work with selinux enabled