Recover MySQL Password

Linux January 28th, 2010

#/etc/init.d/mysql stop
#mysqld_safe –skip-grant-tables &
#mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD(’passwd-baru’) where User=’root’;
mysql> flush privileges;
mysql> quit
#/etc/init.d/mysql stop
#/etc/init.d/mysql start
#mysq -u root -p

Sumber:

http://harba.polsri.ac.id/?p=27

http://www.debianhelp.co.uk/mysqlroot.htm

mysqld_safe –skip-grant-tables &
Share:
  • Print
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • email
  • Ping.fm
  • Twitter

Tags: ,



Leave a Comment

CommentLuv Enabled