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…]
A ‘super user’ in this context is set up for convenience and has full access to everything, the same as the MySQL root account.
Instructions for installing MySQL and some helpers.
ERROR 23 (HY000): Out of resources when opening file ‘/tmp/sometable.MYD’ This happened on a fresh Debian Testing install with only MySQL.