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

by

@mohammed, this is usually attributed to the authentication plugin that your mysql database is using.

By default and for some reason, mysql 8 default plugin is auth_socket. Applications will most times expect to log in to your database using a password.

If you have not yet already changed your mysql default authentication plugin, you can do so by:
1. Log in as root to mysql
2. Run this sql command: 

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password
BY 'password';

Replace ‘password’ with your root password. In case your application does not log in to your database with the root user, replace the ‘root’ user in the above command with the user that your application uses.

Digital ocean expounds some more on this here Installing Mysql

More Related Contents:

  1. Php mysql tabs don’t output [closed]
  2. Update Mysql except when field not null
  3. How can I prevent SQL injection in PHP?
  4. UTF-8 all the way through
  5. SQL injection that gets around mysql_real_escape_string()
  6. Can I mix MySQL APIs in PHP?
  7. jQuery Validate remote method usage to check if username already exists
  8. MySQL query to get column names?
  9. How do you connect to multiple MySQL databases on a single webpage?
  10. PDO get the last ID inserted
  11. Pagination using MySQL LIMIT, OFFSET
  12. How to call a MySQL stored procedure from within PHP code?
  13. Best way to check if mysql_query returned any results?
  14. mysql_fetch_array return only one row
  15. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  16. Insert multiple rows with PDO prepared statements
  17. a better approach than storing mysql password in plain text in config file?
  18. mysql query result in php variable
  19. mysql_real_escape_string is undefined
  20. Unknown database error in PHP but it exists in PHPMyAdmin
  21. Can I blindly replace all mysql_ functions with mysqli_?
  22. How do detect that transaction has already been started?
  23. return multiple response data in one response
  24. CakePHP Database connection “Mysql” is missing, or could not be created
  25. MySQL Alter Table Add Field Before or After a field already present
  26. mysql error ‘TYPE=MyISAM’
  27. Storing datetime as UTC in PHP/MySQL
  28. Backup a mysql database and download as a file
  29. Is a BLOB converted using the current/default charset in MySQL?
  30. PHP/MySQL Pagination

Leave a Comment