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
judicoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.