ERROR 1045（28000）用户'root'@'localhost'访问被拒绝。 Symfony的。 Bitnami WAMP [英] ERROR 1045 (28000) Access denied for user 'root'@'localhost'. Symfony. Bitnami WAMP

问题描述

我已经坐2小时浏览互联网，我无法找到解决方案。你能帮帮我吗。


Bitnami WAMP，Symfony


1）我无法通过控制台登录MYSQL

使用命令：mysql -u root -p

使用命令：mysql -h localhost -u root -p

using command：mysql -h localhost -u root -p -P 3006
使用命令：mysql -h 127.0.0.1 -u root -p

using command：mysql -h 127.0.0.1 -u root -p -P 3006

i在所有情况下都得到相同的错误：ERROR 1045（28000）用户''root''访问被拒绝@''localhost''（使用密码：NO）


2）我无法使用用户root登录PhpMyAdmin。和空字段的密码。


3）我无法在Symfony应用程序中从控制台生成实体。我收到错误：[PDOException] SQLSTATE [HY000] [1045]访问被拒绝用户''root'''''localhost''（密码：NO）



config.inc.php
文件夹中的


C：\ Bitnami \ wampstack-5.4.36-0 \ apps\phpmyadmin\htdocs\config .inc.php

包含以下几行：

I sit already 2h browsing internet and i am not able to find a solution. Could you please help me.

Bitnami WAMP, Symfony

1) I am not able to login to MYSQL through console
using command: mysql -u root -p
using command: mysql -h localhost -u root -p
using command: mysql -h localhost -u root -p -P 3006
using command: mysql -h 127.0.0.1 -u root -p
using command: mysql -h 127.0.0.1 -u root -p -P 3006
i am getting the same error in all cases: ERROR 1045 (28000) Access denied for user ''root''@''localhost'' (using password: NO)

2) I am not able to login to PhpMyAdmin, using user "root" and empty field for password.

3) I am not able to generate entity from console in Symfony application. I am getting error:[PDOException] SQLSTATE[HY000] [1045] Access denied for user ''root''@''localhost'' (password: NO)


config.inc.php
in folder
C:\Bitnami\wampstack-5.4.36-0\apps\phpmyadmin\htdocs\config.inc.php
contains the following lines:

展开 | 选择 | Wrap | 行号

推荐答案

当我尝试在控制台中使用命令mysql时，我发出的错误是''ODBC'''''localhost''无法连接。



c：\ Bitnami \ wampstack-5.4.36-0> mysql

ERROR 1045（28000）：拒绝访问用户'' ODBC'''''localhost''（使用密码：NO）

When i try to use command mysql in console, i am geting error that ''ODBC''@''localhost'' can not connect.


c:\Bitnami\wampstack-5.4.36-0>mysql
ERROR 1045 (28000): Access denied for user ''ODBC''@''localhost'' (using password: NO)

我认为您的root密码与您在尝试期间提供的密码不匹配...


尝试重置root的密码


请参阅： http://dev.mysql.com/doc/refman/5.0/...rmissions.html

I think your root password is not matching with what you provide during your attempts...

Try resetting the password for ''root''

see: http://dev.mysql.com/doc/refman/5.0/...rmissions.html

C：\ Bitnami \ wampstack-5.4.36-0\apps\phpmyadmin\htdocs\config.inc.php

C:\Bitnami\wampstack-5.4.36-0\apps\phpmyadmin\htdocs\config.inc.php

这篇关于ERROR 1045（28000）用户'root'@'localhost'访问被拒绝。 Symfony的。 Bitnami WAMP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！