From the course: Databases for Node.js Developers

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

Exploring MySQL with MySQL Workbench

Exploring MySQL with MySQL Workbench - Node.js Tutorial

From the course: Databases for Node.js Developers

Start my 1-month free trial Buy for my team

Exploring MySQL with MySQL Workbench

“

- [Instructor] To make working with MySQL easier, and also to explore the data, we will use a graphically user interface. And this is MySQL Workbench. You can download it for your system on the MySQL website. Once you've done this, you can simply open it and it'll present you with this screen. There I now click on the plus icon at MySQL Connections. And here I will now define a connection that's very similar to what we did in MongoDB Compass. I will also call it course, and now we have to provide the connection information. The username is root, and we will also have to provide a password. So that's different to MongoDB, which can default to no password. So here I clicked on Store in Keychain, and there I use secret, this was the password I set when I created this container. I click on OK, then I click on Test Connection. It complains about compatibility, that's not a problem. Everything else looks good. Then I click on OK and I have a new database connection. Now I direct click on…

Contents