Mysql password problems

Discussion in 'Installation/Configuration' started by lerra, Feb 19, 2006.

  1. falko

    falko Super Moderator Howtoforge Staff

    You must install ISPConfig as root!
     
  2. lerra

    lerra New Member

    Ow! How shud I do now? Is it posseble to just change the account to root?
    I dont remember seeing that it was written that root account was a must, anyway:)
     
  3. falko

    falko Super Moderator Howtoforge Staff

    Is ISPConfig working (can you log in)?
    What's the name of the MySQL user in /home/admispconfig/ispconfig/lib/config.inc.php?
     
  4. lerra

    lerra New Member

    Yes, everything else becide mysql is working good. I created it with almoste all rights i think...
    Cant find the row that the user info is at but its named ispconfig,

    select * from user where User="ispconfig";
    gave this

    Code:
    --------+-------------+--------------+---------------+-------------+-----------------+
    | Host      | User      | Password         | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections |
    +-----------+-----------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
    | localhost | ispconfig | xxxxxxxxxxxxxxxx | Y           | Y           | Y           | Y           | Y           | Y         | N           | N             | Y            | N         | N          | N               | Y          | N          | Y            | N          | Y                     | Y                | N            | N               | N                |          |            |             |              |             0 |           0 |               0 |
    +-----------+-----------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+

    (copy paste to notepad or something to make it more readeble.
     
    Last edited by a moderator: Feb 24, 2006
  5. lerra

    lerra New Member

    Wow, seams like its working, changed /home/admispconfig/ispconfig/lib/config.inc.php row 78 79 to root and rootpasswd and it worked:) Falk, please tell me if there is somthing critical with this:) Thansk for a great software
     
  6. falko

    falko Super Moderator Howtoforge Staff

    No, that's the way it is intended to be.
     

Share This Page