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 Damon - May 6, 2015

Hi Kenny,

Check that the database user has full permissions to create, delete, update etc. 

If the username and password are correct, this is usually thing to check.

Let me know if this was it or not.

Thanks!

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 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 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/