Skip to content

dthlabs.com

Menu
  • Home
  • Programming
  • Linux
  • About
  • Labs

Tag: MySQL

How to quickly reset mysql’s root password

August 21, 2013July 21, 2017 dthLeave a comment

ps aux | grep mysql

/usr/sbin/mysqld –skip-grant-tables &

UPDATE mysql.user SET Password=PASSWORD(‘NeWPaSSwOrD’) WHERE User=’root’;

FLUSH PRIVILEGES;

 

——

EDIT:

try this:

mysqladmin -u root password NEWPASSWORD

Updated: July 21, 2017
Categories: ProgrammingTags: MySQL

Archives

  • [+]2020
    • [+]November
    • [+]October
    • [+]September
    • [+]July
    • [+]June
    • [+]January
  • [+]2019
    • [+]July
    • [+]April
  • [+]2018
    • [+]November
    • [+]June
    • [+]January
  • [+]2017
    • [+]November
    • [+]August
    • [+]July
    • [+]June
    • [+]May
    • [+]April
    • [+]March
    • [+]February
    • [+]January
  • [+]2016
    • [+]December
    • [+]November
    • [+]October
    • [+]September
    • [+]August
    • [+]June
    • [+]May
    • [+]April
    • [+]March
    • [+]February
    • [+]January
  • [+]2015
    • [+]September
    • [+]July
  • [+]2014
    • [+]December
    • [+]November
    • [+]October
    • [+]September
    • [+]August
    • [+]May
  • [+]2013
    • [+]August
    • [+]May
    • [+]March
    • [+]February
    • [+]January
  • [+]2012
    • [+]December
    • [+]November
    • [+]October
    • [+]September
    • [+]August
    • [+]July
    • [+]June
    • [+]April

Categories

  • Dev
  • Devops
  • Drupal
  • Electronics
  • Linux
  • Programming
  • Security
  • Telecom
  • Uncategorized

Tags

555 timer IC Apache Archlinux attiny2313 AVR Microcontrollers Awesome WM Backup Bitcoin C CentOS Citadel Datasheets Debian Design Docker Drupal Email Front-end Games GIMP Groupware HD44780 iptables LAMP LDAP LibreOffice Linux media MySQL PHP Postfix Proxy quick post React JS SAML Security Shell Script slax SQL Storage Styled Components Symfony TypeScript USART vim

All rights reserved – dthlabs.com

Free dark wordpress theme