Re: How do I create a new database and then restrict access to a particular user. (Programmatically, of course.)

[Roy Wilkinson]

Thank-you for your response. A bit more background may help.

The scenario I am looking at takes place on 'localhost'. A user runs an app and asks to create a new database (that the user/app will then use in the future). The user also provides a (MySQL) user ID and password. How do I ensure that the ID/password is valid and has appropriate rights? To establish a connection, it appears I need to specify a database, but in this case the database hasn't been created yet and specifying the to-be-created database name fails.

I see commands for managing accounts, but have failed to find info on how to check account validity or account rights. I'm probably missing something obvious, but missing it nonetheless.

I look forward to being enlightened. [And thank you, in advance for any help you may provide.]

Regards,

- Roy