Laravel 5.2 How to authenticate with a real mysql database

Question

I'm new with laravel, I read the documentation of laravel, but I don't know how I make an authentication with a real mysql database. I mean, I see that there is a php migration command, but it makes a table in php and not in my database right ? Actually, I have a mysql database with a user table with login and password. I'm lost with this framework, because I never used a php framework.

Thanks !!

Edit : Excuse me, I misspoke and my problem has evolved, how did you to authenticate with a user table already exists in the database by using the Authentication service?

You need to configure your db connection in .env file. Then Laravel 5.2 can create auth for you php artisan make:auth — GONG
– GONG, Commented Jun 10, 2016 at 10:50

Himanshu Raval · Accepted Answer · 2016-06-10 10:50:03Z

3

in .env or config>database.php you can set your database and related database connections configurations after that create migrations and run them it will create database tables in your database as per your .env or config>database.php database configurations.

edited Jun 10, 2016 at 10:50

answered Jun 10, 2016 at 10:46

Himanshu Raval

8119 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

19 Comments

GONG Over a year ago

Don't use database.php. Use .env instead

KhoyaDev Over a year ago

thank you for your reply, I set my database but If I already have a table user in my database, is the migration command will delete my table ?

haakym Over a year ago

Doesn't deserve a downvote, you can use config/database.php or .env

GONG Over a year ago

@haakym sure, but if u will share 1 connection accross all team, its not cool.

Himanshu Raval Over a year ago

drop your table and run your migrations. @KhoyaDev

|

ga.breban · Accepted Answer · 2016-06-10 11:44:11Z

1

I think you might need to read again Laravel documentations.

Try the following.

Make sure you have a database create in your MySql.
Check again your .env for: database_host, database_name, database_user, database_password - make sure you have the right
Try bellow code on your route.php

Route::get('/', function () { if(DB::connection()->getDatabaseName()) { echo "Yes! successfully connected to the DB: " . DB::connection()->getDatabaseName(); } });
If above is successful your migration should work.

edited Jun 10, 2016 at 11:44

answered Jun 10, 2016 at 11:39

ga.breban

3061 silver badge5 bronze badges

1 Comment

KhoyaDev Over a year ago

Thank you, this is well explained !

Collectives™ on Stack Overflow

Laravel 5.2 How to authenticate with a real mysql database

2 Answers 2

19 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

19 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related