EDIT: I've replicated this & hopefully it is fixed. See following post.
Strange, I've gone into the code to fix this but found I cannot replicate it; both MySQL versions do have a root password set, in my tests.~~
Clearly this isn't the case for several users, so I'm hoping that you guys might be able to help me discover under which circumstances MySQL is being set up without the root password.
On first installation of a new MySQL service, Indigo should run
1-users-databases.sql found at
~/.indigo/stacks/STACKUUID/mysql_ID/init/1-users-databases.sql. You can get there by right-clicking the MySQL service in the rack in Indigo and choosing "Show Compiled in Finder...". Could you please check that file and confirm it contains the following line?
SET PASSWORD FOR 'root'@'localhost' = 'password';