• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 697
  • Last Modified:

Edit Contents of a Field in an MySQL Table in the cPanel of GoDaddy

Working with MySQL database used to be quite straightforward in the standard GoDaddy MySQL. Now GoDaddy has changed it (moved to new servers, they say) and editing the contents of the individual cells in a table of a database doesn't seem obvious. Does anyone know how to change said contents? It seems they explain everything else, which is mostly obvious, but not this particular very necessary editing: https://documentation.cpanel.net/display/1144Docs/MySQL+Databases
0
judico
Asked:
judico
  • 4
  • 4
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
To enter information in a database, use the phpMyAdmin interface (Home >> Databases >> phpMyAdmin).
That page says that phpMyAdmin is still available if that is what you are used to.
0
 
judicoAuthor Commented:
All that still exists, save the option to edit fields. Probably an additional config.inc.php is to be created to allow such editing. This is what I'm getting from: http://docs.phpmyadmin.net/en/latest/index.html
0
 
Dave BaldwinFixer of ProblemsCommented:
May depend on the version of phpMyAdmin.  Older versions did not provide for direct editing.  You had to click on the edit icon and edit the whole row, not just a single field like the newer versions of phpMyAdmin allow.  I maintain a couple of Godaddy sites that are still using an older version of phpMyAdmin.

Interesting.  My Godaddy site has phpMyAdmin 3.5.5 and does not allow direct editing and my other computer has version 3.5.8 and it does.  If it is a configuration setting, I don't know what it is.

And more interesting... this computer has version 4.0.10 and on a table without an index it says...
This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
judicoAuthor Commented:
This is some common problem. Some suggest to change one of the columns to primary: http://stackoverflow.com/questions/18922503/resolution-this-table-does-not-contain-a-unique-column-grid-edit-checkbox-ed
0
 
judicoAuthor Commented:
Somehow this did it. I can't figure out how exactly.
0
 
Dave BaldwinFixer of ProblemsCommented:
That's what the message says and it was a change in version 4 of phpMyAdmin.
0
 
judicoAuthor Commented:
The problem I encountered turned out to be a common problem with some seemingly counter intuitive solution. Thanks for the time spent to dwell into this problem together with me.
0
 
Dave BaldwinFixer of ProblemsCommented:
You're welcome, glad to help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now