Reset the MySQL ROOT Password in Ubuntu 16.04
Reset the MySQL ROOT Password in Ubuntu 16.04 (Tested in ysql-server-5.7): sudo /etc/init.d/mysql stop sudo mkdir /var/run/mysqld/ sudo chown mysql /var/run/mysqld/ sudo mysqld_safe --skip-grant-tables & sudo mysql -u root use mysql; update user set authentication_string=PASSWORD("New_Passwore_Here") where User='root'; flush privileges; exit; sudo /etc/init.d/mysql stop sudo /etc/init.d/mysql start