I am learning AWS EC2 to host my website made on WordPress, Laravel and custom PHP scripts.
I created a t2.small instance with ubuntu 18.04 as my OS.
Then I read tutorials and Installed the latest version of Ngnix server, MySQL 8, and PHP 7.3. I was able to configure them and everything work fine.
Then I created a new MySQL user and database. granted the user all permission for the database and also checked it using command line via SSH. Everything works fine.
I created a new server block in nginx and configured my domain, migrated the site(WordPress). Changed the database username, password (the one that I created) in
wp-config.php. But when I accessed my domain I am getting
Error establishing a database connection
I doubled check the database details and setting, everything is fine. Then why PHP script is not able to connect with the database?
I am missing something? I think I don't need to open port 3306? Since my database host is
localhost, I don't need to open it right?