When going through the initial setup and configuration of a software gateway installation the following error is generated:
Error creating database when saving configuration 'Unable to create database'
CA API Gateway Software Form Factor 10.x
There were no errors generated in the mysqld.log or the gateways config.log to help determine the cause of the problem.
As we were dealing with a software gateway install the installation and configuration of mysql was performed by the end client. Looking at the mysql configuration we could see that the validate password plugin was installed.
Executing a mysql query along the following showed that a password length of at least 8 characters was required for user accounts.
show variables like 'validate_password%';
After making sure that the mysql gateway user account being used for the setup had a password length which was at least 8 characters long, we could then complete the setup and the ssg database was created successfully.