Resettare la password di Mysql: Difference between revisions

From RVM Wiki
Jump to navigation Jump to search
m 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...
 
(No difference)

Latest revision as of 16:47, 27 May 2010

  • 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