Laravel From Scratch: Part 4 - Database Setup and Sequel Pro

In this episode, we'll review the process of creating a new database in MySQL, connecting to it (via our .env config), and then setting up any database GUI, such as Sequel Pro.

[kamalalhomsi]

Thanks so much, it is a really great tutorial, but there is something weird how you can be with this fast while using your OS, You are the fastest one I have seen ever!

[jims]

When I run the 'php artisan migrate'-command. It does nothing, the terminal just returns a blank line. Also connection through Sequel Pro doesn't work: 'Socket connection failed!'. Anyone has a clue what I should do? Thanks!

[WyzrdCat]

php artisan migrate gives me mad errors :(
SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
The server requested authentication method unknown to the client [caching_sha2_password]")
PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=laravel", "root", "", [])

[rkraiem]

For anybody who's using something like filezilla to remote into a server and following this guide, your probably confused like I was. I did a bit of research on databases and filezilla and I'm pretty sure that if your connecting remotely to the server, you can't connect to the database. I'm still very new to a lot of this so I could be entirely wrong but I felt like mentioning it incase anybody is watching this and is having a hard time following this step like I was.

[ananthukkumar]

dO YOU HAVE THE ENTIRE TOPICS FROM 'BASICS', 'FDATABSE', 'SECURITY', ' FRONTEND ' from laravel documents covered here.