Stephen's avatar

MySQL 8 or MySQL 5.x for new projects?

Just curious what everyone is choosing for new projects at this point MySQL 8 or MySQL 5? If you choose MySQL 8 what gotchas, if any, exist in Laravel 6? Finally, do you find MySQL 8 to be well documented and community-supported where you can find help with common issues? I want to switch to 8 but MySQL 5 has always been so easy to work on.

0 likes
3 replies
Stephen's avatar

For anyone finding this thread, one gotcha I ran into was that MySQL 8 uses an updated authentication method that PHP doesn't yet support thus causing artisan migrations to fail. Running this command on the database fixes the issue as of October 2019:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Please or to participate in this conversation.