How to reset mysql root password? -
How to reset mysql root password? - i have little problem phpmyadmin, in fact accidentally delete multiple user accounts. since impossible connect without error: # 1045 - access denied user 'root' @ 'localhost' (using password: no) i have search little on net before, , technic: update mysql.user set password = password ('') user = 'root'; flush privileges; does not work, or didn't understood how worked. i'm on freebsd 8.1, version of phpmyadmin 2.11. thank in advance answers. i summarised solution here: http://snippets.dzone.com/posts/show/13267 sudo stop mysql sudo mysqld --skip-grant-tables --skip-networking mysql mysql> update mysql.user set password = password('your_new_password') user = 'root'; mysql> flush privileges; mysql> exit; sudo mysqladmin shutdown sudo start mysql mysql mysql-error-1045