MySQL username w/o dbname prefix?

[gecarter53]

When I create MySQL usernames within Bluehost it prefixes a portion of the database_name to the user's username. How can I create a username without the database_name prefix? Eventually, I will want the user to create there own account with a username of their choosing; so they should not have to think to add a prefix to their desired username.

Thanks.

[felgall]

You'll need a VPS or dedicated hosting setup to be able to do that - it can't be done on shared hosting where the prefix is necessary to avoid clashes between names on different accounts.

[wysiwyg]

Why would your users need to create a mysql account?

[gecarter53]

I think your question, answers mine. Users do not need direct access to the database and its tables. If they setup an account or wish to make changes to their accounts, those accounts should be managed by the administrator (using appropriate php/sql coding) who only has access to the database and its tables. I should have thought about this earlier. Live and learn.

Thanks.