{"id":1834,"date":"2019-01-23T17:36:37","date_gmt":"2019-01-23T09:36:37","guid":{"rendered":"https:\/\/zocodev.com\/?p=316"},"modified":"2019-01-23T17:36:37","modified_gmt":"2019-01-23T09:36:37","slug":"centos7-mysql","status":"publish","type":"post","link":"https:\/\/cloudbool.com\/archive\/centos7-mysql.html","title":{"rendered":"CentOS7\u5b89\u88c5\u914d\u7f6eMySQL"},"content":{"rendered":"

\u6700\u8fd1\u516c\u53f8\u4e00\u4e2a\u9879\u76ee\u8981\u7528\u5230MySQL\uff0c\u56e0\u4e3a\u6d89\u53ca\u5230MySQL\u76f4\u63a5\u5bf9JSON\u7684\u5b58\u50a8\u3001\u7d22\u5f15\u53ca\u67e5\u8be2\uff0c\u6240\u4ee5\u5bf9MySQL\u7684\u7248\u672c\u8981\u6c42\u4e3aMySQL 5.7\u53ca\u4ee5\u4e0a\uff0c\u5b89\u88c5\u53ca\u914d\u7f6e\u8fc7\u7a0b\u53d1\u73b0\u548c\u4e4b\u524d\u7684\u7248\u672c\u6709\u70b9\u4e0d\u4e00\u6837\uff0c\u8fd9\u91cc\u505a\u70b9\u7b14\u8bb0\u8bb0\u5f55\u4e00\u4e0b\u3002
\n<\/p>\n

\u7531\u4e8eCentOS7\u5b98\u65b9\u6e90\u5e76\u6ca1\u6709MySQL\uff0c\u800c\u81ea\u5e26\u7684MariaDB\u7248\u672c\u53c8\u592a\u4f4e\uff0c\u4f5c\u4e3a\u4e00\u4e2a\u5305\u7ba1\u7406\u5668\u652f\u6301\u515a\uff0c\u80fd\u7528\u4e8c\u8fdb\u5236\u5305\u89e3\u51b3\u7684\uff0c\u80af\u5b9a\u4e0d\u4f1a\u624b\u8d31\u53bb\u7f16\u8bd1\uff0c\u6070\u597dMySQL\u5b98\u65b9\u7ed9\u6211\u4eec\u63d0\u4f9b\u4e86MySQL Server\u7684\u6e90\uff0c\u6211\u4eec\u53ea\u9700\u8981\u7b80\u5355\u51e0\u6b65\u5c31\u80fd\u6dfb\u52a0\u597d\u3002<\/p>\n

CentOS7\u6dfb\u52a0MySQL\u5b98\u65b9\u6e90<\/h2>\n

\u6dfb\u52a0MySQL\u7684yum\u6e90\u5176\u5b9e\u5f88\u7b80\u5355\uff0c\u4e24\u884c\u547d\u4ee4\u5c31\u80fd\u641e\u5b9a\uff1a<\/p>\n

wget https:\/\/dev.mysql.com\/get\/mysql57-community-release-el7-11.noarch.rpm\nyum localinstall mysql57-community-release-el7-11.noarch.rpm\n<\/code><\/pre>\n
\u4ee5\u4e0a\u4e0b\u8f7d\u5730\u5740\u5982\u679c\u6709\u53d8\uff0c\u5230\u8fd9\u91cc\u67e5\u770b\u6700\u65b0\u7684\u5c31\u884c\uff1ahttps:\/\/dev.mysql.com\/downloads\/repo\/yum\/<\/p>\n
\u5982\u679c\u4e0a\u8ff0\u547d\u4ee4\u6267\u884c\u65e0\u62a5\u9519\u7684\u8bdd\uff0c\u53ef\u4ee5\u7528\u4e0b\u9762\u7684\u547d\u4ee4\u67e5\u770b\u6709\u54ea\u4e9b\u7248\u672c\u53ef\u9009\u62e9\u5b89\u88c5\uff1a<\/p>\n
[root@LocalServer emqx]# yum repolist all | grep mysql\nmysql-cluster-7.5-community\/x86_64 MySQL Cluster 7.5 Community   disabled\nmysql-cluster-7.5-community-source MySQL Cluster 7.5 Community - disabled\nmysql-cluster-7.6-community\/x86_64 MySQL Cluster 7.6 Community   disabled\nmysql-cluster-7.6-community-source MySQL Cluster 7.6 Community - disabled\nmysql-connectors-community\/x86_64  MySQL Connectors Community    enabled:     74\nmysql-connectors-community-source  MySQL Connectors Community -  disabled\nmysql-tools-community\/x86_64       MySQL Tools Community         enabled:     74\nmysql-tools-community-source       MySQL Tools Community - Sourc disabled\nmysql-tools-preview\/x86_64         MySQL Tools Preview           disabled\nmysql-tools-preview-source         MySQL Tools Preview - Source  disabled\nmysql55-community\/x86_64           MySQL 5.5 Community Server    disabled\nmysql55-community-source           MySQL 5.5 Community Server -  disabled\nmysql56-community\/x86_64           MySQL 5.6 Community Server    disabled\nmysql56-community-source           MySQL 5.6 Community Server -  disabled\nmysql57-community\/x86_64           MySQL 5.7 Community Server    enabled:    307\nmysql57-community-source           MySQL 5.7 Community Server -  disabled\nmysql80-community\/x86_64           MySQL 8.0 Community Server    disabled\nmysql80-community-source           MySQL 8.0 Community Server -  disabled\n<\/code><\/pre>\n
\u53ef\u4ee5\u770b\u5230\uff0c\u9664\u4e86MySQL 5.7\uff0cMySQL\u5b98\u65b9\u6e90\u4e5f\u63d0\u4f9b\u522b\u7684\u7248\u672c\uff0c\u6bd4\u5982\u8bf45.5\u30015.6\u30018.0\uff0c\u5982\u679c\u5bf9\u522b\u7684\u7248\u672c\u6709\u9700\u6c42\uff0c\u5b89\u88c5\u9700\u8981\u7684\u7248\u672c\u5c31\u884c\uff0c\u53ea\u9700\u7528yum-config-manager\u542f\u7528\u6216\u7981\u7528\u76f8\u5173\u7684\u6e90\u5373\u53ef\uff0c\u6bd4\u5982\u8bf4\u7981\u7528MySQL5.7\u542f\u7528MySQL5.6\uff1a<\/p>\n
yum-config-manager --disable mysql57-community\nyum-config-manager --enable mysql56-community\n<\/code><\/pre>\n
CentOS7\u5b89\u88c5MySQL 5.7\/5.8\/8.0<\/h2>\n
\u786e\u5b9a\u4e4b\u540e\uff0c\u53ef\u4ee5\u5b89\u88c5MySQL Server\u4e86\uff1a<\/p>\n
yum install mysql-community-server\n<\/code><\/pre>\n
\u53ea\u9700\u4e0a\u9762\u4e00\u884c\u547d\u4ee4\u5373\u53ef\u5b89\u88c5\u597d\uff0c\u5b89\u88c5\u8fc7\u7a0b\u4e0d\u9700\u8981\u4eba\u5de5\u5e72\u9884\uff0c\u76f4\u63a5\u5c31\u5b8c\u6210\u4e86\u5b89\u88c5\u8fc7\u7a0b\u3002<\/p>\n
\u5176\u4e2d\uff0c\u548c\u522b\u7684\u5b89\u88c5\u8fc7\u7a0b\u6709\u70b9\u4e0d\u4e00\u6837\u7684\u662f\uff0cMySQL Server\u7684root\u5bc6\u7801\u4e5f\u5728\u5b89\u88c5\u8fc7\u7a0b\u4e2d\u88ab\u8bbe\u7f6e\u6210\u4e86\u968f\u673a\u5bc6\u7801\uff0c\u5982\u679c\u5b89\u88c5\u4e4b\u540e\u53d1\u73b0\u4e0d\u77e5\u9053MySQL\u7684root\u5bc6\u7801\u800c\u65e0\u6cd5\u767b\u5f55\u5343\u4e07\u522b\u65b9\uff0c\u53ef\u4ee5\u901a\u8fc7\u4e0b\u8ff0\u547d\u4ee4\u627e\u5230MySQL\u7684root\u4e34\u65f6\u5bc6\u7801\uff1a<\/p>\n
grep 'temporary password' \/var\/log\/mysqld.log\n\n2019-01-17T03:04:39.023156Z 1 [Note] A temporary password is generated for root@localhost: oW=-)jtRbxxx\n<\/code><\/pre>\n
\u5176\u4e2d\uff0clocalhost\u5192\u53f7\u540e\u9762\u7684\u5b57\u7b26\u4e32\u5c31\u662fMySQL\u7684\u4e34\u65f6root\u5bc6\u7801\u4e86\u3002<\/p>\n
MySQL\u521d\u59cb\u5316\u8bbe\u7f6e<\/h2>\n
\u627e\u5230MySQL\u7684root\u5bc6\u7801\u4e4b\u540e\uff0c\u5efa\u8bae\u5bf9MySQL\u8fdb\u884c\u521d\u59cb\u5316\u8bbe\u7f6e\uff0c\u81ea\u5e26\u7684\u547d\u4ee4\u5982\u4e0b\uff1a<\/p>\n
[root@LocalServer emqx]# mysql_secure_installation\n\nSecuring the MySQL server deployment.\n\nEnter password for user root:  ##\u8f93\u5165\u4e0a\u9762\u7684\u4e34\u65f6root\u5bc6\u7801\n\nThe existing password for the user account root has expired. Please set a new password.\n\nNew password: ##\u8bbe\u7f6e\u65b0\u5bc6\u7801\n\nRe-enter new password:  ##\u91cd\u590d\u5bc6\u7801\nThe 'validate_password' plugin is installed on the server.\nThe subsequent steps will run with the existing configuration\nof the plugin.\nUsing existing password for root.\n\nEstimated strength of the password: 100\nChange the password for root ? ((Press y|Y for Yes, any other key for No) : #\u662f\u5426\u66f4\u6539root\u5bc6\u7801\n\n ... skipping.\nBy default, a MySQL installation has an anonymous user,\nallowing anyone to log into MySQL without having to have\na user account created for them. This is intended only for\ntesting, and to make the installation go a bit smoother.\nYou should remove them before moving into a production\nenvironment.\n\nRemove anonymous users? (Press y|Y for Yes, any other key for No) : ##\u662f\u5426\u79fb\u9664\u533f\u540d\u7528\u6237\n\n ... skipping.\n\n\nNormally, root should only be allowed to connect from\n'localhost'. This ensures that someone cannot guess at\nthe root password from the network.\n\nDisallow root login remotely? (Press y|Y for Yes, any other key for No) : y ##\u662f\u5426\u7981\u6b62root\u8fdc\u7a0b\u767b\u5f55\nSuccess.\n\nBy default, MySQL comes with a database named 'test' that\nanyone can access. This is also intended only for testing,\nand should be removed before moving into a production\nenvironment.\n\n\nRemove test database and access to it? (Press y|Y for Yes, any other key for No) : y ##\u662f\u5426\u5220\u9664\u6d4b\u8bd5\u6570\u636e\u5e93\n - Dropping test database...\nSuccess.\n\n - Removing privileges on test database...\nSuccess.\n\nReloading the privilege tables will ensure that all changes\nmade so far will take effect immediately.\n\nReload privilege tables now? (Press y|Y for Yes, any other key for No) : y ##\u662f\u5426\u7acb\u5373\u5237\u65b0\u6743\u9650\nSuccess.\n\nAll done!\n<\/code><\/pre>\n
\u8fd9\u91cc\u6709\u4e00\u70b9\u9700\u8981\u6ce8\u610f\u7684\u662f\uff0c\u7531\u4e8evalidate_password\u7684\u5b58\u5728\uff0c\u6240\u66f4\u6539\u7684\u5bc6\u7801\u4e0d\u80fd\u592a\u7b80\u5355\uff0c\u5fc5\u987b\u7b26\u5408validate_password\u8981\u6c42\u624d\u80fd\u66f4\u6539\u6210\u529f\uff0c\u6839\u636e\u5b98\u65b9\u6587\u6863\uff0cMySQL\u5bc6\u7801\u8981\u6c42\u662f\uff1a
\n\u81f3\u5c11\u5305\u542b\u4e00\u4e2a\u5927\u5199\u5b57\u6bcd\uff0c\u4e00\u4e2a\u5c0f\u5199\u5b57\u6bcd\uff0c\u4e00\u4e2a\u6570\u5b57\uff0c\u4e00\u4e2a\u7279\u6b8a\u7b26\u53f7\uff0c\u4e14\u4e0d\u80fd\u5c11\u4e8e8\u4f4d<\/p>\n
\u5f53\u7136\u5982\u679c\u89c9\u5f97\u9ebb\u70e6\uff0c\u4e5f\u53ef\u4ee5\u628a\u8fd9\u4e2a\u63d2\u4ef6\u5173\u95ed\uff0c\u867d\u7136\u6211\u4e0d\u5efa\u8bae\uff1a<\/p>\n
vim \/etc\/my.conf\n\n[mysqld]\nvalidate_password=Off\n<\/code><\/pre>\n
MySQL 5.7\u53ca\u4ee5\u4e0a\u7248\u672c\u7684\u5b89\u88c5\u53ca\u521d\u6b65\u914d\u7f6e\u5230\u8fd9\u4e00\u6b65\u5c31\u5b8c\u6210\u4e86\uff0c\u4f46\u662f\u51fa\u4e8e\u5b9e\u9645\u9700\u6c42\uff0c\u6211\u540e\u9762\u8fd8\u6709\u4e00\u90e8\u5206\u662f\u6211\u7684MySQL\u4f7f\u7528\u8fc7\u7a0b\u7684\u8bb0\u5f55\u3002<\/p>\n
MySQL\u65b0\u5efa\u6570\u636e\u5e93\u5e76\u6307\u5b9a\u4e3aUTF8\u5b57\u7b26\u96c6<\/h2>\n
\u51fa\u4e8e\u517c\u5bb9\u6027\u8003\u8651\uff0c\u6211\u4eec\u6700\u597d\u5728\u65b0\u5efa\u6570\u636e\u5e93\u7684\u65f6\u5019\u6307\u5b9a\u5b57\u7b26\u96c6\uff0c\u8fd9\u6837\u5728\u540e\u9762\u7684\u5f00\u53d1\u4e2d\u53ef\u4ee5\u51cf\u5c11\u5f88\u591a\u83ab\u540d\u5176\u5999\u7684\u95ee\u9898\uff1a<\/p>\n
create database if not exists zocodev default character set utf8 collate utf8_unicode_ci;\n<\/code><\/pre>\n
\u5f53\u7136\uff0c\u5982\u679c\u6709emoji\u9700\u6c42\uff0c\u4e5f\u53ef\u4ee5\u6307\u5b9a\u4e3autf8mb4\u5b57\u7b26\u96c6\uff1a<\/p>\n
create database if not exists zocodev default character set utf8mb4 collate utf8mb4_unicode_ci;\n<\/code><\/pre>\n
MySQL\u65b0\u5efa\u7528\u6237\u5e76\u8d4b\u4e88\u6570\u636e\u5e93\u64cd\u4f5c\u6743\u9650<\/h2>\n
\u51fa\u4e8e\u5b89\u5168\uff0c\u6700\u597d\u4e0d\u8981\u4f7f\u7528root\u8d26\u6237\u6765\u64cd\u4f5c\u81ea\u5b9a\u4e49\u7684\u6570\u636e\u5e93\uff0c\u4e00\u4e2a\u7528\u6237\u6307\u5b9a\u4e00\u4e2a\u6570\u636e\u5e93\u6bd4\u8f83\u5408\u9002\u3002\u6bd4\u5982\u8bf4\u7528\u6765\u5efa\u7f51\u7ad9\uff0c\u53ef\u4ee5\u4e00\u4e2aWordPress\u7f51\u7ad9\u65b0\u5efa\u4e00\u4e2a\u6570\u636e\u5e93\u53ca\u5bf9\u5e94\u7684\u6570\u636e\u5e93\u7528\u6237\u3002<\/p>\n
\u65b0\u5efaMySQL\u7528\u6237\u5e76\u8bbe\u7f6e\u5bc6\u7801\uff1a<\/p>\n
create user zocodev_user@'localhost' IDENTIFIED BY 'ABCabc123@@';\n<\/code><\/pre>\n
\u5982\u679c\u9700\u8981\u5141\u8bb8\u65b0\u5efa\u7684MySQL\u7528\u6237\u53ef\u4ee5\u8fdc\u7a0b\u767b\u5f55\uff0c\u53ef\u4ee5\u628a\u4e0a\u9762\u7684localhost<\/strong>\u66ff\u6362\u6210%<\/strong>\uff0c\u4e5f\u5c31\u662f\uff1a<\/p>\n
create user zocodev_user@'%' IDENTIFIED BY 'ABCabc123@@';\n<\/code><\/pre>\n
\u9700\u8981\u6ce8\u610f\u7684\u662f\uff0c\u6307\u5b9a\u5bc6\u7801\u4e5f\u9700\u8981\u7b26\u5408\u4e0a\u8ff0\u8bf4\u7684validate_password\u63d2\u4ef6\u7684\u8981\u6c42\uff0c\u5426\u5219\u4f1a\u62a5\u5982\u4e0b\u9519\u8bef\uff1a<\/p>\n
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements\n<\/code><\/pre>\n
\u7136\u540e\u8d4b\u4e88\u65b0\u5efa\u7684MySQL\u7528\u6237\u6307\u5b9a\u6570\u636e\u5e93\u7684\u64cd\u4f5c\u6743\u9650\uff1a<\/p>\n
grant all privileges on zocodev.* to zocodev_user@localhost identified by 'ABCabc123@@';\n<\/code><\/pre>\n
\u8d4b\u4e88\u6743\u9650\u4e4b\u540e\uff0c\u9700\u8981\u5237\u65b0\u4e00\u4e0b\u6743\u9650\uff0c\u5f53\u7136\uff0c\u91cd\u542f\u4e00\u4e0bMySQL Server\u4e5f\u53ef\u4ee5\uff1a<\/p>\n
flush privileges;\n<\/code><\/pre>\n
\u5982\u679c\u6ca1\u6709\u610f\u5916\uff0c\u5c31\u80fd\u7528\u4e0a\u9762\u65b0\u5efa\u7684\u7528\u6237\u53ca\u5bf9\u5e94\u7684\u5bc6\u7801\u767b\u5f55MySQL\u53ca\u5bf9\u6307\u5b9a\u7684\u6570\u636e\u5e93\u8fdb\u884c\u64cd\u4f5c\u4e86\uff0c\u547d\u4ee4\u5982\u4e0b\uff1a<\/p>\n
[root@LocalServer emqx]# mysql -u zocodev_user -p\nEnter password:\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\nYour MySQL connection id is 12\nServer version: 5.7.24 MySQL Community Server (GPL)\n\nCopyright (c) 2000, 2018, 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> show databases;\n+--------------------+\n| Database           |\n+--------------------+\n| information_schema |\n| zocodev            |\n+--------------------+\n2 rows in set (0.00 sec)\n\nmysql>\n<\/code><\/pre>\n
\u9488\u5bf9MySQL\u521b\u5efa\u65b0\u7528\u6237\uff0c\u8fd9\u91cc\u6709\u66f4\u8be6\u7ec6\u7684\u4ecb\u7ecd\uff1a
\nhttps:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/create-user.html<\/p>\n
CentOS7\u7cfb\u7edf\u5f00\u542fMySQL\u8fdc\u7a0b\u8bbf\u95ee<\/h2>\n
\u56e0\u4e3a\u6211\u4eec\u7684MySQL\u4e0d\u4e00\u5b9a\u662f\u5b89\u88c5\u5728\u672c\u5730\uff0c\u53ef\u80fd\u662f\u5185\u7f51\u6216\u8005\u522b\u7684\u673a\u5668\u4e0a\uff0c\u6709\u7684\u65f6\u5019\u5c31\u6709\u4e86\u8fdc\u7a0b\u8bbf\u95ee\u9700\u6c42\uff0c\u4e0b\u9762\u662f\u914d\u7f6eCentOS7\u7cfb\u7edf\u4e0b\u5f00\u542fMySQL\u8fdc\u7a0b\u8bbf\u95ee\u7684\u6b65\u9aa4\u3002<\/p>\n
\u8981\u5f00\u542fCentOS7\u4e0b\u7684MySQL\u8fdc\u7a0b\u8bbf\u95ee\uff0c\u9700\u8981\u6ee1\u8db3\u5982\u4e0b\u4e09\u4e2a\u8981\u6c42\uff1a
\n1\u3001MySQL Server\u76d1\u542c\u7684IP\u53ef\u4ee5\u88ab\u5916\u754c\u8bbf\u95ee\uff0c\u6bd4\u5982\u8bf4\uff1a192.168.1.x<\/strong>\u6216\u8005\u522b\u7684IP\u5730\u5740\u3002
\n2\u3001\u7528\u4e8e\u8fdc\u7a0b\u767b\u5f55\u7684\u7528\u6237\u9700\u8981\u6307\u5b9a\u5141\u8bb8\u5728\u522b\u7684IP\u5730\u5740\u767b\u5f55\u3002\u65b0\u5efa\u7528\u6237\u7684\u65f6\u5019\u6307\u5b9a\u5141\u8bb8\u767b\u5f55\u5730\u5740\u4e3a%<\/strong>\uff0cSQL\u8bed\u53e5\u53c2\u8003\u4e0a\u9762\u65b0\u5efa\u7528\u6237\u90e8\u5206\u3002
\n3\u3001\u5f00\u653e\u4e86\u5bf9\u5e94\u7684\u7aef\u53e3\u3002<\/p>\n
\u5728MySQL\u914d\u7f6e\u6587\u4ef6\u7684[mysqld]<\/strong>\u6dfb\u52a0\u4e00\u884c\uff0c\u6307\u5b9aMySQL\u76d1\u542cIP\uff1a<\/p>\n
vim \/etc\/my.cnf\n\n[mysqld]\nbind-address=0.0.0.0\n<\/code><\/pre>\n
\u5173\u4e8eMySQL\u7ed1\u5b9aIP\uff0c\u53ef\u4ee5\u53c2\u8003\u8fd9\u91cc\uff1ahttps:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/server-options.html#option_mysqld_bind-address
\n\u6dfb\u52a0\u4e86\u4e4b\u540e\uff0c\u8fd8\u9700\u8981\u91cd\u542fMySQL\uff1a<\/p>\n
systemctl restart mysqld\n<\/code><\/pre>\n
\u5982\u679c\u5f00\u542f\u4e86\u9632\u706b\u5899\u7684\u8bdd\uff0c\u8fd8\u9700\u8981\u5f00\u653eMySQL\u76d1\u542c\u7aef\u53e3\uff1a<\/p>\n
firewall-cmd --permanent --add-port=3306\/tcp\nfirewall-cmd --reload\n<\/code><\/pre>\n
\u5982\u679c\u4e0a\u9762\u7684\u547d\u4ee4\u90fd\u6ca1\u95ee\u9898\uff0c\u5230\u8fd9\u4e00\u6b65\u53ef\u4ee5\u4f7f\u7528\u5982\u4e0b\u547d\u4ee4\u4ece\u672c\u5730\u8fde\u63a5\u8fdc\u7a0b\u7684\u6570\u636e\u5e93\u4e86\uff1a<\/p>\n
mysql -u username -h 1.2.3.4 -P 3306 -p\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u6700\u8fd1\u516c\u53f8\u4e00\u4e2a\u9879\u76ee\u8981\u7528\u5230MySQL\uff0c\u56e0\u4e3a\u6d89\u53ca\u5230MySQL\u76f4\u63a5\u5bf9JSON\u7684\u5b58\u50a8\u3001\u7d22\u5f15\u53ca\u67e5\u8be2\uff0c\u6240\u4ee5\u5bf9MySQL\u7684\u7248\u672c …<\/p>\n
  CentOS7\u5b89\u88c5\u914d\u7f6eMySQL<\/span> \u67e5\u770b\u5168\u6587 »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"footnotes":""},"categories":[12],"tags":[17,75],"class_list":["post-1834","post","type-post","status-publish","format-standard","hentry","category-app","tag-centos","tag-mysql"],"_links":{"self":[{"href":"https:\/\/cloudbool.com\/archive\/wp-json\/wp\/v2\/posts\/1834","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cloudbool.com\/archive\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cloudbool.com\/archive\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cloudbool.com\/archive\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cloudbool.com\/archive\/wp-json\/wp\/v2\/comments?post=1834"}],"version-history":[{"count":0,"href":"https:\/\/cloudbool.com\/archive\/wp-json\/wp\/v2\/posts\/1834\/revisions"}],"wp:attachment":[{"href":"https:\/\/cloudbool.com\/archive\/wp-json\/wp\/v2\/media?parent=1834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudbool.com\/archive\/wp-json\/wp\/v2\/categories?post=1834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudbool.com\/archive\/wp-json\/wp\/v2\/tags?post=1834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}