phpmyadmin blocking remote access

Discussion in 'General' started by yvespires, Dec 20, 2011.

  1. yvespires

    yvespires New Member

    Hello

    I did default installation of ISPconfig, can login normally on phpmyadmin page using root... but i cannot using custom user.. gettting this error:

    #1045 Cannot log in to the MySQL server


    Remote Acess is checked.


    Any ideas?
     
    yvespires, Dec 20, 2011
    #1
  2. bruno_floyd

    bruno_floyd New Member

    Did you add the IPs of the servers/places where the user would log in from?
     
    bruno_floyd, Dec 20, 2011
    #2
  3. yvespires

    yvespires New Member

    nop, i left it blank so any IP can log in

    tried now via terminal:
     
    yvespires, Dec 20, 2011
    #3
  4. bruno_floyd

    bruno_floyd New Member

    Try with the IP, see if it works
     
    bruno_floyd, Dec 20, 2011
    #4
  5. yvespires

    yvespires New Member

    Figured...

    I did multiserver installation...following ISPConfig manual.

    web.domain.com - 192.168.0.1 / xxx.xxx.64.50
    ns1.domain.com - 192.168.0.2 / xxx.xxx.64.51
    ns2.domain.com - 192.168.0.3 / xxx.xxx.64.52
    db.domain.com - 192.168.0.4 / only internal access

    http://web.domain.com/phpmyadmin using root login works, but only lists db from web.domain.com... seems right

    But when i create website database and try to login using normal user http://web.domain.com/phpmyadmin, for some reason phpmyadmin at web.domain.com cant connect to db.domain.com

    is something wrong in my setup?!
     
    yvespires, Dec 20, 2011
    #5
  6. yvespires

    yvespires New Member

    solved!

    added db.domain.com at phpmyadmin login screen ;)
     
    yvespires, Dec 20, 2011
    #6

Share This Page