Reset Master (root) MySQL Password -- Digital Ocean

.1. mysql.reset.sh

service mysql stop
mkdir -p /var/run/mysqld
chown mysql:mysql /var/run/mysqld
/usr/bin/mysqld_safe --skip-grant-tables --skip-networking &
# do the reset.sql stuff...
killall mysql ## ps ax|grep mysql -- you may have to list them with this and manually kill them!! :)
service mysql start

.2. reset.sql

flush privileges;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'mypassword';
flush privileges;
exit

.3. .my.cnf

# in ~/.my.cnf
[client]
user=root
password=mypassword
# now I can log in with just `mysql`