今天就学习课程吧!
今天就开通帐号,24,700 门业界名师课程任您挑!
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…
随堂练习,边学边练
下载课堂讲义。学练结合,紧跟进度,轻松巩固知识。