Editing Content of Table Cells

fivethirty

• April 02, 2015 11:51

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:

• 

  Infopro

  • April 02, 2015 17:09

  Sounds to me like you're looking for instructions on using phpMyAdmin, which is provided in your cPanel.

  0
• 

  fivethirty

  • April 02, 2015 17:28

  Thanks, @Infopro. Can't find config.inc.php in any of the folders. Any idea?

  0
• 

  fivethirty

  • April 02, 2015 17:32

  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?

  0
• 

  Infopro

  • April 02, 2015 17:46

  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.

  0
• 

  fivethirty

  • April 02, 2015 18:12

  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:
  [$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.

  0
• 

  fivethirty

  • April 02, 2015 19:27

  Now, it turns out that this is some sort of a common problem and the solution is to choose one of the fields to be the primary field (?!). Cf.

  0

Please sign in to leave a comment.