Resettare la password di Mysql

From RVM Wiki
Revision as of 16:47, 27 May 2010 by Gabriele.vivinetto (talk | contribs) (New page: * Fermare mysql * Lanciarlo così mysqld_safe --skip-grant-tables & * Collegarsi e impostare la password: mysql -u root use mysql; update user set password=PASSWORD("NEW-ROOT-PASSWOR...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
  • Fermare mysql
  • Lanciarlo così
mysqld_safe --skip-grant-tables &
  • Collegarsi e impostare la password:
mysql -u root
use mysql;
update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
flush privileges;
quit
  • Fermarlo