Vesta Control Panel - Forum

Is there a way to create a database with access for an existing database user? I don't really want to have to create/manage a user for ever database created. CPanel and some other web panels make it easy to associate users with databases without having to use MySQL.

I discovered if I create another database using an existing database username, that user will have permissions added for the new database. However, it also requires me to enter the password again so there is a potential of overwriting the existing password which may not be desireable.

IMHO there should be an option to create a database using an existing user separate from creating a database while creating a new user. That could also prevent inadvertently overwriting the password of an existing database user.

you might also want to try what is happening if you remove one of those databases. my guess would be your db user is getting removed as well, which may break things for the second database and so on...

Yea, good point. But a user database seems akward. For a aingle site which might have CMS, e-commerce, forums, etc. Why force a database user for each database?