treehouse : what would you like to learn today?
Web Design Web Development iOS Development

PHPMyadmin error when using on MAMP

  • I recently updated my PHPMyAdmin for MAMP by downloading the latest version from http://www.phpmyadmin.net/home_page/index.php and replace the phpmyadmin on the MAMP folder, then do the simple config for username and password and hostname.

    After that, I get this error every time I create a new database. See image Image and video hosting by TinyPic

    The database is still created, but there's that error. I get that same error every time I try to import a SQL database from somewhere else, or just simply clicking on the "Structure" tab in PHPMyAdmin.

    Does anyone know what the problem might be and how to fix it?

    My apologies if this seems like a trivial question. I don't know a whole lot about SQL.

  • what version of phpmyadmin did your mamp come with, and what version did you upgrade to?

    what version of mysql are you running?

  • Hi,

    I'm not sure what version of PHPMyAdmin (I downloaded MAMP about 2 months ago) came with, but I upgraded it to 3.5.2

    How do I find out about the version for MySQL?

  • use mysql -v from your terminal. Or, just check phpmyadmin: image

    I've never run into this sort of error before, but I'd suspect from your error message that is has to do with missing values in that query. The table to use is empty (just .) , and the value to match db_name is just an empty string.

    Did you write this query, or is it generated by phpmyadmin?

    Can you share steps to reproduce the error?