Search code examples
phplaravellaravel-5laravel-artisanartisan-migrate

php artisan migrate stuck at the beginning of the command

[MacOS 10.14.0] When I create a new project (Laravel new blog) Then create a table in MySQL (create database blog) And then update my .env file with the correct userame, password and database.

After creating a project, I will run php artisan migrate But my terminal stays empty, I can type in my terminal. But it won't do anything.

My storage/logs folder is empty.

I have 2 default migrate files in my database/migrations folder.

php migrate list works

What can it be?

Solution

  • After a lot of trial and error, I found out that there was something wrong with my MySQL server. I reinstalled MySQL with brew. The latest version of 8 and the latest version of 5.7.*. Both didn't work, because of the following conflict: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found.

    So the whole time, everything in my .env file was correct but my MySQL was broken. I also confirmed that by trying to connect with the app 'Sequel Pro'. And as I thought, it gave me the same conflict.

    How I fixed the problem:

    • Remove all MySQL/MariaDB packages via brew (if you have installed them with brew like me)
    • Install MySQL Community Server 5.7.* from the official mysql.com website (you can google that file).
    • Add MySQL to your path export PATH=$PATH:/usr/local/mysql/bin
    • Go to: System Preferences -> MySQL -> press 'Start MySQL Server'
    • Change your temporary password with a new one mysqladmin -uroot -p[temporary password] password '[new password]'

    Good luck! 👍

    EDIT FEBRUARY 26 2019:
    I found a problem with changing the random generated password. I was using MySQL Community Server 5.7.25 and the random generated password was: _>9mxWc9a!0.. When I was trying to change the default password with the command above. I was given the following error:
    -bash: !0: event not found
    If you have the same error as I did or something similar, try the following:

    • Enter the following command in your terminal: mysqladmin -uroot -p password '[new password]'
    • When you press enter, it will ask you for a password. Now enter the random generated password that was given to you by the MySql Community Server at installation in a prompt.

    It should be working now! 😊