Adding databases and users is not very convenient to perform from the control panel, especially with a large number. This can be simplified using the api.
At the time of this writing, to console has access at all tariffs except "AFFORDABLE".
You can connect to the hosting to execute commands using the "Security - SSH Access" key or from the "Advanced - Terminal" web interface itself.
Create a user and specify a password for it:
uapi Mysql create_database name="userprefix_DBname"
Adding a database to a user:
uapi Mysql create_user name="userprefix_DBuser" password="yourpassword"
You need to change the data to yours:
uapi Mysql set_privileges_on_database user="userprefix_DBuser" database="userprefix_DBname" privileges=ALL PRIVILEGES
userprefix - user prefix (your login)
DBname - database name
DBuser - username to connect
yourpassword - the password for the new mysql user
When using a simple password, you may get an error:
This system does not allow the given password for “MySQL Users” because it is too weak and would be too easy to crack. Please select a password with strength rating of 65 or higher.
Run the command again specifying a more strong password.