Where is MySQL database located?

Question

Hello all,

I'm trying out aws and wasn't able to figure out where exactly is the SQL database located for my Wordpress website.
In other hosting companies, it's usually under cPanel. But here in Lightsail, I can't see it anywhere.

I'm running the bare min EC2 instance with Wordpress installed.

Answer

Hi,

I d suggest To look into this doc: https://lightsail.aws.amazon.com/ls/docs/en_us/articles/amazon-lightsail-connecting-to-your-mysql-database.

Hope it helps ;(

Answer

To access the database on your Wordpress instance, SSH into the instance and run the following command:
```
sudo mysql -u root -p
```

You can get the credentials by running:
```
sudo cat /home/bitnami/bitnami_credentials
```

To connect your WordPress website to a MySQL managed database in Amazon Lightsail, follow the steps provided here: 
https://lightsail.aws.amazon.com/ls/docs/en_us/articles/amazon-lightsail-connect-wordpress-to-mysql-managed-database.

Where is MySQL database located?

Contenido relevante