Remote Database AWS EC2 Instance
So I configured a ec2 instance for my laravel project. I can ssh into the application through the command line with key, however trying to connect remotely from navicat keeps giving me the following alarm
2013 - Lost connection to MySQL server at 'waiting on initial communication packet'`
From what I found I accessed my database through the command line and use the follwing command
GRANT ALL PRIVILEGES ON *.* TO 'YourUserName'@'%' IDENTIFIED BY "YourPassword"
And then in my ec2 instance I navigated to the security group and opened port "3306" to all for Mysql/Aurora.
Is there some type of configuration I am not doing? From what I research it has something to do with the firewall of the ec2 instance but everything I have tried is not working. I have a separate database I am accessing from navicat with no issues however the application is being hosted at digital ocean..
Any ideas would be greatly appreciated!
Please or to participate in this conversation.