Connecting to another instance or setting up your local instance

If you want to connect to a different MySQL instance other than the one we just installed together, then you can click the + sign next to MySQL Connections in MySQL Workbench:

Then, fill in your connection information, including Connection Name, Hostname, Port (3306 by default in MySQL), Username, and Password. Afterward, click Test Connection to make sure it will connect successfully before clicking OK.

To set up the local instance, use the settings shown in the following screenshot:

MySQL Workbench should look something like the following when you open it for the first time:

You can change the layout of MySQL Workbench by using the View menu, as shown in the following screenshot:

You can choose to hide the navigator (the Hide Sidebar option), hide the SQL additions (the Hide Secondary Sidebar option), and hide the output (the Hide Output Area option). 

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.128.78.30