We help IT Professionals succeed at work.

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

judico
judico asked
on
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
Comment
Watch Question

Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
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.

Author

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
Fixer of Problems
Most Valuable Expert 2014
Commented:
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.

Author

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

Author

Commented:
Somehow this did it. I can't figure out how exactly.
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
That's what the message says and it was a change in version 4 of phpMyAdmin.

Author

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.
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
You're welcome, glad to help.