{"id":920,"date":"2026-03-05T18:30:58","date_gmt":"2026-03-05T22:30:58","guid":{"rendered":"http:\/\/stephendavies.org\/cpsc350\/?p=920"},"modified":"2026-03-05T18:30:58","modified_gmt":"2026-03-05T22:30:58","slug":"accessing-the-galactic-database","status":"publish","type":"post","link":"http:\/\/stephendavies.org\/cpsc350\/?p=920","title":{"rendered":"Accessing the galactic database"},"content":{"rendered":"<p>Just to be clear, for <a href=\"assignment4.html\">assignment #4<\/a> you do <i>not<\/i> have to have MariaDB client running on your laptop. And you <i>certainly<\/i> do not (and should not) have an instance of the MariaDB DBMS server running on your laptop!<\/p>\n<p>Instead, you should follow this two-step process to poke around and inspect the <tt>galactic<\/tt> database:<\/p>\n<ol>\n<li>Log on to the <tt>cpsc.umw.edu<\/tt> server, however you do that (PuTTy, ssh, etc.)<\/li>\n<li>On the <tt>cpsc.umw.edu<\/tt> command line, type:\n<p><tt>cpsc$ mariadb -u theSecretUsername -ptheSecretPassword<\/tt><\/p>\n<p>and voila, you&#8217;re in. (Substitute the actual username and the actual password for those placeholders, of course. And don&#8217;t forget: there is <b><i>no<\/i><\/b> space between the &#8220;<tt>-p<\/tt>&#8221; and the password!)<\/li>\n<\/ol>\n<p>The only MariaDB-ish installation required for assignment #4 is the <tt>mariadb<\/tt> <b><i>Python package<\/i><\/b>, which you can install using <tt>pip<\/tt>:<\/p>\n<p><tt>yourLaptop$ pip install mariadb<\/tt><\/p>\n<p>This is required not to simply explore the database, but rather for your Python code to access it.<\/p>\n<p>Send email with any questions!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Just to be clear, for assignment #4 you do not have to have MariaDB client running on your laptop. And you certainly do not (and should not) have an instance of the MariaDB DBMS server running on your laptop! Instead, you should follow this two-step process to poke around and inspect the galactic database: Log [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1],"tags":[],"class_list":["post-920","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=\/wp\/v2\/posts\/920","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=920"}],"version-history":[{"count":2,"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=\/wp\/v2\/posts\/920\/revisions"}],"predecessor-version":[{"id":922,"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=\/wp\/v2\/posts\/920\/revisions\/922"}],"wp:attachment":[{"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=920"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=920"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/stephendavies.org\/cpsc350\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=920"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}