Connect to mysql on Amazon EC2 from a remote server

by

as mentioned in the responses above, it could be related to AWS security groups, and other things. but if you created a user and gave it remote access ‘%’ and still getting this error, check your mysql config file, on debian, you can find it here: /etc/mysql/my.cnf and find the line:

bind-address            = 127.0.0.1

and change it to:

bind-address            = 0.0.0.0

and restart mysql.

on debian/ubuntu:

/etc/init.d/mysql restart

I hope this works for you.

More Related Contents:

  1. Amazon EC2, mysql aborting start because InnoDB: mmap (x bytes) failed; errno 12
  2. Can’t connect to RDS instance from EC2 instance
  3. mysql_fetch_array() expects parameter 1 to be resource, boolean given in [closed]
  4. How to group by two rows in a column
  5. When I want to install MySQL I faced this issue “root account password” I forgot it
  6. How to perform grouped ranking in MySQL
  7. How to abort INSERT operation in MySql trigger?
  8. Restoring MySQL database from physical files
  9. Mysql or/and precedence?
  10. MySQL Trigger after update only if row has changed
  11. MySQL “Group By” and “Order By”
  12. MySQL Query to select data from last week?
  13. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  14. Migrate from Oracle to MySQL
  15. Which is more efficient: Multiple MySQL tables or one large table?
  16. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  17. Looping Over Result Sets in MySQL
  18. How to get the latest record in each group using GROUP BY? [duplicate]
  19. MySQL Data Source not appearing in Visual Studio
  20. MySQL JSON: How to find object from key value
  21. Advanced MySql Query: Update table with info from another table
  22. Commit data in a mysql container
  23. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  24. Why MySQL is giving error “Not allowed to return a result set from a function”?
  25. Where I can find a list of “mysqldump” exit codes?
  26. In MySQL what does “Overhead” mean, what is bad about it, and how to fix it?
  27. What is the MAX number if I store int(255) in MySQL?
  28. How to initialize mysql container when created on Kubernetes?
  29. Find duplicates in the same table in MySQL
  30. Auto-increment is not resetting in MySQL

Leave a Comment