Changed root password from '' to ''. Now cannot connect to databases in Cloud SQL prompt I changed the root password using Google APIs SQL Prompt from blank to  using:

UPDATE mysql.user SET password = PASSWORD('&lt;password&gt;') WHERE user = 'root';


It has been documented here that SQL prompt and some other APIs Services will lose functionality when a password is set on root. (Thanks for Hasturkun's comment below).

How then do we reset the password to &lt;blank&gt;?
Login to MySQL using current password and then you can change password like this

mysql&gt; SET PASSWORD FOR root@'localhost'=PASSWORD('');
Query OK, 0 rows affected (0.00 sec)


Now you can login MySQL using BLANK password.

This is not the most secure way to change password for better approach please have a look at How to Reset the Root Password.