I am referring to database user no oc_user seems you have mistakenly try to change opencart users password via database UI.
Got a burning question at 3 AM that even Google shrugs at? There’s a not-so-secret inbox that might just have your answer: khnaz35@gmail.com
Breathe in some nature while you're at it. It’s cheaper than therapy. 
Feel free to sling a bear my way via PayPal @ khnaz35@gmail.com
What exactly do you mean by "with MD5"?
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
He is referring to the hash method via phpMyAdmin
Got a burning question at 3 AM that even Google shrugs at? There’s a not-so-secret inbox that might just have your answer: khnaz35@gmail.com
Breathe in some nature while you're at it. It’s cheaper than therapy.
Feel free to sling a bear my way via PayPal @ khnaz35@gmail.com
But we're not talking about OC users *in* the database, we're talking about the database users themselves.khnaz35 wrote: ↑Thu Aug 14, 2025 2:05 amHe is referring to the hash method via phpMyAdmin
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Well that's why I wrote above to clarify.paulfeakins wrote: ↑Thu Aug 14, 2025 7:28 pmBut we're not talking about OC users *in* the database, we're talking about the database users themselves.
Got a burning question at 3 AM that even Google shrugs at? There’s a not-so-secret inbox that might just have your answer: khnaz35@gmail.com
Breathe in some nature while you're at it. It’s cheaper than therapy.
Feel free to sling a bear my way via PayPal @ khnaz35@gmail.com
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
The error suggests that the username kh-10181_kh_10181_opencart_2 or the password in config.php and admin/config.php is incorrect, or your user lacks permissions to access the database. OpenCart does not use MD5 hashing for database passwords in config.php. The password in these files should be the plain text password for the MySQL user, as OpenCart passes it directly to the MySQL driver (e.g., MySQLi or PDO). If you updated the MySQL user’s password with an MD5 hash, the connection will fail because MySQL expects the actual password, not a hashed version.
Either that or the MySQL user kh-10181_kh_10181_opencart_2 may not have the necessary permissions to access the database (e.g., kh_10181_opencart_2) or may be restricted to a different host (e.g., % instead of localhost).
To resolve it: Log in to MySQL, reset the MySQL user password then verify Database exists and Permissions. Then confirm your MySQL host and update OpenCart Configuration Files - the admin configuration file (e.g., /var/www/html/admin/config.php) and ensure the database settings match those in config.php, something like...
// DB
define('DB_HOSTNAME', 'localhost');
define('DB_USERNAME', 'kh-10181_kh_10181_opencart_2');
define('DB_PASSWORD', 'new-plain-text-password');
define('DB_DATABASE', 'kh_10181_opencart_2');
define('DB_PORT', '3306');
define('DB_DRIVER', 'mysqli');
define('DB_PREFIX', 'oc_');
Users browsing this forum: Google [Bot], gunownergear and 15 guests
