Laravel Homestead- MySQL default credentials and database

Question

I have setup Laravel and trying to run the artisan migrate command however I am getting the error below

[PDOException] SQLSTATE[HY000] [2002] Connection refused.

I am not sure how db is setup in Homestead. So I got the below questions.

Is default database created automatically by artisan migrate or Homestead?
If it is, what is the name of it?
If its not created by default, should we create before running migration?

I tried logging in to MySQL db by connecting to Homestead VM using ssh and then running MySQL. However I get error Access denied for user.... for user name vagrant, Homestead and forge.

What is the default credentials? I understand that creating MySQL db is out of the scope of Laravel tutorial; So it would be helpful if anyone can answer these questions and point me in right direction.

score 74 · Accepted Answer · edited May 16 '16 at 00:14

74

Homestead comes with a default database called homestead. Your app can either choose to hook into that database, or you will have to go and make a new database manually. You can either use a GUI (like Sequel Pro on Mac) or perform it via the command line through Vagrant.

// SSH into the box
vagrant ssh

// Connect to MySQL as the homestead user (password is: secret)
mysql -u homestead -p

// Create a new database in MySQL
CREATE DATABASE your_app_name;

// Leave MySQL
exit;

You can then migrate the database as usual, php artisan migrate.

If you need to do this with Postgres instead, it's pretty similar.

// Connect to Postgres (password is: secret)
psql -U homestead -h localhost

// Create a new database in Postgres
CREATE DATABASE your_app_name;

// Leave Postgres
\q

edited May 16 '16 at 00:14

Bikal Basnet

1,639
1
21
31

answered Aug 26 '14 at 10:41

Dwight

12,120
6
51
64

1

Thanks however artisan is giving error. I ran "php artisan migrate" inside the project root folder where I have the artisan. [ErrorException] Undefined variable: table – user859375 Aug 26 '14 at 11:19
The migration file had an issue, I fixed it. I forgot to use Schema::create call. Thanks. – user859375 Aug 26 '14 at 11:26
Thanks for homestead mysql credentials! – Alex Pogiba Aug 31 '17 at 06:49
3

In case this doesn't work, according to the documentation on Homestead the username is Homestead and the password is secret. https://laravel.com/docs/5.5/homestead see heading "Connecting To Databases". – Mr. Radical Jan 27 '18 at 16:26
so helpful. Good job! – Ewomazino Ukah Jul 04 '18 at 13:44
Exactly what I was looking for – Alan Steiman May 21 '20 at 14:16

Laravel Homestead- MySQL default credentials and database

1 Answers1

Linked