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 API Archlinux attiny2313 Authentication AVR Microcontrollers Backup BIND9 Bootstrap C CentOS Citadel CORS Datasheets Debian Design DNS Docker Doctrine ORM Documentation Front-end HD44780 Intel NUC iptables JavaScript LAN LDAP Node JS PHP Postfix Proxy quick post React JS React Native SAML Security Shell Script Storage Styled Components Symfony TDD TypeScript TypeScriptScript USART

All rights reserved – dthlabs.com

Free dark wordpress theme