The user's login and password will be the same as those they would use for FTP or IMAP. By default, they will be granted full access to all tables in the selected databases.
MySQL only supports usernames up to 16 characters long, so for a user with a long account name only the first 16 characters are needed when logging in to the database.