SQLSTATE[HY000] [1698] Access denied for user ‘root’@’localhost’

by

It turns out you can’t use the root user in 5.7 anymore without becoming a sudo‘er. That means you can’t just run mysql -u root anymore and have to do sudo mysql -u root instead.

That also means that it will no longer work if you’re using the root user in a GUI (or supposedly any non-command line application). To make it work you’ll have to create a new user with the required privileges and use that instead.

See this answer for more details.

More Related Contents:

  1. Undefined index $_POST
  2. Cannot connect to MySQL 4.1+ using old authentication
  3. PHP – Secure member-only pages with a login system
  4. Password_Hash not working on my PHP login
  5. PDOException SQLSTATE[HY000] [2002] No such file or directory
  6. PHP PDO: charset, set names?
  7. Deprecated: mysql_connect() [duplicate]
  8. What does it mean to escape a string?
  9. How to retract a salted password from the Database and auth user?
  10. Fetching data from MySQL database to HTML dropdown list
  11. How to build a RESTful API?
  12. How to solve General error: 2006 MySQL server has gone away
  13. Replacing mysql_* functions with PDO and prepared statements
  14. How to insert an array into a single MySQL Prepared statement w/ PHP and PDO
  15. Find Point in polygon PHP
  16. phpmyadmin automatic logout time
  17. unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING error [duplicate]
  18. Setting a connect timeout with PDO
  19. mysql_connect(): No connection could be made because the target machine actively refused it
  20. How to build a JSON array from mysql database
  21. How to display a date as iso 8601 format with PHP
  22. How to generate unique id in MySQL?
  23. Join two tables with comma separated values
  24. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  25. How to properly use Bearer tokens?
  26. Remotely connecting to a MySQL database
  27. Using Prepared Statement, how I return the id of the inserted row?
  28. Replacing \r\n with PHP
  29. How to check if a value already exists to avoid duplicates?
  30. How to use MySQL Found_Rows() in PHP?

Leave a Comment