$ sudo /etc/init.d/mysql stop * Stopping MySQL database server mysqld [ OK ] [1]- Exit 1 sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking [2]+ Exit 1 sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking reg@regDesktopHome:~$ sudo mysqld --skip-grant-tables & [1] 13651 reg@regDesktopHome:~$ 140627 19:02:02 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. reg@regDesktopHome:~$ mysql -u root mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) reg@regDesktopHome:~$ sudo mysql -u root mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) [1]+ Exit 1 sudo mysqld --skip-grant-tables $ ps ax| grep mysql 16515 ? Ssl 0:00 /usr/sbin/mysqld 16551 pts/23 S+ 0:00 grep --color=auto mysql reg@regDesktopHome:~/semios/v3upgrade$ sudo kill -9 16515 reg@regDesktopHome:~/semios/v3upgrade$ ps ax| grep mysql 16678 ? Ssl 0:00 /usr/sbin/mysqld 16715 pts/23 S+ 0:00 grep --color=auto mysql reg@regDesktopHome:~/semios/v3upgrade$ mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) mysql -u root -p apt-cache policy mysql-server Installed: 5.5.37-0ubuntu0.12.04.1 sudo dpkg-reconfigure mysql-server-*.* mysql -u root -p sudo service mysql stop sudo killall -9 mysqld sudo mysqld_safe --skip-grant-tables --skip-networking & mysql -u root FLUSH PRIVILEGES; UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root'; UPDATE mysql.user SET authentication_string=PASSWORD('newpwd') WHERE User='root'; FLUSH PRIVILEGES; exit sudo killall mysqld_safe && sudo service mysql start mysql -u root -p Enter password: newpass mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'test'; UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'; FLUSH PRIVILEGES; mysqld_safe --init-file=/home/me/mysql-init & sudo service mysql stop sudo mysqld_safe & sudo mysql -u root ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass'; FLUSH PRIVILEGES; QUIT; sudo killall mysqld sudo service mysql start sudo mysql -u root -p