{"id":7,"date":"2022-04-19T18:25:25","date_gmt":"2022-04-19T18:25:25","guid":{"rendered":"http:\/\/everdow.org\/?page_id=7"},"modified":"2022-04-19T18:25:26","modified_gmt":"2022-04-19T18:25:26","slug":"backend-mysql","status":"publish","type":"page","link":"https:\/\/everdow.org\/?page_id=7","title":{"rendered":"Backend MySQL"},"content":{"rendered":"\n<h4>MYSQL ENCODING<\/h4>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>Nepenthes uses UTF-8 encoding,so MySQL should be setted to UTF-8 encoding. Open MySQL configuration file from \/usr\/local\/mysql\/my.cnf before modify,you should back it up for emergency issue to restore. Add the following codes to my.cnf<\/p><\/blockquote>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;client]\ndefault-character-set=utf8\n\n<\/code><\/pre>\n\n\n\n<p>default-storage-engine=INNODB character-set-server=utf8 collation-server=utf8_general_ci<\/p>\n\n\n\n<h4>MYSQL STATUS<\/h4>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>Open Terminal and enter the following command to check MySQL status.<\/p><\/blockquote>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/usr\/local\/mysql\/support-files\nsudo .\/mysql.server status<\/code><\/pre>\n\n\n\n<h4>START MYSQL<\/h4>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>If MySQL is not running,enter the following command to start it.<\/p><\/blockquote>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo .\/mysql.server start<\/code><\/pre>\n\n\n\n<h4>RESTART MYSQL<\/h4>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>If MySQL is running,enter the following command to restart it.<\/p><\/blockquote>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo .\/mysql.server restart<\/code><\/pre>\n\n\n\n<h4>LOGIN MYSQL<\/h4>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>Using MySQL shipped terminal client to login,the default password for user root is none.<\/p><\/blockquote>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/usr\/local\/mysql\/bin\n.\/mysql -u root -p<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>If you see the following information,it means you have login MySQL successfully.<\/p><\/blockquote>\n\n\n\n<pre class=\"wp-block-code\"><code>Welcome to the MySQL monitor.  Commands end with ; or \\g.\nYour MySQL connection id is 3\nServer version: 5.6.24 MySQL Community Server (GPL)\n\nCopyright (c) 2000, 2015, Oracle and\/or its affiliates. All rights reserved.\n\nOracle is a registered trademark of Oracle Corporation and\/or its\naffiliates. Other names may be trademarks of their respective\nowners.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nmysql&gt;<\/code><\/pre>\n\n\n\n<h4>CREATE DATABASE<\/h4>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>Create database with the following command.<\/p><\/blockquote>\n\n\n\n<pre class=\"wp-block-code\"><code>create database NepenthesDemo;<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>If you see the following information,that means you create the database successfully.<\/p><\/blockquote>\n\n\n\n<pre class=\"wp-block-code\"><code>Query OK, 1 row affected (0.00 sec)<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>MYSQL ENCODING Nepenthes uses UTF-8 encoding,so MySQL should be setted to UTF-8 encoding. Open MySQL configuration file from \/usr\/local\/mysql\/my.cnf before modify,you should back it up for emergency issue to restore. Add the following codes to my.cnf default-storage-engine=INNODB character-set-server=utf8 collation-server=utf8_general_ci MYSQL STATUS Open Terminal and enter the following command to check MySQL status. START MYSQL If [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/everdow.org\/index.php?rest_route=\/wp\/v2\/pages\/7"}],"collection":[{"href":"https:\/\/everdow.org\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/everdow.org\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/everdow.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/everdow.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7"}],"version-history":[{"count":1,"href":"https:\/\/everdow.org\/index.php?rest_route=\/wp\/v2\/pages\/7\/revisions"}],"predecessor-version":[{"id":12,"href":"https:\/\/everdow.org\/index.php?rest_route=\/wp\/v2\/pages\/7\/revisions\/12"}],"wp:attachment":[{"href":"https:\/\/everdow.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}