{"id":4480,"date":"2015-12-20T18:24:36","date_gmt":"2015-12-20T18:24:36","guid":{"rendered":"http:\/\/blog.bachi.net\/?p=4480"},"modified":"2015-12-20T18:35:19","modified_gmt":"2015-12-20T18:35:19","slug":"mysql-5-6-on-freebsd-10-2","status":"publish","type":"post","link":"https:\/\/blog.bachi.net\/?p=4480","title":{"rendered":"MySQL 5.6 on FreeBSD 10.2"},"content":{"rendered":"<pre class=\"brush: plain; title: \/etc\/rc.conf; notranslate\" title=\"\/etc\/rc.conf\">\r\nmysql_enable=&quot;YES&quot;\r\nmysql_dbdir=&quot;\/db\/mysql&quot;\r\n# mysql_args=&quot;--skip-grant-tables \\\r\n--skip-networking&quot; # for resetting the root password\r\n<\/pre>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ ps aux\r\n\/usr\/local\/libexec\/mysqld \\\r\n--defaults-extra-file=\/db\/mysql\/my.cnf \\\r\n--basedir=\/usr\/local \\\r\n--datadir=\/db\/mysql\r\n<\/pre>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nmysql&gt; SHOW VARIABLES LIKE '%datadir%';\r\n+---------------+------------+\r\n| Variable_name | Value      |\r\n+---------------+------------+\r\n| datadir       | \/db\/mysql\/ |\r\n+---------------+------------+\r\n<\/pre>\n<p><a href=\"http:\/\/saltnlight5.blogspot.ch\/2014\/06\/how-to-initialize-new-mysql.html\">How to initialize a new MySQL installation and create new database<\/a><br \/>\n<a href=\"http:\/\/www.pastbedti.me\/2008\/11\/resetrecover-mysql-root-password-in-freebsd\/\">Reset\/recover MySQL root password in freebsd<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>mysql_enable=&quot;YES&quot; mysql_dbdir=&quot;\/db\/mysql&quot; # mysql_args=&quot;&#8211;skip-grant-tables \\ &#8211;skip-networking&quot; # for resetting the root password $ ps aux \/usr\/local\/libexec\/mysqld \\ &#8211;defaults-extra-file=\/db\/mysql\/my.cnf \\ &#8211;basedir=\/usr\/local \\ &#8211;datadir=\/db\/mysql mysql&gt; SHOW VARIABLES LIKE &#8216;%datadir%&#8217;; +&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;+ | Variable_name | Value | +&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;+ | datadir | \/db\/mysql\/ | +&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;+ How to initialize a new MySQL installation and create new database Reset\/recover MySQL root password [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4480","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/4480","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4480"}],"version-history":[{"count":5,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/4480\/revisions"}],"predecessor-version":[{"id":4485,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/4480\/revisions\/4485"}],"wp:attachment":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4480"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4480"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4480"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}