Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Products: CMS Builder:
Access denied for user 'cms'@'localhost' (using password: YES)?

 
 


JamesKB
User

Jan 27, 2012, 11:31 PM

Post #1 of 8 (779 views)
Shortcut
Access denied for user 'cms'@'localhost' (using password: YES)? Can't Post
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


gkornbluth
Veteran

Jan 28, 2012, 9:33 AM

Post #2 of 8 (748 views)
Shortcut
Re: [JamesKB] Access denied for user 'cms'@'localhost' (using password: YES)? [In reply to] Can't Post
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!
http://www.thecmsbcookbook.com


JamesKB
User

Jan 28, 2012, 10:05 AM

Post #3 of 8 (744 views)
Shortcut
Re: [gkornbluth] Access denied for user 'cms'@'localhost' (using password: YES)? [In reply to] Can't Post
Thanks for the reply Jerry,

I have the permissions set as shown the attached jpg.

Ideas??

Have a nice day....
--
JamesKB
Attachments: db.jpg (38.9 KB)


gkornbluth
Veteran

Jan 28, 2012, 10:36 AM

Post #4 of 8 (740 views)
Shortcut
Re: [JamesKB] Access denied for user 'cms'@'localhost' (using password: YES)? [In reply to] Can't Post
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!
http://www.thecmsbcookbook.com


JamesKB
User

Jan 28, 2012, 11:44 AM

Post #5 of 8 (739 views)
Shortcut
Re: [gkornbluth] Access denied for user 'cms'@'localhost' (using password: YES)? [In reply to] Can't Post
Yes I can access the db with PHPMyadmin. More ideas??

Thanks for your time.

Have a nice day....
--
JamesKB


gkornbluth
Veteran

Jan 28, 2012, 12:07 PM

Post #6 of 8 (729 views)
Shortcut
Re: [JamesKB] Access denied for user 'cms'@'localhost' (using password: YES)? [In reply to] Can't Post
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!
http://www.thecmsbcookbook.com

(This post was edited by gkornbluth on Jan 28, 2012, 12:08 PM)


JamesKB
User

Jan 28, 2012, 5:07 PM

Post #7 of 8 (715 views)
Shortcut
Re: [gkornbluth] Access denied for user 'cms'@'localhost' (using password: YES)? [In reply to] Can't Post
ISSUE SOLVED!! I found the bug! He is sitting in front of the monitor! Wink I was not entering the complete db and db user names. Tongue Once I did that all is working as it should. Thanks for your time.

Have a nice day....
--
JamesKB


gkornbluth
Veteran

Jan 28, 2012, 6:39 PM

Post #8 of 8 (713 views)
Shortcut
Re: [JamesKB] Access denied for user 'cms'@'localhost' (using password: YES)? [In reply to] Can't Post
Glad you got it sorted out.

We're usually the "bug"

Jerry Kornbluth
The first CMS Builder reference book is now available on-line!
http://www.thecmsbcookbook.com