While installing the OScommerce from cPanel Fantastico, you may get an error message which says that your username do not have sufficient permissions for accessing the MysQl database.
The error may look like as below.
“Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘mysql’@’localhost’ (using password: YES) “
You can fix this issue by following the steps given below.
1. Log in to your cPanel.
2. Click on Change password under Preferences tab.
2.a Type the original password under Old Password.
2.b Type the desired password into the New Password field. (Remember to use a secure password that contains no dictionary words, and is comprised of upper- and lower-case letters, as well as numbers and symbols. You may use the cPanel password generator to generate a secure password by clicking the Password Generator button.)
[Note: Some web hosts require a minimum password strength. The password Strength meter turns green when the required password strength is met. Ask your web hosting provider for more information regarding their required password strength.]
2.c Confirm the new password by entering it into the New Password (again) field.
You have to select the “Allow MySQL password” change checkbox. This will give the same password to the database on the server and will fix the issue.
2.d Click Change your password now! to save the new password.
[**Note:Whenever you change your password using this feature your main FTP account password and system email address password will also change.]
If you still not able to do this, please get back to us through the 24×7 chat facility or by opening a ticket to our support desk. You can open a ticket to the support by simply mailing to the email account : firstname.lastname@example.org. Please include complete information including the snap shots of error messages if any while opening the ticket.