Mysql 8

soniktrooth

I haven't been able to get mysql 8 working. 5.7 seems to work fine but when I try to use 8 I can't connect via Sequel Ace.

I get:

Access denied for user 'root'@'localhost' (using password: NO)

I'm definitely using the correct port.

Indigo

Oops, you've helped me realise I haven't actually documented the fact the required credentials are root and password. They're in the MySQL config UI in the next release. Thanks!

stefanvaduva

in Version 1.0.0-beta.8 (93) MySQL 8 doesn't have a root password, although the interface says that the root user has a password set.

Indigo

@stefanvaduva Ah, that explains one of my tests. Thanks for the heads-up! I'lll get that fixed.

Indigo

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';

Indigo

I believe MySQL 8.x has changed how it handles empty passwords when the --skip-password argument, which highlighted an oversight in my code. I've since refactored the whole initialisation process for MySQL services, as well as how & when they run the user & DB setup script.

I'm hoping the initial issue here is now resolved. Please check for the Indigo update which should be released later today (Indigo menu > Check for updates...) then rebuild any stacks that have existing MySQL services (right-click the stack and choose Rebuild...)