Access Denied for idoit



  • 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'@'%'



  • The databases are configured in src/config.inc.php and in the system database in table isys_mandator


 


Datenschutz / Privacy Policy