Copiar y pegar: recuperar password de root de mysql en linux

February 27th, 2008 by admin Leave a reply »

Copia y pega para recuperar la contraseña de root de mysql

newpassword="2";
/etc/init.d/mysql stop
/usr/bin/mysqld_safe --skip-grant-tables --user=root &
sleep 5
mysql -u root mysql -e "update user set password=PASSWORD('$newpassword') where user='root'; flush privileges; ";
/etc/init.d/mysql restart
  • Share/Bookmark

Posted in Artículos, knowledge base

You can follow any responses to this entry through the RSS 2.0 Feed. You can leave a response , or trackback from your own site.

Advertisement

Leave a Reply