Knowledgebase

On servers managed by CyberPanel, the MySQL root password is stored in a local file. Instead of manually copying the password, you can pass it directly to the mysql client using command substitution.

Log in to MySQL Automatically

Use this command:

mysql -u root -p"$(cat /etc/cyberpanel/mysqlPassword)"

How it works:

• $(cat /etc/cyberpanel/mysqlPassword) reads the password from the file.

• The shell substitutes the password into the command automatically.

• This avoids manually typing or copying the password.

Log Directly into a Specific Database

If you want to open a specific database directly (for example, a WordPress database):

mysql -u root -p"$(cat /etc/cyberpanel/mysqlPassword)" YOUR_DATABASE_NAME

Replace YOUR_DATABASE_NAME with the actual database name.

Why This Is Useful

• No need to remember or manually paste the root password.

• Useful for automation scripts and quick administrative access.

• Reduces the risk of typos when entering long passwords.

Security Notes

• The password file /etc/cyberpanel/mysqlPassword should only be readable by root.

• Avoid echoing or printing this password in logs or shared terminals.

• Do not expose the file contents to untrusted users.

Summary

Using command substitution allows seamless and secure access to MySQL with stored credentials, making database administration faster and safer.