php artisan migrate isn't working

Question

When I try to connect to my database i get this error

[PDOException]                                                               
SQLSTATE[HY000] [1045] Access denied for user 'loom'@'localhost' (using password: YES)

all my credentials are correct and when i change things up i get this error :

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

Can anyone help me sort this out please

my .env file

APP_ENV=local
APP_DEBUG=true
APP_KEY=xxxx

DB_HOST=localhost
DB_DATABASE=cl20-loom
DB_USERNAME=loom
DB_PASSWORD=xxxx

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
MAIL_ENCRYPTION=null

my database.php file :

'mysql' => [
        'driver'    => 'mysql',
        'host'      => 'localhost',
        'database'  => 'cl-loom',
        'username'  => 'loom',
        'password'  => '••••',
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
        'strict'    => false,
    ],

score 1 · Answer 1 · answered Nov 28 '15 at 16:11

1

It can be because the mysql service is not running or it isn't on the port 3306, in the last case you may specify the port where the mysql service is running as a attribute port of the mysql object in database.php file

answered Nov 28 '15 at 16:11

Kuki Amarilla

66
3

im a noob at this how would I check and change the sql port to 3306 and i am using Sequel pro to see my db – RyanM Nov 28 '15 at 16:16
You can check and change in the _my.ini_ file that's located in the mysql server installation folder – Kuki Amarilla Nov 28 '15 at 16:25
Thank you I will try it out and see what I get – RyanM Nov 28 '15 at 19:13
can't find the file 'my.ini' anywhere @Kuki Amarilla – RyanM Nov 28 '15 at 20:22

score 1 · Answer 2 · answered Nov 28 '15 at 17:51

1

If you are using mysql you have to create the database manually in phpMyAdmin or whatever software you are using for mysql.

And no need to change the whole database.php if you configure the .env file. Just change this line 'default' => env('DB_CONNECTION', 'mysql'), in database.php

Below code is not tested

Instead, you can add DB_CONNECTION=mysql this line in .env

answered Nov 28 '15 at 17:51

smartrahat

5,381
6
47
68

@techedryan If work, please don't forget to accept my answer. – smartrahat Nov 28 '15 at 19:50
what do i change it to @smartrahat – RyanM Nov 28 '15 at 20:23
@techedryan I don't get you. What are trying to do now? – smartrahat Nov 28 '15 at 21:52
I'm trying to migrate my database to a database following a tutorial online but I get the errors I showed in my post – RyanM Nov 28 '15 at 22:03
Did you create your database in `mysql`? – smartrahat Nov 28 '15 at 22:20
How do I create a database in MySQL cause my tutorial doesn't show how to do so it skips that part :( @smartrahat – RyanM Nov 28 '15 at 22:21
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/96444/discussion-between-smartrahat-and-techedryan). – smartrahat Nov 28 '15 at 22:22

score 1 · Accepted Answer · answered Dec 02 '15 at 00:00

1

I got this error last time create a database on phpmyadmin and change only the .env file to match with you phpmyadmin details and it will work.

answered Dec 02 '15 at 00:00

user5621121

26
2

php artisan migrate isn't working

3 Answers3