MySQL Error: Access denied for user

6 posts by 2 authors in: Forums > CMS Builder
Last Post: May 7, 2015   (RSS)

By Twocans - May 6, 2015

Hello,
I am trying to start a new cms, I have followed each of the instructions here

http://www.interactivetools.com/docs/cmsbuilder/install.html

but I keep getting the following when completing all the details.

MySQL Error: Access denied for user 'test_username'@'localhost' to database 'londontest_db'

(both username and db name above have been changed)

I can connect to the site and the database user cute and dreamweaver no problem. 

My php version s 5.5 and localhost is localhost

What is the most common reason for the denial. 

regards

Kenny

By Twocans - May 6, 2015

Hi yea, 

Thanks for been there

I uploaded the dir via cuteftp. when it is uploaded I select the dir and right click .... then properties >>>> I see permissions is set to 755

that is

(r = read , w = write, e = execute)

owner  R - W -  E

Group  R -     -  E

Public  R -     -  E

+++++++++++++++++++++++++++++++++++++++++++++++//

I have tried 777 but that didnt work either and it would not even allow me see the registration page in my browser. Those settings been.

owner  R - W -  E

Group  R -  W   -  E

Public  R -  W   -  E

+++++++++++++++++++++++++++++++++++++++++++++++//

I have tried this near 20 odd times today as I want to perfect my actions as I want to use more of your cms, this is my second site using your cms.

My host is hostgator, I have checked folder permissions of this current site from an other site which I built using cms 2.64

I have reset the db user and password to reconfirm your request and tested only to be on the same boat.

I still end up with the MySQL Error: Access denied for user 'dbusername'@'localhost' to database 'databasename'

Regards

Kenny

By Damon - May 6, 2015 - edited: May 6, 2015

Hi again,

The database user permissions you need to set will be through your hosting control panel. 

Take a look at his hostgator article to Define a User's Privileges:
http://support.hostgator.com/articles/cpanel/how-do-i-create-a-mysql-database-a-user-and-then-delete-if-needed#privileges

For the user select ALL PRIVILEGES.

Let me know if this works for you.

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By Twocans - May 7, 2015

Damon thank you, 

That worked.
On creating the cms do I go back and turn off these permissions ? or thats it I leave them like this.

regards

Kenny

By Damon - May 7, 2015

Leave the database user permissions as is.

CMS Builder needs these permissions to read, write and delete data from the database.

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/