Change password with SSH console "mysql_client and debian.cnf"

Discussion in 'Server Operation' started by Terry456, Apr 28, 2020.

  1. Terry456

    Terry456 New Member

    Hello,
    I have to modify via my SSH console the password of the files :
    /usr/local/ispconfig/server/lib/mysql_clientdb.conf
    /etc/mysql/debian.cnf
    My searches on google have been unsuccessful so far.
    I can't find what commands I should use to validate these actions.
    Can someone here help me please?
    Thank you in advance.
    Best regards,
    T.
     
  2. Steini86

    Steini86 Active Member

    I am not really sure what you want? Do you want to see the content of these files? You can use "cat" to see the full contents or "less" to show it pagewise (use space for next page).
    If you want to edit these files you have to use your favorite editor. "vi" is installed on almost every linux system, but it is not quite beginners friendly. Many distributions have "nano" installed.
    You may want to use one of the many linux console beginner guides
     
    Terry456 likes this.
  3. Terry456

    Terry456 New Member

    H
    I need to change the database password in these 2 files.
    I have shared hosting, do you think I can use the editor you tell me about?
    Thank you.
    Best regards,
    T.
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    These files are editable for the system administrator only, you need the server root login for that. Do you have the SSH root login details of that server, probably not if you just have shared hosting and not a VPS or root server. And why do you want to change them btw?
     
    Terry456 likes this.
  5. Terry456

    Terry456 New Member

    Hi Till,
    Of course I have the information to connect with the SSH console. I have a VPS. Sorry for my bad English.
    I want to change the passwords for my database and phpmyadmin simply because I shared them with a wordpress technician who worked on my site. Now that he has finished his mission I would like to renew my passwords for security.
    My host advised me to also change the passwords for the two files I mentioned for the ISP config. Unfortunately I can't do it from my FTP software.
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, then just do what @Steini86 explained in #2
     

Share This Page