mysql> update user set Password=PASSWORD('cyphoroz') WHERE User='root';
Query OK, 3 rows affected (0.01 sec)
Rows matched: 3  Changed: 3  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye
root@granada:~# fg
/usr/bin/mysqld_safe --skip-grant-tables
Warning;  Aborted waiting on pid file: '/var/run/mysqld/mysqld.pid' after 1 seco                                            nds
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysq                                            ld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock'                                             exists!
STOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld_safe[8610]: ended
root@granada:~# /etc/init.d/mysql start
 * Starting MySQL database server mysqld                                 [ OK ]
 * Checking for corrupt, not cleanly closed and upgrade needing tables.
root@granada:~# mysql --user=root --pass=cyphoroz
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y                                            ES)
root@granada:~#