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

I’m running MySQL version 8 on PHP 7.0.

I’m getting the following error when I try to connect to my database from PHP:

Connect Error: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

PHP might show this error

Warning: mysqli_connect(): The server requested authentication method unknown to the client [caching_sha2_password] in D:\xampp\htdocs\reg\server.php on line 10

How can I fix this problem?

Related Posts:

  1. How to log in to phpMyAdmin with WAMP, what is the username and password?
  2. Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
  3. Fatal error: Call to undefined function mysql_connect()
  4. PDOException SQLSTATE[HY000] [2002] No such file or directory
  5. http://localhost:80 is not working on running Apache server through UniServer ZeroXIII
  6. PDOException SQLSTATE[HY000] [2002] No such file or directory
  7. Mysql query- How to use contains?
  8. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
  9. Invalid column count in CSV input on line 1 Error
  10. Invalid column count in CSV input on line 1 Error
  11. $wpdb->update or $wpdb->insert results in slashes being added in front of quotes
  12. PDO with INSERT INTO through prepared statements
  13. phpMyAdmin: secret passphrase?
  14. PDO bindParam() with prepared statement isn’t working
  15. Forbidden :You don’t have permission to access /phpmyadmin on this server
  16. Creating a search form in PHP to search a database?
  17. How can I do ‘insert if not exists’ in MySQL?
  18. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  19. MySqli Commands out of sync; you can’t run this command now
  20. Trying to get property of non-object in
  21. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  22. Getting connection failed: php_network_getaddresses: getaddrinfo failed: Name or service not known
  23. Commands out of sync; you can’t run this command now
  24. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  25. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  26. How can I do ‘insert if not exists’ in MySQL?
  27. Object of class DateTime could not be converted to string
  28. What does it mean to escape a string?
  29. Convert from MySQL datetime to another format with PHP
  30. MAMP “Apache couldn’t be started because port is in use.” AND “Can’t connect to local MySQL server through /tmp/mysql.sock
  31. mysqli::query(): Couldn’t fetch mysqli
  32. Unexpected Exception: SQLSTATE[HY000] [1045] Access denied for user ****@’localhost’ (using password: YES)
  33. Uncaught Error: Call to undefined function mysql_escape_string()
  34. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in
  35. Call to a member function on null?
  36. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  37. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given
  38. MySQL query to get column names?
  39. What does MYSQLI_NUM mean and do?
  40. Mysql where id is in array
  41. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  42. What is the advantage of using try {} catch {} versus if {} else {}
  43. select * from table where column = value ^ column2= value
  44. Deprecated: mysql_query() [duplicate]
  45. No query results for model [App\Products] Laravel
  46. Fatal error: Call to a member function query() on null
  47. mysqlworkbench giving version error on exporting database
  48. How to make DROP INDEX IF EXISTS for mysql?
  49. What is the meaning of sprintf(): Too few arguments
  50. Having a problem getting mysqli_query to execute
  51. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  52. Can I store images in MySQL 
  53. MySQL Daemon Failed to Start – centos 6
  54. How to insert TIMESTAMP into my MySQL table?
  55. How to remove index.php from WordPress site URL
  56. PHP Like thing similar to MySQL Like, for if statement?
  57. How get value from URL
  58. How to use Memcached with PHP7?
  59. select count(*) from table of mysql in php
  60. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ””)’ at line 2
  61. “Notice: Undefined variable”, “Notice: Undefined index”, and “Notice: Undefined offset” using PHP
  62. PHP random string generator
  63. What are the differences in die() and exit() in PHP?
  64. How to prevent Browser cache for php site
  65. what does a .php?id=&value=value means?
  66. Setting up a PHP interpreter in PhpStorm
  67. Get Current URL in Magento and show something
  68. Creating default object from empty value in PHP?
  69. Send attachments with PHP Mail()?
  70. XAMPP, using port:81, cannot run localhost:81/mywebsite
  71. Is there any way to test PHP locally without installing a server?
  72. PHP Redirect with POST data
  73. Getting the screen resolution using PHP
  74. PHP Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/website/public_html/facebook/fbclogin.php on line 57 [duplicate]
  75. PHP: fopen() Permission denied
  76. How should I be setting browscap.ini file
  77. Generate PDF from HTML PHP
  78. Call to a member function fetch_assoc() on boolean in [duplicate]
  79. Remove empty array elements
  80. Auto increment in phpmyadmin
  81. is it possible to run some php code within a wordpress page?
  82. How to implement WP_List_Table? WP_List_Table giving array instead of a value in listing table
  83. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  84. Is the outdated PHP mysql extension a requirement for WordPress 4.6?
  85. How can I export posts with featured images, without download them
  86. Calculating a large number of MYSQL queries as customshort codes, slow
  87. Make a database query using WordPress
  88. Add row to custom database Table and delete all rows older than 1 day
  89. How to get the custom field value using SQL query
  90. Please help! I have a problem with getting wordpress databas
  91. Conditional formatting on data fetched from MYSQL
  92. Can I split a huge wp_postmeta table across different databases or servers?
  93. WordPress mysql deos not work with php7
  94. WP + MySql db / PHP
  95. append data to mysql table via submit button coded in php – not working
  96. How to do a MySql query in WordPress?
  97. Send data from plugin to external database
  98. How to set max users to 17.000
  99. directorypress theme error mysql_error() [closed]
  100. Parse error: syntax error, unexpected ‘}’ in C:\xampp\htdocs\admin\products.php on line 148 [closed]

Leave a Comment