From the course: Linux for PHP Developers
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Managing databases with MySQL Workbench
From the course: Linux for PHP Developers
Managing databases with MySQL Workbench
- [Instructor] We've set up the MySQL server itself, but we haven't put any data into it yet. I'm going to demonstrate how to manage the server with a MySQL client called MySQL Workbench. I prefer using native MySQL clients for large datasets, but you should use whatever tool best meets your needs. Let's see it in action. Open MySQL Workbench. Then click + to create a new MySQL connection. For the connection name let's use Sandbox. For the hostname the default will work, but let's switch it to sandbox.dev. Earlier, we forwarded the port to a nonstandard port, so let's make the change here as well, 9306. Click Store in Keychain, or the equivalent. And enter the password you used. I used root. Click OK. Then click Test Connection, to make sure everything is correct. Great, it's working! Click OK, then OK. Now that we've created the connection, let's use it. Click Sandbox. We're connected. Click Server Status to get a high level overview of what the server is doing. In the center, I can…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.