Not sure if anyone else is having the same issue, but the current method of managing the MySQL users and database permissions is a little confusing and non-intuitive. Not only to the server admin but to the end user as well.
The way it is now
You first click on "Edit Users" - OKAY
Then it takes you to a screen that is entitled "Mail and FTP Users" - CONFUSING
You only have two choices "Add a user to this server." or "Add a website FTP access user." - Hmm.. I am not exactly sure what to tell the customer.
You are taken to a screen that appears to give the impression that you are in the wrong place. All I want is a MySQL user created, most of the fields refer to either mailbox settings or FTP settings. Turns out you are creating a Unix user account for MySQL access. - VERY BAD
Hidden away at the bottom is a section "Other user permissions".
Now you must choose from either "Email, or Email and FTP, or FTP Only" depending on which link you clicked. - HUH?
Underneath that, you have the first mention of MySQL. A box that lets you assign MySQL database permissions to the user you created.
The way it should be
You first click on "Edit Users"
A screen that is entitled "Mail, Database, and FTP Users"
Click "Add MySQL user"
A screen that asks for a username and password
A box that lets you assign MySQL database permissions to the user you created.
Done, no Unix user account needed.