phpmyadmin错误1064(42000)在安装过程中 [英] phpmyadmin error 1064 (42000) during installation

查看:274
本文介绍了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文件修复为

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;

来源:无法将MySQL根密码设置为空

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

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆