phpMyAdmin

Discussion in 'Installation/Configuration' started by dayjahone, Sep 30, 2008.

Page 2 of 2
  1. till

    till Super Moderator Staff Member ISPConfig Developer

    Run:

    mysql -u root


    then in the mysql console run:

    use mysql;

    then run:

    update user set `Password`=PASSWORD('new-password') WHERE User = 'root';
     
    till, Oct 8, 2008
    #21
  2. dayjahone

    dayjahone Member

    Thanks, Till.

    I will try this later today. Will I then need to change the ISPConfig password? If so, where do I do this?

    Thanks.
     
    dayjahone, Oct 8, 2008
    #22
  3. dayjahone

    dayjahone Member

    Thanks, Till and Falko. It seemed to have worked, but I still have the same problem: I can't login to phpMyAdmin as anything other than root.

    I set up a client, gave it a username and password in the Client Login tab and tried to use that username and login with phpMyAdmin with no luck.
     
    dayjahone, Oct 9, 2008
    #23
  4. falko

    falko Super Moderator Howtoforge Staff

    Do you see any error messages when you restart MySQL?
     
    falko, Oct 9, 2008
    #24
  5. dayjahone

    dayjahone Member

    No. It seems to be fine. Again, I can login fine as root.
     
    dayjahone, Oct 9, 2008
    #25
  6. falko

    falko Super Moderator Howtoforge Staff

    Can you log in to MySQL with a username other than root on the command line?
     
    falko, Oct 10, 2008
    #26
  7. dayjahone

    dayjahone Member

    Sorry, how do I do that?
     
    dayjahone, Oct 10, 2008
    #27
  8. falko

    falko Super Moderator Howtoforge Staff

    Code:
    mysql -u [I]<username>[/I] -p
    Replace <username> with the MySQL username.
     
    falko, Oct 11, 2008
    #28
  9. dayjahone

    dayjahone Member

    No luck. I get the following error:

    Code:
    ERROR 1045 (28000): Access denied for user 'clientusername'@'localhost' (using password: YES)
    I was able to log into ISPConfig as a client without trouble.
     
    dayjahone, Oct 11, 2008
    #29
  10. falko

    falko Super Moderator Howtoforge Staff

    The MySQL usernames are something like web1u1 and have nothing to do with the ISPConfig logins.
     
    falko, Oct 12, 2008
    #30
  11. dayjahone

    dayjahone Member

    That would explain the whole mess. So is there a way for a client to log in to phpMyAdmin and adjust all of his databases or does it have to be done on an individual database basis?
     
    dayjahone, Oct 12, 2008
    #31
  12. till

    till Super Moderator Staff Member ISPConfig Developer

    A client can create databases trough ISPConfig. The username for this database is displayed then in ISPConfig and he has to use this username to access the database e.g. with phpmyadmin. Usernames for databasses can only be changed by the mysql root user in phpmyadmin.
     
    till, Oct 12, 2008
    #32
Page 2 of 2

Share This Page