How my friend made phpmyadmin work

Discussion in 'Tips/Tricks/Mods' started by patrickfoley, Apr 23, 2009.

Page 2 of 2
  1. patdundee

    patdundee New Member

    PhPmyadmin

    Hi Guys
    Also having installed ISPconfig3 on ubuntu server 10.10 Everything works fine including PHPMyadmin on its own. The problem I have is when a database is created within ISPConfig3 the database does get created but the new USER and PASSWORD does not get added in PHPMyadmin therefore they cannot log in. However If i log in to PHPMyadmin as root user I can see all the created databases, When examining the user tabel in the MySQL database the user from ISPConfig is NOT there.

    Any ideas please on this one would be most appreciated

    By the way I can create any user or database in PHPMyadmin for any site and that works fine. I can also create any database for any website in ISPConfig3 this issue is as stated above ISPConfig3 does not add the user to the user table

    Also the url that ISPConfig goes to for PHPMyadmin has allways been the correct one
     
    Last edited: May 10, 2011
    patdundee, May 10, 2011
    #21
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    This problem is not phpmyadmin related, as database users dont get added to phpmyadmin because phpmyadmin has no user database. All user data is stored in the mysql user table and phpmyadmin uses the mysql user table to authenticate users.

    Please post a screenshot of the users that are in the mysql user table (without passwords of course).
     
    till, May 10, 2011
    #22
  3. patdundee

    patdundee New Member

    My Mistake

    Hi
    My mistake sorry. I meant the user table in the MySql Database. However I have since restarted the system and the user is indeed now in the table and can log in as can any other I add.

    Obviously a clitch after the install.

    Many thanks for the response though.
     
    patdundee, May 11, 2011
    #23
Page 2 of 2

Share This Page