Ubuntu change MySQL Password

Sudo/etc/init.d/mysql stop

sudo mysqld_safe--user=mysql--skip-grant-tables--skip-networking

Mysql-uroot-p

Enter your own MySQL password

mysql> use MySQL;
Reading table information for completion of table and ColumnNames
Can turn off this feature to get a quicker startup with-a

mysql> Update user Set Password = Password (' root ') Whereuser = ' root ';
Query OK, 3 Rows Affected (0.00 sec)
Rows Matched:3 Changed:3 warnings:0

"Attention!!" The root inside the parentheses is changed to the actual password "

Mysql> exit;

Sudo/etc/init.d/mysql restart

Ubuntu change MySQL Password