how to Create a MySql Database with all permissions?

Discussion in 'MySQL' started by jdock1, Sep 7, 2008.

0
  1. #1
    How do I grant a mysql database full priveleges/permissions? Using phpmyadmin.

    I need to know this so I can install this script, phpmyadmin is so damn confusing
     
    jdock1, Sep 7, 2008 IP
  2. live-cms_com

    live-cms_com Notable Member

    Messages:
    3,128
    Likes Received:
    112
    Best Answers:
    0
    Trophy Points:
    205
    Digital Goods:
    1
    #2
    I thought it gives permissions automatically.
     
    live-cms_com, Sep 7, 2008 IP
  3. jdock1

    jdock1 Peon

    Messages:
    344
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thats what i thought but the script isnt working.
     
    jdock1, Sep 7, 2008 IP
  4. live-cms_com

    live-cms_com Notable Member

    Messages:
    3,128
    Likes Received:
    112
    Best Answers:
    0
    Trophy Points:
    205
    Digital Goods:
    1
    #4
    Are you sure it's not an error in the script? Or that you have your host, username or password wrong? Or that you have to CHMOD something?

    I doubt the problem is MySQL permissions.
     
    live-cms_com, Sep 7, 2008 IP
  5. Jalpari

    Jalpari Notable Member

    Messages:
    5,640
    Likes Received:
    137
    Best Answers:
    0
    Trophy Points:
    260
    #5
    login into cpanel > my sql database > create db name > create user name and password > select write db and user then check all priviliges > and ur job is finish.
     
    Jalpari, Sep 8, 2008 IP
  6. shipumh

    shipumh Active Member

    Messages:
    44
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    61
    #6
    how to chmod the folder and contents?
     
    shipumh, Apr 27, 2010 IP