Setting up phpmyadmin, got a MySQL syntax error
I tried installing phpmyadmin on Debian Squeeze with a nginx and mysql-server installed. I ran sudo apt-get install phpmyadmin
, and all appeared to be going well until setup threw me this:
An error occurred while installing the database:
mysql said: ERROR 1064 (42000) at line 72: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '(14) NOT NULL, `sqlquery` text NOT
NULL, PRIMARY KEY (`id`), KEY `usernam' at line 6
...what do?
Solution 1:
Replace "timestamp(14)" by "timestamp" in /usr/share/dbconfig-common/data/phpmyadmin/install/mysql (pma_history section).
Then reinstall phpmyadmin.