After moving MySQL can’t log in to PHPMyAdmin

Discussion in 'General' started by asgare, Sep 7, 2013.

  1. asgare

    asgare Member

    Hello friends,
    Maybe my question was somehow silly but really I don’t know what to do. Once I realized MySQL was not working, I checked out and saw that the Linux Server Drive is full. Then I moved it to another Partition and now it is working very well. After moving MySQL I can easily log in to my ISPConfig account and can do whatever I like but I can’t log in to PHPMyAdmin. I reconfigured PHPMyAdmin but still nothing goes well. I can see the PHPMyAdmin first page but can’t log in. Even I checked out through remote access but again it didn’t work.
    I really want to solve the problem and not to re-install server from beginning.
    Thanks all valuable comments in advance.
    [/SIZE]
     
  2. almere

    almere Member HowtoForge Supporter

    Did you try to login with mysql root ?
    Did you try to reinstall the phpmyadmin?
     
  3. asgare

    asgare Member

    Yes, I did.

    I tried with root password and see nothing work. Reconfigured PhpMyAdmin too but still problem is remain.

    I am wondering why I can log into ISPConfig but can't get into PhpMyAdmin.
    Also enabled remote access within ISPConfig portal but can't log in via Navicat Premium.:)
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    ISPConfig uses the user "ispconfig" and not the mysql root user.

    You can not use any database functions in ispconfig as long as your mysql root login is broken. Without a root login, you can not change any database settings in ispconfig.

    See here for instructions to reset your mysql root password:

    http://www.faqforge.com/linux/controlpanels/ispconfig2/how-to-reset-the-mysql-root-password/
     

Share This Page