Magento database connection issue with no database password

Question

I am trying to set up my magento site on my local dev server. I have installed database and copied files from live server and changed settings in local.xml file.

On my local server I have no password for database user. Everything is ok with local.xml but still I am not able to connect with database. getting below error -

SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

below are my setting for local.xml

<connection>
            <host><![CDATA[localhost]]></host>
            <username><![CDATA[root]]></username>
            <password><![CDATA[]]></password>
            <dbname><![CDATA[mydbname]]></dbname>
            <initStatements><![CDATA[SET NAMES utf8]]></initStatements>
            <model><![CDATA[mysql4]]></model>
            <type><![CDATA[pdo_mysql]]></type>
            <pdoType><![CDATA[]]></pdoType>
            <active>1</active>
</connection>

What can be issue ? Any help please.

Thanks in advance.

Hello Python · Accepted Answer · 2014-03-02 09:35:13Z

1

After struggling for 2-3 hrs I got, other local_bkp.xml file was creating issue here. That I have that kept here(etc/app/ folder) for backup.

I don't know why magneto was taking credentials form that bkp file instead on actual local.xml file, but once I have removed backup file from there it worked.

Thanks to all for your time.

edited Mar 2, 2014 at 9:35

answered Mar 2, 2014 at 9:24

Hello Python

1202 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Amit Bera Over a year ago

Python...,yes ,this type of issue ,was occurred once in my life :)

Amit Bera · Accepted Answer · 2014-03-02 05:21:09Z

0

Python, you did not put the database user password ,so please put the password of database user password . If password id then it will be <password><![CDATA[password]]></password>

answered Mar 2, 2014 at 5:21

Amit Bera

7,6157 gold badges34 silver badges59 bronze badges

1 Comment

Hello Python Over a year ago

Thanks Amit, But I already wrote that there is no password. Anyway, I got the solution and answered here.

Collectives™ on Stack Overflow

Magento database connection issue with no database password

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related