Laravel valet MySQL - PHP Artisan migrate stuck, no response

@rainieren Have you tried using localhost for DB_HOST instead?

Also check if mysql is running on the default port. You can do that using mysql -uroot then when within mysql run this command:

SHOW GLOBAL VARIABLES LIKE 'PORT';

it should be 3306.

So if you leave it like that it is just stuck forever, or does it exits after a while?

Hey @Nakov, It shows the right port. The command is just stuck forever, I left it on for more than 2 hours and nothing. I tried changing it to localhost but no luck.

@rainieren for one guy worked installing mysql through the official site instead of using brew, check that and see if it helps:

https://laracasts.com/discuss/channels/laravel/php-artisan-migrate-hangs-forever

@nakov I removed mysql by doing brew services stop mysql, brew unlink mysql and brew uninstall mysql and downloaded the .dmg file from Oracles website. Now whenever I want to do mysql -u root it says ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) and I can't connect anymore via the build-in database tool in PHPStorm while using the right password. which is rootroot. I updated my .env file and tried it all again but with no luck

Edit:: php artisan migrate now gives this:

Access denied for user 'root'@'localhost' (using password: YES) (SQL: select * from information_schema.tables where table_schema = rainierlaan and table_name = migrations and table_type = 'BASE TABLE')

@rainieren okay, but you've got the same response now from both sides :)

Take a look at this now:

https://tableplus.com/blog/2018/11/what-is-the-default-username-password-in-mysql.html

@nakov sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking & does nothing

@rainieren you are following the post completely right? Because that command should start the mysql server without a need for a password..

Please read the whole article.

I did read the whole article and tried the steps but It does not the start mysql server. The commandline outputs this:

rainierlaan@MacBook-Pro-van-Rainier rainierlaan % sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &
[2] 61723
rainierlaan@MacBook-Pro-van-Rainier rainierlaan % sudo: /usr/sbin/mysqld: command not found

[2]    exit 1     sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking
rainierlaan@MacBook-Pro-van-Rainier rainierlaan % 

You stopped the service first, and then you tried that one? I am trying it myself as well, it works as it should.

I did not stop any service? I just ran the command as it says on the website and that is my result.

@rainieren can you try this GIST then

https://gist.github.com/zubaer-ahammed/c81c9a0e37adc1cb9a6cdc61c4190f52

BTW, on the website it says this

Stop the MySQL server if it is running, then restart it with the –skip-grant-tables option.

So it does say to STOP first :)

I followed the exact steps and again with no luck. I turned off MySQL server and ran the command and proceeded to connect to my database but can't

rainierlaan@MacBook-Pro-van-Rainier rainierlaan % sudo mysqld_safe --skip-grand-tables                                 
Logging to '/usr/local/mysql/data/MacBook-Pro-van-Rainier.local.err'.
2019-12-28T15:31:35.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
2019-12-28T15:31:37.6NZ mysqld_safe mysqld from pid file /usr/local/mysql/data/MacBook-Pro-van-Rainier.local.pid ended
rainierlaan@MacBook-Pro-van-Rainier rainierlaan % mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
rainierlaan@MacBook-Pro-van-Rainier rainierlaan % mysql -u root root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
rainierlaan@MacBook-Pro-van-Rainier rainierlaan % 

@rainieren try to start it using:

mysql.server start  

No luck. Command not found

@rainieren Are you sure you've setup a password when you installed it, because by default it has just a root user and no password.

If you did, then try reinstalling again, don't know what else to tell you. Btw, for each step that you have shown me I googled the error, so many responses. So use that as well.