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.

Editing Content of Table Cells

Discussion in 'Database Discussions' started by fivethirty, Apr 2, 2015.

  1. fivethirty

    fivethirty Member

    Joined:
    Apr 2, 2015
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    New York City
    cPanel Access Level:
    Website Owner
    How can the contents of the table in a MySQL database be edited (changed manually) or, say, individual rows of the table be deleted, using cPanel? This instruction explains many things about cPanel but doesn't seem to explain how the individual cells are handled: https://documentation.cpanel.net/display/1144Docs/MySQL+Databases
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,452
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
  3. fivethirty

    fivethirty Member

    Joined:
    Apr 2, 2015
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    New York City
    cPanel Access Level:
    Website Owner
    Thanks, @Infopro. Can't find config.inc.php in any of the folders. Any idea?
     
  4. fivethirty

    fivethirty Member

    Joined:
    Apr 2, 2015
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    New York City
    cPanel Access Level:
    Website Owner
    OK, I got it. I have to create it myself and place it in etc by just including that line of code allowing editing? Is that correct?
     
  5. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,452
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    No clue what you're up to. If I had a database with something in it that I wanted to edit manually, I'd open phpMyAdmin from within my cPanel, find the table, content, and edit as I needed.

    I'm assuming that's your goal here too. But then you go and mention config.inc.php which makes me wonder if you're attempting to install your own version of phpMyAdmin.
     
    #5 Infopro, Apr 2, 2015
    Last edited: Apr 2, 2015
  6. fivethirty

    fivethirty Member

    Joined:
    Apr 2, 2015
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    New York City
    cPanel Access Level:
    Website Owner
    Well, that was the case with the traditional version of GoDaddy. However, now that they've moved it to new servers and are forcing you to use cPanel all this ease of handling the fields is gone. The need for config.inc.php came from the link which you gave me. Some code has to be put in to allow said editing.

    Now, what I did so far, as per the instructions in the link you gave, I tried with this config.inc. php, placed in public_html:
    Code:
    <?php
    
    $i=0;
    $i++;
    $cfg['Servers'][$i]['user']  = 'username';
    $cfg['Servers'][$i]['password']  = 'password'; // use here your password
    $cfg['Servers'][$i]['auth_type']  = 'config';
    
    $cfg['ProtectBinary']  = 'false';
    $cfg['ShowFunctionFields']  = 'false';
    $cfg['ShowFieldTypesInDataEditView'] = 'true';
    
    ?>
    
    Tried both the ftp username and password and the username and password of the database but still no luck. I see the warning:


    This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.


    Obviously these have to become available somehow.
     
    #6 fivethirty, Apr 2, 2015
    Last edited by a moderator: Apr 2, 2015
  7. fivethirty

    fivethirty Member

    Joined:
    Apr 2, 2015
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    New York City
    cPanel Access Level:
    Website Owner

Share This Page