How to get PHPMyAdmin to show MySQL warnings?

Question

I use PHPMyAdmin for convenience in updating a remote database.

But it doesn't show warnings, by default, which recently got me into some embarrassing trouble where I was updating a SET field with string not on its list and not noticing the problem.

I'm using 2.11.9.1 (Dreamhost's default install).

On the PHPMyAdmin wiki it lists "Display warnings" as a feature of version 2.9.0 and even "Display all warnings" as a feature of 2.10.2 -- but how do I actually turn this on? The documentation isn't great.

Answer 1

I could be mistaken but if I remember correctly you need to have access to the phpMyAdmin config file to enable it.

Answer 2

I don't believe Dreamhost gives you access to the configuration file for their installation of phpMyAdmin. However, you can easily make your own installation of phpMyAdmin by downloading the source from their website and just untarring it to the directory you want to access it at (your-domain.com/phpma for example). Then, follow the website's instructions for editing your config file (which should include enabling warnings like you've asked).

Answer 3

follow the website's instructions for editing your config file (which should include enabling warnings like you've asked).

Well yes, it should. But I don't see it in the config file and I don't see it in the page you linked to. I've already looked for information in the obvious places, believe me.