Menu
Yesterday I removed a column called 'systeem_eisen' from a table.
Now when I click in phpMyAdmin at the table 'products' I get the error message:#1054 - column 'systeem_eisen' in 'order clause'
I can't open the table 'products'. But my website still works(he used also the table 'products').
But when I export the table 'products' and I watch the code I see nowhere the word 'systeem_eisen'.
700
Access can be denied when access to MySQL is attempted through the root user. Root requires insertion of a password and once that is wrongly entered or is not provided, this issue arises. This can be configured with the help of the PHP tool. The rights of the root user can also be reset at the same time.
To access phpMyAdmin from XAMPP you will need to make sure you have Apache and MySQL running in the XAMPP control panel by clicking the start buttons under the Actions column. If Apache and MySQL are green then all is well. Then you can click the “Admin” button in the MySQL row and that will launch phpMyAdmin.
Download and install the file, follow the instructions, and record any usernames and passwords given to you. Command to start Apache in Mac Terminal. With that, all that's left is installing phpMyAdmin. Rename the folder to “phpMyAdmin” and move it to /Library/WebServer/Documents/.
Goto phpmyadmin database you will see the pma_table_uiprefs. It stores thoses "cached" preferences and you could delete or edit them.
70
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
