我试着在Debian Squeeze上安装phpmyadmin,并安装了nginx和mysql-server。 我运行sudo apt-get install phpmyadmin ,所有似乎进展顺利,直到安装扔我这个:
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
…做什么?
在/ usr / share / dbconfig-common / data / phpmyadmin / install / mysql (pma_history部分)中用“timestamp”replace“timestamp(14)”。
然后重新安装phpmyadmin。
在修正了Krevindioubuild议的脚本之后重新configurationphpmyadmin(而不是重新安装它)可能已经足够了:
sudo dpkg-reconfigure phpmyadmin