none
can I use root in MySQL? RRS feed

  • Question

  • Hi,

    I have a Windows Form application which connects to MySQL database.

    In connection string, do you recommend to use the root as user or create a different user or have a separate MySQL user for every user in the company?

    and does it make any difference in performance and security of my .NET WinForm application?
    Wednesday, June 12, 2013 10:23 AM

Answers

  • You probably just need two accounts.  One that has special admin priviledges and one for general users.  The reason to have different accounts is to have different priviledges for differrent users.  If your company uses Group Policies you could set up and an account that limits access based on Group Policies.  You can do this by setting up a Windows User Account on the server that allows users with specific Group Polices to login.  Then setup a MYSQL priviledges that allows gives proiviledges to the new user account that you setup on the server.

    jdweng

    Wednesday, June 12, 2013 3:24 PM