{"id":740,"date":"2019-10-04T15:53:42","date_gmt":"2019-10-04T14:53:42","guid":{"rendered":"https:\/\/blogs.gre.ac.uk\/cmssupport\/?page_id=740"},"modified":"2019-10-04T15:53:42","modified_gmt":"2019-10-04T14:53:42","slug":"connect-to-mysql-using-mysql-workbench","status":"publish","type":"page","link":"https:\/\/blogs.gre.ac.uk\/cmssupport\/application-development\/databases\/mysql\/connect-to-mysql-using-mysql-workbench\/","title":{"rendered":"Connect to MySQL using MySQL Workbench"},"content":{"rendered":"\n<p>MySQL Workbench is installed on the computers in the <a href=\"https:\/\/blogs.gre.ac.uk\/cmssupport\/the-king-william-labs\/\" data-type=\"page\" data-id=\"28\">King William labs<\/a>, and also on the <a href=\"https:\/\/blogs.gre.ac.uk\/cmssupport\/virtual-desktop\/\" data-type=\"page\" data-id=\"36\">CMS virtual desktop<\/a>. Please see the instructions below for connecting to your MySQL database in it.<\/p>\n\n\n\n<p>1. Open up MySQL Workbench, then click the plus sign next to &#8216;MySQL Connections&#8217;.<\/p>\n\n\n\n<p>2. Fill in the details (as shown). Replace the username shown with your own username. Click the &#8216;Test Connection&#8217; button, then click the &#8216;OK&#8217; button.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"791\" height=\"497\" src=\"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-content\/uploads\/sites\/18\/2021\/09\/MySQL-workbench-connection.png\" alt=\"\" class=\"wp-image-1726\" srcset=\"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-content\/uploads\/sites\/18\/2021\/09\/MySQL-workbench-connection.png 791w, https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-content\/uploads\/sites\/18\/2021\/09\/MySQL-workbench-connection-300x188.png 300w, https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-content\/uploads\/sites\/18\/2021\/09\/MySQL-workbench-connection-768x483.png 768w, https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-content\/uploads\/sites\/18\/2021\/09\/MySQL-workbench-connection-557x350.png 557w, https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-content\/uploads\/sites\/18\/2021\/09\/MySQL-workbench-connection-150x94.png 150w\" sizes=\"auto, (max-width: 791px) 100vw, 791px\" \/><\/figure><\/div>\n\n\n\n<p>3. Double click the connection on the home screen, then enter your password when prompted. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"414\" height=\"214\" src=\"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-content\/uploads\/sites\/18\/2021\/09\/MySQL-Password-Prompt.png\" alt=\"\" class=\"wp-image-1728\" srcset=\"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-content\/uploads\/sites\/18\/2021\/09\/MySQL-Password-Prompt.png 414w, https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-content\/uploads\/sites\/18\/2021\/09\/MySQL-Password-Prompt-300x155.png 300w, https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-content\/uploads\/sites\/18\/2021\/09\/MySQL-Password-Prompt-150x78.png 150w\" sizes=\"auto, (max-width: 414px) 100vw, 414px\" \/><\/figure><\/div>\n\n\n\n<p>4. You should now be able to query your database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL Workbench is installed on the computers in the King William labs, and also on the CMS virtual desktop. Please see the instructions below for connecting to your MySQL database in it. 1. Open up &hellip;<\/p>\n","protected":false},"author":53,"featured_media":0,"parent":140,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-740","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/740","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/comments?post=740"}],"version-history":[{"count":0,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/740\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/pages\/140"}],"wp:attachment":[{"href":"https:\/\/blogs.gre.ac.uk\/cmssupport\/wp-json\/wp\/v2\/media?parent=740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}