wiki.zeratul.org

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Issue 2020 - August ======

===== Joomla, MySQL and Access denied =====

I've encountered weird issue with Joomla and MySQL. Joomla was working just fine on the outside, but not on the inside. For example it was not possible to create new articles because save action resulted in something like:

<code>
1044 Access denied for 'user'@'%' to database 'dbname'
/web/htdocs1/xxx/home/www/libraries/joomla/database/driver/mysqli.php:665
</code>

Turning on all kind of sorts of debugging turned out to be useless for this one. Searching various forums and blogs seemed to be useless as well. Since I knew which file and roughly which line, I've modified `mysqli.php` and added debugging print-outs which I deemed to be useful:

<code>
1044 LOCK TABLES `xxx` WRITE
/web/htdocs1/xxx/home/www/libraries/joomla/database/driver/mysqli.php:665
</code>

Not exactly the best and complete information, however it was enough for support ticket to web hosting provider:

<code>
GRANT LOCK TABLES ON `dbname`.* TO 'user'@'%';
</code>

All is good now and Joomla seems to be fully operational. Yay!