The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

pHpMyAdmin problems

Discussion in 'Database Discussions' started by rip_curl, Dec 7, 2005.

  1. rip_curl

    rip_curl Well-Known Member

    Joined:
    Jan 30, 2005
    Messages:
    81
    Likes Received:
    0
    Trophy Points:
    6
  2. nickp666

    nickp666 Well-Known Member

    Joined:
    Jan 28, 2005
    Messages:
    770
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    /dev/null
    End users cannot create mysql databases from phpmyadmin, you have to create them in Cpanel's MySQL Databases Panel
     
  3. rip_curl

    rip_curl Well-Known Member

    Joined:
    Jan 30, 2005
    Messages:
    81
    Likes Received:
    0
    Trophy Points:
    6
    But he can't create tables in database, too.
    Database he has created by Cpanel's MySql
     
  4. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    The screenshot you've included appears to show phpMyAdmin just after logging in. It is not from this screen that you can create tables, as the relevant database must be first selected.

    If you want to create a table:

    1) Log in to phpMyAdmin
    2) Select the database from the left-hand drop-down menu
    3) Look at the bottom of the right-hand frame
     
  5. anup123

    anup123 Well-Known Member

    Joined:
    Mar 29, 2004
    Messages:
    897
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    This Planet
  6. directhostinguk

    Joined:
    Jun 13, 2006
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Bishop's Stortford UK
    Sorry to start this old thread again. My problem is users are able to create databases through phpmyadmin, when they shouldn't be able to.

    How to I correct, what permissions are set wrong.
     
  7. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    IIRC, it's:

    /scripts/cleanupmysqlprivs
     
Loading...

Share This Page