MySQL 8 removes shorthand for creating user with permissions

[skupjoe]

After switching to MySQL 8, I am seeing this sort of error during /opt/setup/50-icinga2 which prevents initialization:

ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY '<PASS>'' at line 4

It looks like the shorthand syntax of assigning users + permissions in the same SQL declaration is no longer supported:
https://ma.ttias.be/mysql-8-removes-shorthand-creating-user-permissions/

[jjethwa]

Thanks for the heads up, @skupjoe

The PR #244 was closed by you, can you re-open and let me know when ready?

[skupjoe]

PR #245 opened

[jjethwa]

Thanks @skupjoe
Merged and available in latest. Looks good to me, let me know how it works for you

[skupjoe]

Yup working well. MySQL8 on AWS RDS + Icinga 2.12.0

(Also, looks like 2.12.1 was just released)

[jjethwa]

Great, thanks, @skupjoe

I'll tag 2.12.1 and release it as it has your changes already 😄