Are the Gateway and MySQL running on the same system? If not you need to grant permission for a root user from elsewhere to create the database. With the appliance, the only place where root can access the databaseis from localhost:
[root@ssg100 ~]# mysql mysql -e 'SELECT user,host FROM user WHERE user="root"\G'
*************************** 1. row ***************************
user: root
host: localhost
[root@ssg100 ~]# mysql mysql -e 'SHOW GRANTS FOR root@localhost\G'
*************************** 1. row ***************************
Grants for root@localhost: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `root`@`localhost` WITH GRANT OPTION
*************************** 2. row ***************************
Grants for root@localhost: GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,GROUP_REPLICATION_ADMIN,INNODB_REDO_LOG_ARCHIVE,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,XA_RECOVER_ADMIN ON *.* TO `root`@`localhost` WITH GRANT OPTION
*************************** 3. row ***************************
Grants for root@localhost: GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
[root@ssg100 ~]#
For a software gateway, where you are responsible for the MySQL configuration, make sure that you can access the database as root from your system.
Also, are you certain you have the correct root password for mysql?
------------------------------
Jay MacDonald - Adoption Architect - Broadcom API Management (Layer 7)
------------------------------
Original Message:
Sent: 02-15-2021 03:47 AM
From: Ruben deLuz
Subject: Configure the Gateway Application (Software) API GATEWAY 9.2
Good Morning Jay! First of all, thanks for replying. The one who creates the database is the root user of mysql. Below I attach an image of the configuration data entered. I don't know what I can be doing wrong... Thank you so much!! (My computer ip is: 192.168.117.138)
Original Message:
Sent: 02-12-2021 05:09 PM
From: Jay MacDonald
Subject: Configure the Gateway Application (Software) API GATEWAY 9.2
The gateway user should not be able to create a database. Use a MySQL administrative user, typically root (which is different from the OS root).
------------------------------
Jay MacDonald - Adoption Architect - Broadcom API Management (Layer 7)
Original Message:
Sent: 02-10-2021 04:53 AM
From: Ruben deLuz
Subject: Configure the Gateway Application (Software) API GATEWAY 9.2
Hi! I'm trying to configure the Gateway Application (Software, Gateway Currently Unconfigured). When I do step 2 (Configure the CA API Gateway) and I enter all the required data, it tells me this at the end: 'An error occurred during configuration. Error creating database when saving configuration 'Unable to create database'. The gateway user has all the grants. Why is this happening? Thank you.