{"id":124,"date":"2007-08-16T23:28:13","date_gmt":"2007-08-17T03:28:13","guid":{"rendered":"http:\/\/www.eyoungwon.com\/journal\/?p=124"},"modified":"2007-08-17T21:53:51","modified_gmt":"2007-08-18T01:53:51","slug":"mysql-query-browser-connecting","status":"publish","type":"post","link":"https:\/\/eyoungwon.com\/journal\/mysql-query-browser-connecting\/","title":{"rendered":"MySQL &#8211; Query Browser Connecting"},"content":{"rendered":"<p>To be able to remotely access your MySQL databases, you have to allow access to the databases from your computer. To do so, visit whatismyip.com, and copy your IP address. Then, log in to cPanel, go to MySQL Databases and add your IP to the list of allowed hosts.<\/p>\n<p>The details to use for connecting to the database are:<\/p>\n<p>MySQL Username: [same as cPanel username]<br \/>\nMySQL Password: [same as cPanel password]<br \/>\nMySQL Host: yourdomain.com OR servername.com OR server.I.P.address<\/p>\n<p>(these can be found in the Manage Accounts section in your customer area on siteground.com)<br \/>\n<script type=\"text\/javascript\"><!--\ngoogle_ad_client = \"pub-5668217421182594\";\ngoogle_alternate_ad_url = \"http:\/\/store.templatemonster.com?aff=eacollin\";\ngoogle_ad_width = 468;\ngoogle_ad_height = 15;\ngoogle_ad_format = \"468x15_0ads_al_s\";\n\/\/2007-08-17: http:\/\/www.eyoungwon.com\/\ngoogle_ad_channel = \"2052199229\";\ngoogle_color_border = \"C3D9FF\";\ngoogle_color_bg = \"FFCC66\";\ngoogle_color_link = \"000000\";\ngoogle_color_text = \"333333\";\ngoogle_color_url = \"666666\";\n\/\/-->\n<\/script><br \/>\n<script type=\"text\/javascript\"\n  src=\"http:\/\/pagead2.googlesyndication.com\/pagead\/show_ads.js\">\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>To be able to remotely access your MySQL databases, you have to allow access to the databases from your computer. To do so, visit whatismyip.com, and copy your IP address. Then, log in to cPanel, go to MySQL Databases and add your IP to the list of allowed hosts. The details to use for connecting [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38,2],"tags":[],"class_list":["post-124","post","type-post","status-publish","format-standard","hentry","category-mysql","category-web-development"],"_links":{"self":[{"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/posts\/124","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/comments?post=124"}],"version-history":[{"count":0,"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/posts\/124\/revisions"}],"wp:attachment":[{"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/media?parent=124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/categories?post=124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/tags?post=124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}