MySQL Bugs: #98016: Unable to Connect MySQL 8 with User created by mysql_native

Bug #98016	Unable to Connect MySQL 8 with User created by mysql_native_password
Submitted:	18 Dec 2019 1:41	Modified:	18 Dec 2019 3:45
Reporter:	kkumar Santosh	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Connection Handling	Severity:	S2 (Serious)
Version:	8	OS:	Red Hat
Assigned to:		CPU Architecture:	x86

Description:
Hi, I have recently upgraded my MySQL to 8. I have a web application which is in PHP and as PHP is unable to use "caching_sha2_password" to connect MySQL so I have created a user with msql_native_password.

My application is working fine but issue is I am not able to connect with that user using the command line. 

How to repeat:
Create mysql user with mysql_native_password
Try to connect using command
mysql -uUSER -pPASSWORD DATABASE_NAME -A

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

For details on getting support for MySQL products see http://www.mysql.com/support/
You can also check our forums (free) at http://forums.mysql.com/

Thank you for your interest in MySQL.

hi!

PHP 7.4 seems to support caching_sha2_password:
 https://lefred.be/content/mysql-8-0-php/

By the way, what platform and PHP version are you using?