mysql-8.0 Archives - IT Nursery

PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client [duplicate]

This question already has answers here: php mysqli_connect: authentication method unknown to the client [caching_sha2_password] (15 answers) Closed 2 years ago. I’m running … Read more

How to grant all privileges to root user in MySQL 8.0

by IT Nursery

Tried mysql> GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘root’ WITH GRANT OPTION; Getting ERROR 1064 (42000): You have an error … Read more

Authentication plugin ‘caching_sha2_password’ cannot be loaded

by IT Nursery

I am connecting MySQL – 8.0 with MySQL Workbench and getting the below error: Authentication plugin ‘caching_sha2_password’ cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image … Read more