{"id":34,"date":"2007-06-01T16:03:38","date_gmt":"2007-06-01T14:03:38","guid":{"rendered":"http:\/\/blog.ansuz.nl\/index.php\/2007\/06\/01\/command-line-mysql\/"},"modified":"2007-06-01T16:14:32","modified_gmt":"2007-06-01T14:14:32","slug":"command-line-mysql","status":"publish","type":"post","link":"http:\/\/blog.ansuz.nl\/index.php\/2007\/06\/01\/command-line-mysql\/","title":{"rendered":"command line (my)SQL"},"content":{"rendered":"<p>It\u00c2\u00a0 has been a couple of years since the last time I had to login to a server using SSH and creating my database by using the command line. Today I had the privilege of finding the one hosting provider that doesn&#8217;t use a nice control panel for the domain (like plesk or cpanel) combined with phpMyAdmin and other fancy stuff. As you can imagine my SQL had gotten rusty, since I&#8217;m so used to creating everything with my friend phpMyAdmin. Luckily the mySQL documentation is very complete and full with tutorials.<\/p>\n<p>Useful link to the mySQL documentation: <a title=\"mySQL online documentation\" target=\"_blank\" href=\"http:\/\/dev.mysql.com\/doc\/\">http:\/\/dev.mysql.com\/doc\/<\/a><\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>It\u00c2\u00a0 has been a couple of years since the last time I had to login to a server using SSH and creating my database by using the command line. Today I had the privilege of finding the one hosting provider &hellip; <a href=\"http:\/\/blog.ansuz.nl\/index.php\/2007\/06\/01\/command-line-mysql\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-34","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"http:\/\/blog.ansuz.nl\/index.php\/wp-json\/wp\/v2\/posts\/34","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.ansuz.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.ansuz.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.ansuz.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.ansuz.nl\/index.php\/wp-json\/wp\/v2\/comments?post=34"}],"version-history":[{"count":0,"href":"http:\/\/blog.ansuz.nl\/index.php\/wp-json\/wp\/v2\/posts\/34\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.ansuz.nl\/index.php\/wp-json\/wp\/v2\/media?parent=34"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.ansuz.nl\/index.php\/wp-json\/wp\/v2\/categories?post=34"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.ansuz.nl\/index.php\/wp-json\/wp\/v2\/tags?post=34"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}