MySQL密碼丟了,如何找回?
shell> mysqld_safe --skip-grant-tables &
啟動數據庫服務
shell> mysql -uroot -ppassowrd -e "use mysql;update user set
passowrd = PASSWORD('newpassword') where user = 'root';flush
privileges;"
shell> mysqld_safe --skip-grant-tables &
啟動數據庫服務
shell> mysql -uroot -ppassowrd -e "use mysql;update user set
passowrd = PASSWORD('newpassword') where user = 'root';flush
privileges;"