Logaholic Table data Access

2013-11-11 09:43:44Tags: logahilic,mysqli,password
I am using Logaholic Cpanel edition version 4.1.4. I wanted to show Monthly pageviews and monthly visitor count to my users for my entire website. I tried to get that data from PHP/Mysql query from table "p1_merge" from Logaholic database using my default Mysql username and password but am getting following error: "SELECT command denied to user 'XXXX'@'localhost' for table 'p1_merge' . Logaholic was bundled with my Cpanel and I started using it since last month and wanted to explore more data for my website. Kindly advise if this is possible ?? Is the password set by Logaholic or Cpanel default password. Is there any other way I can automate to show previous 30 days data to users using PHP/Mysql

Answer:

Thank you finally solved it ! It seems like priviledge was missing to that Table . Simply add "Grant all on db.table to 'user'@'localhost';" and then use it . Thank you anyways for creating Logaholic ;-)
The information on this page relates to older Logaholic versions (prior to Logaholic 6) and may be outdated.