mysql problem

Discussion in 'Installation/Configuration' started by roofgah, Dec 28, 2005.

  1. roofgah

    roofgah New Member

    Hello

    I installed ispconfig but now i get a warning about mysql:

    Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php on line 76

    Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php on line 76

    Warning: Cannot modify header information - headers already sent by (output started at /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php:76) in /home/admispconfig/ispconfig/lib/classes/ispconfig_auth.lib.php on line 96


    What should i do to fix this

    Greetings Roofgah
     
  2. ZyanKLee

    ZyanKLee New Member

  3. roofgah

    roofgah New Member

    i can't login now because when i login i see this warning
     
  4. ZyanKLee

    ZyanKLee New Member

    you see this error when you login to console ?
    strange ;)
     
  5. ZyanKLee

    ZyanKLee New Member

    during installation of mysql (or afterwards) did you change the mysql-password for the mysql-user 'root' ? if so, there seems to be no other way than login to console as system-user 'root' and do the installation-process of ispconfig again from the beginning.

    till or falko may correct me, if there is another way of changing the mysql-root-password in ispconfig
     
  6. roofgah

    roofgah New Member

    i tried to remove ispconfig but when i typ the uninstall command it says that it can't connect to mysql
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    Did you get any errors during ISPConfig installation?

    Please correct the mysql password in the ISPCOnfig configuration file:

    /home/admispconfig/ispconfig/lib/config.inc.php
     
  8. ZyanKLee

    ZyanKLee New Member

    oh ... it's a clear-text-password o_O
     
  9. roofgah

    roofgah New Member

    I didn't see any errors
    How can i change the passwrod of mysql
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    Open the file:

    /home/admispconfig/ispconfig/lib/config.inc.php

    with an text editor and change the password in the line:

    $go_info["server"]["db_password"] = "...........";
     
  11. roofgah

    roofgah New Member

    but when i don't know the password and username and database name anymore. Where can i see that?
     
  12. falko

    falko Super Moderator Howtoforge Staff

    Then you have a serious problem. :eek: Maybe uninstalling and reinstalling MySQL helps, but I'm not sure...
     
  13. falko

    falko Super Moderator Howtoforge Staff

    One question: the MySQL user you're using is root, right? And you forgot root's password?
     

Share This Page