Reset root password on MySQL

Start MySQL server without user authentication and networking, this allows to connect without credentials from localhost only. Run using┬áthe same user account the MySQL daemon runs under to avoid permission problems (probably, sounds reasonable doesn’t it?) Connect to MySQL with no credentials: Reload authentication: Change root password: MySQL 5.7.6 and later: MySQL 5.7.5 and earlier: … [Read more…]