phpmyadmin错误1064(42000)在安装过程中

问题描述

对于在已安装和配置MySQL的Debian服务器上安装 phpmyadmin 时出现的错误，我感到很困惑.我已经尝试清除最新的phpmyadmin安装失败，但是无法安装.

I'm quite confused about an error while installing phpmyadmin on a Debian server with MySQL already installed and configured. I've already tried to purge the latest phpmyadmin failed installations, but I'm not being able to installing it.

我还已经搜索了常见问题，试图将phpmyadmin文件修复为，但每个timestamp调用都是正确的，没有任何值(timestamp(value)似乎是错误的.)

I've also already searched for common questions as trying to fix phpmyadmin files as https://serverfault.com/questions/341116/setting-up-phpmyadmin-got-a-mysql-syntax-error but every timestamp call is correct without values ( timestamp(value) seems to be wrong).

如果有人能帮助我，我将非常感激！

If anyone could help me I'd be so grateful!

错误提示:

An error occurred while installing the database:

 │
 │ mysql said: ERROR 1064 (42000) at line 1: 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 'IDENTIFIED BY
 │ 'hereismypassword'' at line 1 . Your options are:
 │  * abort - Causes the operation to fail; you will need to downgrade,
 │    reinstall, reconfigure this package, or otherwise manually intervene
 │    to continue using it. This will usually also impact your ability to
 │    install other packages until the installation failure is resolved.
 │  * retry - Prompts once more with all the configuration questions
 │    (including ones you may have missed due to the debconf priority
 │    setting) and makes another attempt at performing the operation.
 │  * retry (skip questions) - Immediately attempts the operation again,
 │
 │                                  <Ok>

推荐答案

好的，我通过执行以下步骤解决了我的问题:

Ok, I solved my problem by doing the following steps:

1. 完全删除phpmyadmin和mysql:

1. Removing completely phpmyadmin and mysql:

sudo remove phpmyadmin + sudo remove mysql

sudo purge phpmyadmin + sudo purge mysql)

升级dist:sudo apt-get dist-upgrade

重新安装所有内容(phpmyadmin + mysql)

Reinstalling everything (phpmyadmin + mysql)

稍后，我在phpmyadmin中还有其他与用户名和密码有关的问题，但是我已经通过以下查询解决了这些问题:

Later I had other kind of issues related about users and passwords in phpmyadmin, but I've solved them with that query:

mysql -u root mysql

UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root';

FLUSH PRIVILEGES;

exit;

这篇关于phpmyadmin错误1064(42000)在安装过程中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！