I am currently running into two problems. First, when viewing tables using MySQL Query Browser, it keeps displaying "Could not fetch columns".
Second, when attempting to go in an edit any of the fields, the "Edit" button is greyed out and won't allow me to modify anything in the table.
My first thought is that this is a permissions issue, so let me give some background on where I've come so far. Overall goal, create a backup PrestaShop on another server for dev work. Both servers are running CentOS 6.2 and MySQL Server 5.1.73. Steps I've taken in this process (specifically in regards to the db): 1. Ran mysqldump -u root -p --databases shop > shop.sql 2. Copied shop.sql over to the new server 3. Made sure MySQL was installed and running on new server 4. Ran mysql -u root -p shop < shop.sql 5. GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY PASSWORD 'Whatever' WITH GRANT OPTION 6. I made sure to setup a user with the same permission as on the previous server as well to try to reduce problems and granted the same privileges to it.
So now I can view and run select statements on the data, but it is not allowing me to edit the fields from within query browser. I am able to log in and run update statements from the command line on the local host through putty, however. Any thoughts or ideas are greatly appreciated!