Rutger's Weblog

Als je niet meer in de mysql database kan:

Stappenplan:

1. Stop de mysqlserver (bv /etc/init.d/mysql stop)
2. Start de mysqlserver mbv save_mysqld –skip-grant-tables
3. Start mysql en update de user tabel:update user SET Password = PASSWORD(‘hetwachtwoord’) WHERE Host=’localhost’ AND User=’root’;
4. Kill de mysql processen: killall mysqld
5. Start de server opnieuw: /etc/init.d/mysql start)

En vergeet het wachtwoord nooit meer…

This entry was posted on Tuesday, June 20th, 2006 at 11:11 am and is filed under Mysql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.