Access denied for user to database

Need help with the Administration of your Joomla! 2.5 site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
freebee
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Mon Jan 31, 2011 7:56 pm

Access denied for user to database

Post by freebee » Mon Jan 31, 2011 8:42 pm

Hi,
I installed Joomla 1.6 to my webhosting - installatin was correct but when I want install some module,themes or add items..joomla report this:


* Error building Admin Menus
* Component Install: DB function failed with error number 1044
Access denied for user 'david_frybertcz'@'%' to database 'david_frybertcz' SQL=LOCK TABLES `jos_assets` WRITE
SQL =

LOCK TABLES `#__assets` WRITE

thanks for advise

-David-

freebee
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Mon Jan 31, 2011 7:56 pm

Re: Access denied for user to database

Post by freebee » Mon Jan 31, 2011 8:49 pm

problem is solved... provider set access permisson for my DB

User avatar
TomT
Joomla! Ace
Joomla! Ace
Posts: 1324
Joined: Thu Aug 18, 2005 5:50 am
Location: Amsterdam
Contact:

Re: Access denied for user to database

Post by TomT » Tue Feb 08, 2011 8:44 am

Can you tell us which permissions the provider changed?

freebee
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Mon Jan 31, 2011 7:56 pm

Re: Access denied for user to database

Post by freebee » Wed Feb 09, 2011 11:45 am

i dont know..provider write me, that permission is set..thats all

homemade
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Mon Jan 12, 2009 10:30 am

Re: Access denied for user to database

Post by homemade » Mon Feb 14, 2011 3:03 pm

This is answer is for people who have phpMyAdmin & access to phpMyAdmin.
You want to go to
Global privileges for your user and check the "LOCK TABLES" box.

Peace.

User avatar
carsten888
Joomla! Ace
Joomla! Ace
Posts: 1224
Joined: Sat Feb 11, 2006 8:32 am
Contact:

Re: Access denied for user to database

Post by carsten888 » Sat Dec 10, 2011 5:42 pm

Global privileges for your user and check the "LOCK TABLES" box.
where to find that in PHPmyAdmin? I searched all over.
http://www.pages-and-items.com my extensions:
User-Private-Page, Redirect-on-Login, Admin-Help-Pages, Dynamic-Menu-Links, Admin-Menu-Manager, plugin load module in article, plugin pure css tooltip and more...

manshoomehra
Joomla! Intern
Joomla! Intern
Posts: 72
Joined: Wed Dec 14, 2011 1:49 pm
Location: Everywhere
Contact:

Re: Access denied for user to database

Post by manshoomehra » Wed Jul 11, 2012 1:29 pm

You can find PHPMyadmin in Control Panel provided by your hosting provider. Its a frontend for accessing your mysql database.


Locked

Return to “Administration Joomla! 2.5”