Return to Snippet

Revision: 36576
at November 23, 2010 11:19 by isholgueras


Initial Code
#From bash
#Stop mysql service
$> service mysqld stop
#Start mysql "for free". Seems dangerous :P
$> mysqld_safe --skip-grant-tables --skip-networking &

$> mysql -uroot
mysql> use mysql;
mysql> UPDATE user SET password=PASSWORD('nuevo_pass') WHERE user='root';
mysql> quit;

$> service mysqld restart

Initial URL


Initial Description
How to reset a root password in mysql with OS root user

Initial Title
Reset root password in MySQL

Initial Tags
mysql

Initial Language
MySQL