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

New Topic

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

Posted by: Roberto Ezequiel Garcia Ballesteros
Date: June 03, 2013 09:47AM

Hi Roy!

You can use any MySql client to create the user and access privileges (see the links for reference):

http://dev.mysql.com/doc/refman/5.6/en/user-account-management.html

Programmatically is exactly the same: create and open a connection to the server (MySqlConnection), create user management statements using a MySqlCommand (see the link below), and for last, call the ExecuteNonQuery method for each sql statement. This way you create the user(s) and privileges.

Regards.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

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

Roy Wilkinson

June 01, 2013 11:42PM

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

Roberto Ezequiel Garcia Ballesteros

June 03, 2013 09:47AM

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

Roy Wilkinson

June 03, 2013 05:49PM

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

Roberto Ezequiel Garcia Ballesteros

June 04, 2013 10:56AM

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

Roy Wilkinson

June 04, 2013 02:25PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.