Recent Posts
- January 2012
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- July 2007
Recent Comments
- Makendra It's always a pleasure to hear from someone with eexrpitse....
- Rubén Ortiz Hola dependerá de varias cosas pero la respuesta sería NO. ...
- jose miguel perea Buenos días, ¿La replicación entre maestro y esclavo es i...
- Rubén Ortiz Si lo hacéis legal, con VMware el único problema son los cos...
- Angel Hola, estamos valorando implementar baremetal para crear un ...
MySQL – Recuperar password root
Me dejo anotado esto, que nunca se sabe. Mejor no tener que utilizarlo nunca.
1 2 3 4 5 | <strong> # /etc/init.d/mysql stop # /usr/bin/mysqld_safe --skip-grant-tables & # mysql -u root </strong> |
NOTA: un día intente ejecutar este paso, y me daba problemas al utilizar el &. Quité el & y abrí otra terminal para seguir con la operación.
Accedemos dentro de la consola como root y ahora actualizamos el password
1 2 3 4 5 | # Welcome to the MySQL monitor. Commands end with ; or \g. # Your MySQL connection id is 24 # Server version: 5.0.48 Source distribution # Type 'help;' or '\h' for help. Type '\c' to clear the buffer. # mysql> use mysql; |
1 2 3 4 | # mysql> update user set password=PASSWORD("nuestroNUEVOpassword") where User='root'; # mysql> flush privileges; # mysql> quit |
Paramos e iniciamos el servicio y nos logueamos ya con el nuevo password.
1 | <strong># /etc/init.d/mysqld stop</strong> |
1 2 | STOPPING server from pid file /var/run/mysqld/mysqld.pid 080819 15:34:49 mysqld ended |
1 | <strong># /etc/init.d/mysqld start</strong> |