Access denied for user 'cms'@'localhost' (using password: YES)?

8 posts by 2 authors in: Forums > CMS Builder
Last Post: January 28, 2012   (RSS)

By JamesKB - January 28, 2012

When I try to install CMS Builder I get the following error:

-----------------------------------------------------------------------
Access denied for user 'cms'@'localhost' (using password: YES)
-----------------------------------------------------------------------

I have entered the correct password for the "user" of the database. What is going on?

Thanks for your time.
--
JamesKB
Have a nice day....

--

JamesKB

Re: [JamesKB] Access denied for user 'cms'@'localhost' (using password: YES)?

By gkornbluth - January 28, 2012

Hi JamesKB,

Just a guess...

Could it be the permissions actually granted to the db user?

They need to be administrator (dba) level permissions.

Jerry Kornbluth
The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

Re: [gkornbluth] Access denied for user 'cms'@'localhost' (using password: YES)?

By JamesKB - January 28, 2012

Thanks for the reply Jerry,

I have the permissions set as shown the attached jpg.

Ideas??
Have a nice day....

--

JamesKB
Attachments:

db.jpg 40K

Re: [JamesKB] Access denied for user 'cms'@'localhost' (using password: YES)?

By gkornbluth - January 28, 2012

Hi James,

Sorry that didn't turn out to be an easy fix.

Can you gain full access the database in any other external way with those credentials? Like through PHPMyadmin ?

It also might be a server path issue in your setup information or a write permission issue with a folder. (but those are stabs in the dark)

Good luck
The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

Re: [JamesKB] Access denied for user 'cms'@'localhost' (using password: YES)?

By gkornbluth - January 28, 2012 - edited: January 28, 2012

Have you tried to reinstall? redownload and install?

Have you ever installed on a remote server?


Jerry
The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

Re: [gkornbluth] Access denied for user 'cms'@'localhost' (using password: YES)?

By JamesKB - January 28, 2012

ISSUE SOLVED!! I found the bug! He is sitting in front of the monitor! [;)] I was not entering the complete db and db user names. [:P] Once I did that all is working as it should. Thanks for your time.
Have a nice day....

--

JamesKB

Re: [JamesKB] Access denied for user 'cms'@'localhost' (using password: YES)?

By gkornbluth - January 28, 2012

Glad you got it sorted out.

We're usually the "bug"

Jerry Kornbluth
The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php