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!
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.
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.
Damon Edis - interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/