MySQL Error: Access denied for user

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

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