Reusing a mysql database user on a new database caused Jira startup to fail with table not found error

A new install of Jira fails to start due to missed tables.

Steps to Reproduce

• Environment:
  MySql 8.0
  JDBC 22
  Jira 8.16.1 binary install

• Create a new database
• grant permission to an already existent user
• Run config.sh to configure jira_home location and configure JDBC connection
• Test connection -> It will be successful
• Start Jira

What was expected

Jira install and enter the setup mode

What had happened instead

Jira did not enter the setup mode and fail as the database is empty (can not find tables)

Workaround

• Delete all content of Jira home folder
• Drop Database, create new user, create new DB, and grant access:

  drop database jiradb816;
  create user 'jira-816'@'localhost' IDENTIFIED BY 'jira-816';
  CREATE DATABASE jiradb816 CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
  GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on jiradb816.* TO 'jira-816'@'localhost';
  flush privileges;