Mysql Version : 8.0.23
PHP version : 5.6.40
CentOS Linux release 7.9.2009 (Core)
Take a backup of /etc/my.cnf
[mysqld]
default_authentication_plugin= mysql_native_password
Restart Mysql service
systemctl restart mysqld
Login to Mysql root prompt
alter user 'user'@'localhost' identified with mysql_native_password by 'your_password';
After this, if you get an error "If it is FULL_GROUP_GROUP_BY exist, then we need to disable it:"
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));