Archive for August, 2013

MySQL: Change root password

Wednesday, August 7th, 2013

1) Kill mysqld
2) Start like that.

sudo mysqld --skip-grant-tables --skip-networking &

3) Type “mysql”

UPDATE mysql.user SET Password=PASSWORD('pwd') WHERE User='root';
FLUSH PRIVILEGES;

4) Kill mysqld and restart it with “sudo service mysqld start”

Source: MYSQL doc