Reinstall steps for mysql in debian server
apt-get remove -y mysql-*apt-get purge -y mysql-*
Once finished,
rm -rf /var/lib/mysql
rm -rf /etc/mysql*apt-get install mysql-client mysql-server mysql-commonCDbConnection failed to open the DB connection mysql 8
While accessing web configured with mysql 8 and php and you see the following error: CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client OR PHP Fatal error: Uncaught PDOException: PDO::__construct(): The server requested authentication method unknown to the client [caching_sha2_password] It maybe due to PHP devs might have not implemented the MySQL's 8.0 connection protocol ( auth with caching_sha2_password ) within the newer PHP versions. If you want to use mysql >= 8 and you dont care about caching_sha2_password, If you are running a fresh install of mysql 8, just select the second option as shown in the image. Otherwise, you need to configure MySQL 8.0 to run in mysql_native_password mode. As it can't configured in my.cnf, change the user profile as:- ALTER USER 'mysqlUsername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlUs...
Comments
Post a Comment