Access Denied for idoit

Author Topic: Access Denied for idoit  (Read 289 times)

rickstaples

  • Newbie
  • *
  • Posts: 1
Access Denied for idoit
« on: 19 October 2011, 20:53:52 »
I am loading the demo install (have loaded twice) - The autoinstall completes successfully then forwards to idoit-root/index.php and I get this error:

isys_exception_database : Access denied for user 'idoit'@'localhost' (using password: YES)

idoit user is set as dba on the server.  I can query database from idoit server and from loacl workstation and I have full rights.

I do not know where to look to find password in the idoit files but the databse server is fine with the user/pass

Grants for idoit@%
GRANT ALL PRIVILEGES ON *.* TO 'idoit'@'%' IDENTIFIED BY PASSWORD '*C3E77E59B58D282CF2021CD59752359091C4ED51' WITH GRANT OPTION
GRANT ALL PRIVILEGES ON `idoit_system`.* TO 'idoit'@'%'
GRANT ALL PRIVILEGES ON `idoit_data`.* TO 'idoit'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE ON `mysql`.`db` TO 'idoit'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE ON `mysql`.`proc` TO 'idoit'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE ON `mysql`.`event` TO 'idoit'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE ON `mysql`.`tables_priv` TO 'idoit'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE ON `mysql`.`columns_priv` TO 'idoit'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE ON `mysql`.`func` TO 'idoit'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE ON `mysql`.`user` TO 'idoit'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE ON `mysql`.`procs_priv` TO 'idoit'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE ON `mysql`.`host` TO 'idoit'@'%'

ds

  • Administrator
  • Hero Member
  • *****
  • Posts: 1525
Re: Access Denied for idoit
« Reply #1 on: 03 November 2011, 15:43:09 »
The databases are configured in src/config.inc.php and in the system database in table isys_mandator