Differences

This shows you the differences between two versions of the page.

--- bloglike:2020-08 [2020/08/27 15:37] – created stybla
+++ bloglike:2020-08 [2020/08/27 15:47] (current) – [Joomla, MySQL and Access denied] stybla
@@ Line 5: / Line 5: @@
 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>
-: Access denied for 'user'@'%' to database 'dbname'
+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>
+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!