October CMS unable to connect to the database

[shailendraDev7]

I'm struggling to connect mysql database named 'dbsg_october' to the OCTOBER CMS.
ALL my credentials are exactly same but this error.

[aniket-magadum]

I think this is a problem for mysql 8+. Not sure if octobercms is tested on it

[LukeTowers]

@4nik3t what version of PHP are you using? See https://www.php.net/manual/en/ref.pdo-mysql.php, you have to use PHP 7.2 at least when using MySQL 8.0.4's new default authentication method (https://mysqlserverteam.com/mysql-8-0-4-new-default-authentication-plugin-caching_sha2_password/).

You can also switch MySQL to using the legacy authenticator as recommended here: laradock/laradock#1390 (comment), but theoretically as long as you're running >= PHP 7.2 it should work fine. If it doesn't, you might need to switch to using the L6 branch of October (until it gets merged in a couple weeks) which would include the Laravel specific fixes for MySQL 8.0 here: laravel/framework#23948

[aniket-magadum]

@LukeTowers thanks for the info

[LukeTowers]

@shailendracool433 see above comment.

[github-actions]

This issue will be closed and archived in 3 days, as there has been no activity in the last 60 days.
If this issue is still relevant or you would like to see it actioned, please respond and we will re-open this issue.
If this issue is critical to your business, consider joining the Premium Support Program where a Service Level Agreement is offered.