Author Topic: RELOAD privilege now required to repair tables?  (Read 330 times)

Offline hanshansen

  • Decent Indexer
  • ***
  • Posts: 57
  • Helpful: +1/-0
RELOAD privilege now required to repair tables?
« on: 2018-01-29, 03:16:57 AM »
Hi,

I just noticed that I get the following error when running the optimize_db.php script, if a table needs to be repaired.

Code: [Select]
Error: SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied; you need (at least one of) the RELOAD privilege(s) for this operation
It started a month ago the day after I updated a lot of packages in Ubuntu. Amongst the updates were php and mariadb. I don't remember if I updated nzedb too on that day.

Did something in nzedb change or is it caused by the mariadb update?

Offline Darius

  • Enforcer
  • *****
  • Posts: 119
  • Helpful: +7/-1
Re: RELOAD privilege now required to repair tables?
« Reply #1 on: 2018-01-29, 11:12:25 PM »
That is caused by MariaDB update. What version are you using? 5.5, 10.0, 10.1 or 10.2?

Offline hanshansen

  • Decent Indexer
  • ***
  • Posts: 57
  • Helpful: +1/-0
Re: RELOAD privilege now required to repair tables?
« Reply #2 on: 2018-01-30, 01:27:36 AM »
MariaDB 10.2

Offline Darius

  • Enforcer
  • *****
  • Posts: 119
  • Helpful: +7/-1
Re: RELOAD privilege now required to repair tables?
« Reply #3 on: 2018-01-30, 04:05:22 AM »
You, most likely, haven't run this command:

Code: [Select]
GRANT ALL ON nzedb.* TO 'YourMySQLUsername'@'YourMySQLServerHostName' IDENTIFIED BY 'SomePassword';
When all privileges are granted, reload is available