Each table should always have an ID field that is configured as a Primary Key. It’s OK to leave this blank if you haven’t created a database yet or don’t want one to load by default.įields are the columns of a table which hold the information that you want to store.

If you don’t store it here, then Workbench will prompt for it each time.ĭefault Schema - This is the default database to connect to. Password - This is the database user’s password. If you just installed MySQL, this will be root. Username - This is the database username. MySQL Server Port - Leave this as 3306 unless you changed the MySQL port number. MySQL Hostname - Leave this as 127.0.0.1, which indicates the database is running on your Linode. SSH Key File - If you use an SSH key pair instead of a password, you can point Workbench to your key file through this setting. If you don’t provide it, then Workbench will prompt for it each time. SSH Password - You can store your password for the SSH connection here if you want to. If you use a non-standard port (other than 22), add it to the end following a colon (example: 203.0.113.0:2222). SSH Hostname - The IP address of your Linode. Alternatively, some distributions have MySQL Workbench in their repositories.Ĭonnection Name - This is the name of the connection for your reference only.Ĭonnection Method - Set this to Standard TCP/IP over SSH. rpm packages available on the Workbench download page. You can find instructions for this and the recommended prerequisites for your particular Linux distribution in the MySQL index of our Guides and Tutorials pages.ĭownload and install MySQL workbench from the downloads page of the MySQL website. You will need MySQL installed on your Linode.As you explore and manipulate your data using this tool, you’ll discover many more features and shortcuts that can make managing your databases that much easier. This guide is only a start to its capabilities.

MySQL Workbench is a very handy tool for database administration. Workbench is available for Linux, OS X and Windows, and runs directly on your desktop in a client/server model with your MySQL backend. This guide will show you how to get started using MySQL Workbench, a graphical tool for working with MySQL databases.

How to open mysql workbench on mac