Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to connect to mysql with laravel?

This is such a simple basic question I don't think there is much people asking this but simply how do I connect to mySql through localhost phpmyadmin with laravel (I've searched, there is some stuff, but I need to ask because I am a noob and I'd like to ask, the stuff I saw I don't quite get 100% or I tried and it didn't help)?

I am working with backbone.js and am brand new to laravel, I installed laravel inside C:\wamp\www\laravel-project

I tried

c:\wamp\www\laravel-project> php artisan migrate:make create_tasks_table --table tasks --create 

And

c:\wamp\www\laravel-project> php artisan migrate 

I expect to have to define the database information, I checked C:\wamp\www\laravel-project\app\config\database.php and it looks correct, mySQL is set on the defaults root being the user name, and '' empty being the password.

The error in the command line I get after running php artisan migrate is

[PDOException] SQLSTATE[HY000] [1049] Unknown database 'database'     

I am using windows 8, and wamp for my localhost server, it of course includes phpmyadmin and mySql. So I am sure there are tons of ways to use mySql but I don't think I am setting up laravel and phpmyadmin properly.

So any insight would be amazing, easy points.

EDIT:

Actually thinking this through maybe I need to create a database named database let me try that. be back soon. Okay I'll answer my question or someone can, just in case someone searches this topic... it is KEY to make sure the database defined in C:\wamp\www\laravel-project\app\config\database.php matches a database that exists inside your phpmyadmin. No brainer!

like image 376
Michael Joseph Aubry Avatar asked Nov 26 '13 04:11

Michael Joseph Aubry


People also ask

How does Laravel connect to local database?

Laravel makes connecting with databases and running queries extremely simple. The database configuration file is app/config/database. php . In this file you may define all of your database connections, as well as specify which connection should be used by default.

Can Laravel connect to SQL Server?

Laravel makes connecting with SQL Server database and running queries extremely simple out of the box. The SQL Server, MSSQL database configuration for your application is located at Laravel Project Root Folder, config/database.

How can check DB connection in Laravel?

Echo the Laravel database name in Blade/PHP The simplest way it to place the following script in a Blade or PHP file. This will output the name of the database or return 'none' if there is no connection. If you view it in the browser, it gives you the name of the connected database.


1 Answers

In Laravel 5, there is a .env file,

It looks like

APP_ENV=local APP_DEBUG=true APP_KEY=YOUR_API_KEY  DB_HOST=YOUR_HOST DB_DATABASE=YOUR_DATABASE DB_USERNAME=YOUR_USERNAME DB_PASSWORD=YOUR_PASSWORD  CACHE_DRIVER=file SESSION_DRIVER=file QUEUE_DRIVER=sync  MAIL_DRIVER=smtp MAIL_HOST=mailtrap.io MAIL_PORT=2525 MAIL_USERNAME=null MAIL_PASSWORD=null 

Edit that .env There is .env.sample is there , try to create from that if no such .env file found.

like image 66
Mohammed Safeer Avatar answered Sep 22 '22 06:09

Mohammed Safeer