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

  • scp: ambiguous target error and solution
  • VirtualBox How To Add iSCSI Storage using VBoxManage
  • iSCSI on Centos 7 Configuration and Setup Guide for Initiator and Target
  • Python and BeautifulSoup4's BS4's Decompose Method To Remove Unwanted Inner Tags
  • httpd AH00534: httpd: Configuration error: No MPM loaded. solution
  • bash script to remove modules from httpd.conf that are not actually installed
  • bash scripting how to create a function
  • Centos 7 PHP MySQL Not Working Solution
  • Bash How To Cut or Split Natively And Get The LAST Field
  • Bash Script How To Manipulate Text/Strings By Searchig and Replacing Natively
  • How Does Cisco CUCM (Cisco Unified Communication Manager) Work?
  • What DNS Options Does Active Directory Offer in Windows Server 2008,2012,2016 ?
  • syntax error, unexpected T_SL in PHP Solution
  • grep regular expression match number range between specific numbers
  • bash how to print out lines of text within a range from the first occurrence
  • bash script how to to check LAN computers for open ports
  • MySQL Using mytop Debug Source of High IO and Slow Performance
  • How To Mathematically Convert and Calculate Binary Value To Decimal Value
  • systemd management using systemctl and journalctl to check systemd logs
  • css how to format code in the code tag