When you see a message like thisan error message "Error establishing a database connection", or "mysql_connect() [function.mysql-connect]: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)", or any similar, it means that the database connection settings in your script's configuration file are not valid for some reason. The fix is to reset the password for the MySQL user in your Cpanel cPanel > MySQL Databases section, to the one used in your configuration files. Official Cpanel cPanel documenation explaining how to change the password for a MySQL user can be found here. You can find the names of the files with the DB database connection settings of the most popular scripts below. If you encounter any problems, please, contact support.
...
Drupal settings.php
But if If you are lucky to use Softaculous for your scripts installation, you can find all the necessary details, that us DB user name and the password there. Here you can find instructions database infromation there.You will also find instructions on how to see details of your installations without looking for configuration filesfiles here.