Knowledge

[DevCEDTeam]

SQL Credentials

Project ID: mautic-sql-389602 Connection name: mautic-sql-389602:us-west2:mautic-postgresql-001 database ID: mautic_postgresql_001 user: admin6_postgres PostgreSQL is listening on port 5432 password: m=R|Y%YrfqdJ:C=z ip address: 34.102.127.97 imap.cfored.com: 52525

[DevCEDTeam]

#####################################################

Access denied for user 'db_user'@'localhost' (using password: YES)

+±++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Symptoms

You may notice the following message when attempting to connect to a database:

SQLSTATE[HY000] [1045] Access denied for user 'db_user'@'localhost' (using password: YES)

+±++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Descriptions

To determine if the credentials used are correct, please attempt to connect from the command line by typing the following:

mysql -u $db_user -p

Where $db_user is the actual database user.

+±++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Workaround

One way to reset the password is via WHM by going to:

Account Information » List Accounts

#####################################################

[DevCEDTeam]

Here are the step-by-step instructions to locate your SSH key and log into your cPanel terminal using WinSCP:

1. Generate a new SSH key pair:

   • Log in to your cPanel account.
   • Go to the Security section in the main menu.
   • Look for the SSH Access tool and click on it.
   • Generate a new key pair by entering a name for your keys and an optional password for added security.
   • Remember to copy the password and store it in a safe place.
   • The private key will be downloaded to your browser's default download folder.

2. Authorize the public key:

   • Go back to the Manage SSH Keys interface in cPanel.
   • Click on the "Manage Authorization" button.
   • Follow the instructions to authorize the public key you generated in the previous step.
   • This step allows you to use the SSH key for authentication.

3. Install WinSCP on your local machine:

   • Download WinSCP from the official website and install it on your computer.

4. Configure WinSCP to use your private key:

   • Open WinSCP.
   • Click on the "Advanced" button on the login dialog. This opens the Advanced Site Settings dialog.
   • In the Advanced Site Settings dialog, navigate to the SSH > Authentication section.
   • Under the "Private key file" option, click on the three-dot button (...) to browse for your private key file.
   • Locate the private key file you downloaded in step 1 and select it.
   • If your private key is not in PuTTY's .ppk format, you may need to change the file filter to "All private key files" to see and select your key file.
   • WinSCP will offer to convert the key to .ppk format if needed.
   • After selecting the private key file, click "OK" to close the Advanced Site Settings dialog.

5. Connect to your cPanel server using WinSCP:

   • In the main WinSCP login dialog, enter the following information:
     • Hostname: Enter the hostname or IP address of your cPanel server.
     • Username: Use your cPanel username.
     • Port number: The default SSH port is usually 22.
   • Click the "Login" button to initiate the connection.
   • If this is your first connection, you may be prompted to confirm the host key information.
   • After a successful connection, you will see your local files on the left side of the WinSCP window and your cPanel files on the right-hand side.

By following these instructions, you will be able to locate your SSH key and log into your cPanel terminal using WinSCP. SSH keys provide an additional layer of security for accessing your cPanel server.