----- EDIT ---------------------------------
The reason of this edit is that my first post was not pointing out the right issue. The new post below should be more accurate.
I am using Laravel so I have to know the ip address of my database, which is host by Alwaysdata.
How can I find the ip address of my database?
I already searched how to get it, but found only how to get the hostname, which can defenitly not be resolved into the database host IP.
----- OLD POST ---------------------------------
Title: How to use a non local MySQL database with Laravel?
I am making a website using Laravel and now need to use a database. I want to use Laravel migrations to manage the database.
So I tried to run the command php artisan migrate:install
but got an error telling me that database access has been denied.
My database is a MySQL database. I use online phpmyadmin (actually I am using alwaysdata which uses phpmyadmin for databases).
Here is my database config in the Laravel .env
file:
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=my_database
DB_USERNAME=my_username
DB_PASSWORD=***********
I am sure about the database name, as well as my username and password. The database port should be right as I checked it, but I can't find the host of my database.
I already searched how to get it, but found only how to get the hostname, which can defenitly not be resolved into the database host IP.
Does anyone know how to use Laravel along with an externally-hosted MySQL database?