www.webdeveloper.com
Results 1 to 6 of 6

Thread: How to create database users, etc

  1. #1
    Join Date
    Sep 2004
    Location
    Sri Lanka
    Posts
    470

    How to create database users, etc

    Hi,

    Can someone pls let me know how to create MySQL users and assign users to created databases.

    Ideally with plain SQL queries, instead using CPanel scripts etc.

    Thank you.

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,337
    Just in case: be aware that many web hosting plans to not allow you to create users via scripts: you have to use whatever control panel mechanism they give you for doing so. But if that is not an issue for you, see:

    Account Management Statements
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

  3. #3
    Join Date
    Sep 2004
    Location
    Sri Lanka
    Posts
    470
    Thanks for the reply and as you said, it seems to be blocked by the web host.

  4. #4
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,337
    Quote Originally Posted by GUIR View Post
    Thanks for the reply and as you said, it seems to be blocked by the web host.
    Yeah, what they normally do is only grant permissions for creating databases and users to the MySQL user that their control panel tool uses -- no other DB users can be given those permissions. It can be a bit of a pain, but it is probably a good security configuration, especially in any sort of shared hosting situation where multiple site users are using the same DB host.
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

  5. #5
    Join Date
    Sep 2004
    Location
    Sri Lanka
    Posts
    470

  6. #6
    Join Date
    Jan 2011
    Posts
    2
    Here is the simple method of create users by command line..just follow instructions.
    http://dev.mysql.com/doc/refman/5.5/...ing-users.html

    Database Development Resources

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles