MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user

by

Do not grant all privileges over all databases to a non-root user, it is not safe (and you already have “root” with that role)

GRANT <privileges> ON database.* TO 'user'@'localhost' IDENTIFIED BY 'password';

This statement creates a new user and grants selected privileges to it.
I.E.:

GRANT INSERT, SELECT, DELETE, UPDATE ON database.* TO 'user'@'localhost' IDENTIFIED BY 'password';

Take a look at the docs to see all privileges detailed

EDIT: you can look for more info with this query (log in as “root”):

select Host, User from mysql.user;

To see what happened

More Related Contents:

  1. Access denied for user ‘root@localhost’ (using password:NO)
  2. brew install mysql on macOS
  3. How can I restore the MySQL root user’s full privileges?
  4. How to reset mysql root password?
  5. MySQL – ERROR 1045 – Access denied
  6. Access denied for user ‘root’@’localhost’ while attempting to grant privileges. How do I grant privileges?
  7. MYSQL into outfile “access denied” – but my user has “ALL” access.. and the folder is CHMOD 777
  8. access denied for load data infile in MySQL
  9. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  10. Mysql permission errors with ‘load data’
  11. get first occurrence of last changed value of a column [closed]
  12. ROW_NUMBER() in MySQL
  13. How can I temporarily disable a foreign key constraint in MySQL?
  14. What is the MySQL VARCHAR max size?
  15. sql joins as venn diagram
  16. How can I join multiple SQL tables using the IDs?
  17. Selecting random rows with MySQL
  18. JavaFX MySQL connection example please
  19. mysql select int as currency or convert int to currency format?
  20. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  21. How to integrate Apache Spark with MySQL for reading database tables as a spark dataframe? [closed]
  22. How to set a MySQL row to READ-ONLY?
  23. Finding number position in string
  24. Why does MySQL autoincrement increase on failed inserts?
  25. error code 1292 incorrect date value mysql
  26. How to search for rows containing a substring?
  27. Import CSV to Update only one column in table
  28. Error in MySQL library for Node.js
  29. List of Constraints from MySQL Database
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment