Thread: mysql grants

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    1
    Rep Power
    0
    dear all
    i have a dedicated server with mysql installed. on it and around 50 domains
    (ip addressses created) on it.some of them require mysql database
    support.how do i grant them access for creating and managing their databases
    only.i have created a database at root level and then granted permissions
    for a user .i have tried out the grant statement (at root level)taking a
    sample userid but though the grant permission is recorded when i log in as
    that user id and try database manipulation i get an error message 1044 and
    the message :"access denied " for that user.please reply with any
    suggestions to my email only.
    shabbar
    esskay@nagpur.dot.net.in



    ------------------
  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15

    For issueing grants you should login as a root user.

    see the manual .this problem has written their...


    ------------------
    SR -
    shiju.dreamcenter.net

    "The fear of the LORD is the beginning of knowledge..."

Similar Threads

  1. mysql and MS foxpro
    By wijbenga in forum MySQL Help
    Replies: 16
    Last Post: February 5th, 2004, 11:46 AM
  2. mysql connection
    By cindyqz in forum Java Help
    Replies: 0
    Last Post: August 25th, 2003, 07:33 PM
  3. mysql database help!
    By TweetyPie in forum MySQL Help
    Replies: 2
    Last Post: August 1st, 2003, 06:20 AM
  4. ODBC mySQL Connection Problem
    By kjedwards in forum MySQL Help
    Replies: 1
    Last Post: October 7th, 2001, 03:50 PM

IMN logo majestic logo threadwatch logo seochat tools logo