can't log in to phpmyadmin as database user

Discussion in 'Installation/Configuration' started by tjd, Apr 30, 2007.

  1. tjd

    tjd New Member

    I can log only login to the phpmyadmin interface as root user for the machine with that password. Cannot login as a database user although set up in ISPConfig. Any ideas? It's prbably simple but it's the up all night syndrome again!
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Are the database users listed in the mysql database in the user table?
     
  3. tjd

    tjd New Member

    Yes Till, they appear in mysql, but without privileges on the mysql db, and all privs on the database in question, logging in from "%", or wildcard host.

    Ted
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    All priveliges in the user table must be set to no, thats correct. The priveliges are set in the db table for the specific database.
     
  5. tjd

    tjd New Member

    Thanx, I figured that, but now, for no reason I can define, no matter who I log into ISPConfig as, I can log straight onto phpMy Admin with no authentication at all, that is no login page pops up. I am just there and can do anything to any database??
     
  6. falko

    falko Super Moderator Howtoforge Staff

    Clear your cookies in your browser and try again.
     
  7. tjd

    tjd New Member

    duh!

    Got me again. Thanks falko
     

Share This Page