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;"