Enable remote MySQL connection: ERROR 1045 (28000): Access denied for user

by

You have to put this as root:

GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD' with grant option;

;

where IP is the IP you want to allow access, USERNAME is the user you use to connect, and PASSWORD is the relevant password.

If you want to allow access from any IP just put % instead of your IP

and then you only have to put

FLUSH PRIVILEGES;

Or restart mysql server and that’s it.

More Related Contents:

  1. In SQL Server how to get the count of child if both parent and child are available [closed]
  2. Get a list of dates between two dates
  3. Calculate a running total in MySQL
  4. ERROR 2006 (HY000): MySQL server has gone away
  5. Create table variable in MySQL
  6. Does MySQL index foreign key columns automatically?
  7. GROUP_CONCAT ORDER BY
  8. MySQL LIMIT clause equivalent for SQL SERVER
  9. How to get the next auto-increment id in mysql
  10. Importing a csv into mysql via command line
  11. MySQL: ALTER TABLE if column not exists
  12. Find and Replace text in the entire table using a MySQL query
  13. Can I reuse a calculated field in a SELECT query?
  14. MySQL SELECT increment counter
  15. Error Code: 1215. Cannot add foreign key constraint (foreign keys)
  16. Query from two tables in report
  17. Is it safe to store usernames and passwords in the database?
  18. How do I get SUM function in MySQL to return ‘0’ if no values are found?
  19. ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading authorization packet’, system error: 0
  20. Compare only day and month with date field in mysql
  21. mysql, ifnull vs coalesce, which is faster?
  22. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  23. MySQL delimiter syntax error
  24. UPDATE with ORDER BY and LIMIT not working in MYSQL
  25. Can a MySQL query turn rows into columns?
  26. How long is the SHA256 hash?
  27. Correct way to keep pooled connections alive (or time them out and get fresh ones) during longer inactivity for MySQL, Grails 2 app
  28. MySQL: Setting sql_mode permanently
  29. MySQL: how to index an “OR” clause
  30. Is it possible to count two columns in the same query

Leave a Comment