课程: Linux for PHP Developers

今天就学习课程吧!

今天就开通帐号,24,700 门业界名师课程任您挑!

Managing databases with MySQL Workbench

Managing databases with MySQL Workbench

课程: 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…

内容