Level 3
Does typing "php artisan" in terminal respond?
Aug 4, 2018
3
Level 1
php artisan migrate stuck at the beginning
[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.
What can it be?
Level 1
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!
Level 73
MySQL 8 is a big no no at the moment unless you install it with 5.7 authentication.
1 like
Please or to participate in this conversation.