{"id":53733,"date":"2019-12-09T00:00:00","date_gmt":"2019-12-08T21:00:00","guid":{"rendered":"https:\/\/prohoster.info\/blog\/blog_prohoster\/kak-ispolzovat-mysql-bez-parolya-i-riskov-dlya-bezopasnosti"},"modified":"2020-02-18T14:01:40","modified_gmt":"2020-02-18T11:01:40","slug":"kak-ispolzovat-mysql-bez-parolya-i-riskov-dlya-bezopasnosti","status":"publish","type":"post","link":"https:\/\/prohoster.info\/de\/blog\/administrirovanie\/kak-ispolzovat-mysql-bez-parolya-i-riskov-dlya-bezopasnosti","title":{"rendered":"So verwenden Sie MySQL ohne Passwort (und Sicherheitsrisiken).","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"\u041a\u0430\u043a \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c MySQL \u0431\u0435\u0437 \u043f\u0430\u0440\u043e\u043b\u044f (\u0438 \u0440\u0438\u0441\u043a\u043e\u0432 \u0434\u043b\u044f \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u0438)\" src=\"\/wp-content\/uploads\/2019\/12\/366b3d799848eb3c31d851723d85aae2.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>\u0413\u043e\u0432\u043e\u0440\u044f\u0442, \u0447\u0442\u043e \u043b\u0443\u0447\u0448\u0438\u0439 \u043f\u0430\u0440\u043e\u043b\u044c \u2014 \u0442\u043e\u0442, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043d\u0435 \u043d\u0430\u0434\u043e \u0437\u0430\u043f\u043e\u043c\u0438\u043d\u0430\u0442\u044c. \u0412 \u0441\u043b\u0443\u0447\u0430\u0435 \u0441 MySQL \u044d\u0442\u043e \u0440\u0435\u0430\u043b\u044c\u043d\u043e \u0431\u043b\u0430\u0433\u043e\u0434\u0430\u0440\u044f \u043f\u043b\u0430\u0433\u0438\u043d\u0443 <noindex><a rel=\"nofollow\" href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/socket-pluggable-authentication.html\">auth_socket<\/a><\/noindex> \u0438 \u0435\u0433\u043e \u0432\u0435\u0440\u0441\u0438\u0438 \u0434\u043b\u044f MariaDB \u2014 <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/library\/authentication-plugin-unix-socket\/\">unix_socket<\/a><\/noindex>.<\/p>\n<p><\/p>\n<p>\u041e\u0431\u0430 \u044d\u0442\u0438 \u043f\u043b\u0430\u0433\u0438\u043d\u0430 \u2014 \u0432\u043e\u0432\u0441\u0435 \u043d\u0435 \u043d\u043e\u0432\u044b, \u043e \u043d\u0438\u0445 \u043c\u043d\u043e\u0433\u043e \u0433\u043e\u0432\u043e\u0440\u0438\u043b\u043e\u0441\u044c \u0432 \u044d\u0442\u043e\u043c \u0436\u0435 \u0431\u043b\u043e\u0433\u0435, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 \u0432 \u0441\u0442\u0430\u0442\u044c\u0435 \u043e \u0442\u043e\u043c, <noindex><a rel=\"nofollow\" href=\"https:\/\/www.percona.com\/blog\/2016\/03\/16\/change-user-password-in-mysql-5-7-with-plugin-auth_socket\/\">\u043a\u0430\u043a \u0438\u0437\u043c\u0435\u043d\u044f\u0442\u044c \u043f\u0430\u0440\u043e\u043b\u0438 \u0432 MySQL 5.7, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u043f\u043b\u0430\u0433\u0438\u043d auth_socket<\/a><\/noindex>. \u041e\u0434\u043d\u0430\u043a\u043e, \u0440\u0430\u0437\u0431\u0438\u0440\u0430\u044f, \u0447\u0442\u043e \u043d\u043e\u0432\u0435\u043d\u044c\u043a\u043e\u0433\u043e \u0432 MariaDB 10.4, \u044f \u043e\u0431\u043d\u0430\u0440\u0443\u0436\u0438\u043b, \u0447\u0442\u043e unix_socket \u0442\u0435\u043f\u0435\u0440\u044c \u0443\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u0442\u0441\u044f \u043f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e \u0438 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u043e\u0434\u043d\u0438\u043c \u0438\u0437 \u043c\u0435\u0442\u043e\u0434\u043e\u0432 \u0430\u0443\u0442\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0446\u0438\u0438 (&#171;\u043e\u0434\u043d\u0438\u043c \u0438\u0437&#187;, \u043f\u043e\u0442\u043e\u043c\u0443 \u043a\u0430\u043a \u0432 MariaDB 10.4 \u043e\u0434\u043d\u043e\u043c\u0443 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044e \u0434\u043b\u044f \u0430\u0443\u0442\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0446\u0438\u0438 \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u043e \u0431\u043e\u043b\u044c\u0448\u0435 \u043e\u0434\u043d\u043e\u0433\u043e \u043f\u043b\u0430\u0433\u0438\u043d\u0430, \u0447\u0442\u043e \u0438 \u043e\u0431\u044a\u044f\u0441\u043d\u044f\u0442\u0435\u0442\u0441\u044f \u0432 \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0435 <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/library\/authentication-from-mariadb-104\/\">&#171;\u0410\u0443\u0442\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0446\u0438\u044f&#187; \u043e\u0442 MariaDB 10.04<\/a><\/noindex>).<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<p>\u041a\u0430\u043a \u044f \u0443\u0436\u0435 \u0441\u043a\u0430\u0437\u0430\u043b, \u044d\u0442\u043e \u2014 \u043d\u0435 \u043d\u043e\u0432\u043e\u0441\u0442\u0438, \u0438 \u043a\u043e\u0433\u0434\u0430 \u0443\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u0448\u044c MySQL, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u043c\u044b\u0435 \u043a\u043e\u043c\u0430\u043d\u0434\u043e\u0439 Debian \u043f\u0430\u043a\u0435\u0442\u044b .deb, \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u0441 root-\u043f\u0440\u0430\u0432\u0430\u043c\u0438 \u0441\u043e\u0437\u0434\u0430\u0435\u0442\u0441\u044f \u043f\u043e\u0434 \u0430\u0443\u0442\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0446\u0438\u044e \u0447\u0435\u0440\u0435\u0437 \u0441\u043e\u043a\u0435\u0442. \u042d\u0442\u043e \u0441\u043f\u0440\u0430\u0432\u0435\u0434\u043b\u0438\u0432\u043e \u043a\u0430\u043a \u0434\u043b\u044f MySQL, \u0442\u0430\u043a \u0438 \u0434\u043b\u044f MariaDB.<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">root@app:~# apt-cache show mysql-server-5.7 | grep -i maintainers\nOriginal-Maintainer: Debian MySQL Maintainers &lt;pkg-mysql-maint@lists.alioth.debian.org&gt;\nOriginal-Maintainer: Debian MySQL Maintainers &lt;&lt;a href=\"mailto:pkg-mysql-maint@lists.alioth.debian.org\"&gt;pkg-mysql-maint@lists.alioth.debian.org&lt;\/a&gt;&gt;<\/code><\/pre>\n<p><\/p>\n<p>\u0421 \u043f\u0430\u043a\u0435\u0442\u0430\u043c\u0438 Debian \u0434\u043b\u044f MySQL, root \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u0430\u0443\u0442\u0435\u043d\u0442\u0438\u0444\u0438\u0446\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c:<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">root@app:~# whoami\nroot=\nroot@app:~# mysql\nWelcome to the MySQL monitor.\u00a0 Commands end with ; or g.\nYour MySQL connection id is 4\nServer version: 5.7.27-0ubuntu0.16.04.1 (Ubuntu)\n\nCopyright (c) 2000, 2019, Oracle and\/or its affiliates. All rights reserved.\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; select user, host, plugin, authentication_string from mysql.user where user = 'root';\n+------+-----------+-------------+-----------------------+\n| user | host\u00a0 \u00a0 \u00a0 | plugin | authentication_string |\n+------+-----------+-------------+-----------------------+\n| root | localhost | auth_socket | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\n+------+-----------+-------------+-----------------------+\n1 row in set (0.01 sec)<\/code><\/pre>\n<p><\/p>\n<p>\u0422\u043e \u0436\u0435 \u0438 \u0432 \u0441\u043b\u0443\u0447\u0430\u0435 \u0441 \u043f\u0430\u043a\u0435\u0442\u043e\u043c .deb \u0434\u043b\u044f MariaDB:<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">10.0.38-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04\n\nMariaDB [(none)]&gt; show grants;\n+------------------------------------------------------------------------------------------------+\n| Grants for root@localhost\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\n+------------------------------------------------------------------------------------------------+\n| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED VIA unix_socket WITH GRANT OPTION |\n| GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\n+------------------------------------------------------------------------------------------------+\n2 rows in set (0.00 sec)<\/code><\/pre>\n<p><\/p>\n<p>\u041f\u0430\u043a\u0435\u0442\u044b .deb \u0438\u0437 \u043e\u0444\u0438\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0433\u043e \u0440\u0435\u043f\u043e\u0437\u0438\u0442\u043e\u0440\u0438\u044f Percona \u0442\u0430\u043a\u0436\u0435 \u043d\u0430\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u044e\u0442 \u0430\u0443\u0442\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0446\u0438\u044e \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0441 root-\u043f\u0440\u0430\u0432\u0430\u043c\u0438 \u043f\u043e\u0434 auth-socket \u0438 \u0434\u043b\u044f Percona Server. \u041f\u0440\u0438\u0432\u0435\u0434\u0435\u043c \u043f\u0440\u0438\u043c\u0435\u0440 \u0441 <noindex><a rel=\"nofollow\" href=\"https:\/\/www.percona.com\/doc\/percona-server\/LATEST\/index.html\">Percona Server for MySQL 8.0.16-7<\/a><\/noindex> \u0438 Ubuntu 16.04:<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">root@app:~# whoami\nroot\nroot@app:~# mysql\nWelcome to the MySQL monitor.\u00a0 Commands end with ; or g.\nYour MySQL connection id is 9\nServer version: 8.0.16-7 Percona Server (GPL), Release '7', Revision '613e312'\n\nCopyright (c) 2009-2019 Percona LLC and\/or its affiliates\nCopyright (c) 2000, 2019, Oracle and\/or its affiliates. All rights reserved.\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; select user, host, plugin, authentication_string from mysql.user where user ='root';\n+------+-----------+-------------+-----------------------+\n| user | host\u00a0 \u00a0 \u00a0 | plugin | authentication_string |\n+------+-----------+-------------+-----------------------+\n| root | localhost | auth_socket | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\n+------+-----------+-------------+-----------------------+\n1 row in set (0.00 sec)<\/code><\/pre>\n<p><\/p>\n<p>\u0422\u0430\u043a \u0432 \u0447\u0435\u043c \u0436\u0435 \u043c\u0430\u0433\u0438\u044f? \u041f\u043b\u0430\u0433\u0438\u043d \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u0442, \u0447\u0442\u043e \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c Linux \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u0435\u0442 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044e MySQL, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u0441\u043e\u043a\u0435\u0442-\u043e\u043f\u0446\u0438\u044e SO_PEERCRED \u2014 \u0447\u0442\u043e\u0431\u044b \u0441\u043e\u0431\u0440\u0430\u0442\u044c \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u043e \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435, \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u044e\u0449\u0435\u043c \u043a\u043b\u0438\u0435\u043d\u0442\u0441\u043a\u0443\u044e \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0443. \u0422\u0430\u043a\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c, \u043f\u043b\u0430\u0433\u0438\u043d \u043c\u043e\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0442\u043e\u043b\u044c\u043a\u043e \u043d\u0430 \u0441\u0438\u0441\u0442\u0435\u043c\u0430\u0445, \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u044e\u0449\u0438\u0445 \u043e\u043f\u0446\u0438\u044e SO_PEERCRED, \u0432\u0440\u043e\u0434\u0435 \u0442\u043e\u0439 \u0436\u0435 Linux. \u0421\u043e\u043a\u0435\u0442-\u043e\u043f\u0446\u0438\u044f SO_PEERCRED \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0443\u0437\u043d\u0430\u0432\u0430\u0442\u044c uid \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u043e\u0433\u043e \u0441 \u0441\u043e\u043a\u0435\u0442\u043e\u043c \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u0430. \u0410 \u043f\u043e\u0441\u043b\u0435 \u043e\u043d \u0443\u0436\u0435 \u043f\u043e\u043b\u0443\u0447\u0430\u0435\u0442 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u043e\u0435 \u0441 \u044d\u0442\u0438\u043c uid \u0438\u043c\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f.<\/p>\n<p><\/p>\n<p>\u041f\u0440\u0438\u0432\u0435\u0434\u0435\u043c \u043f\u0440\u0438\u043c\u0435\u0440 \u0441 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u043c &#171;vagrant&#187;:<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">vagrant@mysql1:~$ whoami\nvagrant\nvagrant@mysql1:~$ mysql\nERROR 1698 (28000): Access denied for user 'vagrant'@'localhost'<\/code><\/pre>\n<p><\/p>\n<p>\u041f\u043e\u0441\u043a\u043e\u043b\u044c\u043a\u0443 \u0432 MySQL \u043d\u0435\u0442 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f &#171;vagrant&#187;, \u0432 \u0434\u043e\u0441\u0442\u0443\u043f\u0435 \u043d\u0430\u043c \u043e\u0442\u043a\u0430\u0437\u0430\u043d\u043e. \u0421\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u0442\u0430\u043a\u043e\u0433\u043e \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0438 \u043f\u043e\u0432\u0442\u043e\u0440\u0438\u043c \u043f\u043e\u043f\u044b\u0442\u043a\u0443:<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">MariaDB [(none)]&gt; GRANT ALL PRIVILEGES ON *.* TO 'vagrant'@'localhost' IDENTIFIED VIA unix_socket;\nQuery OK, 0 rows affected (0.00 sec)\n\nvagrant@mysql1:~$ mysql\nWelcome to the MariaDB monitor.\u00a0 Commands end with ; or g.\nYour MariaDB connection id is 45\nServer version: 10.0.38-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\nType 'help;' or 'h' for help. Type 'c' to clear the current input statement.\n\nMariaDB [(none)]&gt; show grants;\n+---------------------------------------------------------------------------------+\n| Grants for vagrant@localhost\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\n+---------------------------------------------------------------------------------+\n| GRANT ALL PRIVILEGES ON *.* TO 'vagrant'@'localhost' IDENTIFIED VIA unix_socket |\n+---------------------------------------------------------------------------------+\n1 row in set (0.00 sec)<\/code><\/pre>\n<p><\/p>\n<p><strong>\u041f\u043e\u043b\u0443\u0447\u0438\u043b\u043e\u0441\u044c!<\/strong><\/p>\n<p><\/p>\n<p>\u041d\u0443, \u0430 \u043a\u0430\u043a \u043d\u0430\u0441\u0447\u0435\u0442 \u043d\u0435-Debian \u0434\u0438\u0441\u0442\u0440\u0438\u0431\u0443\u0442\u0438\u0432\u0430, \u0433\u0434\u0435 \u044d\u0442\u043e \u043d\u0435 \u043f\u0440\u0435\u0434\u0443\u0441\u043c\u043e\u0442\u0440\u0435\u043d\u043e \u043f\u043e \u0443\u043c\u043e\u043b\u0447\u0430\u043d\u0438\u044e? \u041f\u043e\u043f\u0440\u043e\u0431\u0443\u0435\u043c Percona Server for MySQL 8, \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u043d\u044b\u0439 \u043d\u0430 CentOS 7:<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">mysql&gt; show variables like '%version%comment';\n+-----------------+---------------------------------------------------+\n| Variable_name \u00a0 | Value \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\n+-----------------+---------------------------------------------------+\n| version_comment | Percona Server (GPL), Release 7, Revision 613e312 |\n+-----------------+---------------------------------------------------+\n1 row in set (0.01 sec)\n\nmysql&gt; CREATE USER 'percona'@'localhost' IDENTIFIED WITH auth_socket;\nERROR 1524 (HY000): Plugin 'auth_socket' is not loaded<\/code><\/pre>\n<p><\/p>\n<p>\u041e\u0431\u043b\u043e\u043c. \u0427\u0435\u0433\u043e \u0436\u0435 \u043d\u0435 \u0445\u0432\u0430\u0442\u0438\u043b\u043e? \u041f\u043b\u0430\u0433\u0438\u043d \u043d\u0435 \u0437\u0430\u0433\u0440\u0443\u0436\u0435\u043d:<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">mysql&gt; pager grep socket\nPAGER set to 'grep socket'\nmysql&gt; show plugins;\n47 rows in set (0.00 sec)<\/code><\/pre>\n<p><\/p>\n<p>\u0414\u043e\u0431\u0430\u0432\u0438\u043c \u0432 \u043f\u0440\u043e\u0446\u0435\u0441\u0441 \u043f\u043b\u0430\u0433\u0438\u043d:<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">mysql&gt; nopager\nPAGER set to stdout\nmysql&gt; INSTALL PLUGIN auth_socket SONAME 'auth_socket.so';\nQuery OK, 0 rows affected (0.00 sec)\n\nmysql&gt; pager grep socket; show plugins;\nPAGER set to 'grep socket'\n| auth_socket \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | ACTIVE | AUTHENTICATION | auth_socket.so | GPL \u00a0 \u00a0 |\n48 rows in set (0.00 sec)<\/code><\/pre>\n<p><\/p>\n<p>\u0422\u0435\u043f\u0435\u0440\u044c \u0443 \u043d\u0430\u0441 \u0435\u0441\u0442\u044c \u0432\u0441\u0435 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0435. \u041f\u043e\u043f\u0440\u043e\u0431\u0443\u0435\u043c \u0435\u0449\u0435 \u0440\u0430\u0437\u043e\u043a:<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">mysql&gt; CREATE USER 'percona'@'localhost' IDENTIFIED WITH auth_socket;\nQuery OK, 0 rows affected (0.01 sec)\nmysql&gt; GRANT ALL PRIVILEGES ON *.* TO 'percona'@'localhost';\nQuery OK, 0 rows affected (0.01 sec)<\/code><\/pre>\n<p><\/p>\n<p>\u0422\u0435\u043f\u0435\u0440\u044c \u043c\u043e\u0436\u043d\u043e \u0432\u043e\u0439\u0442\u0438 \u0432 \u0441\u0438\u0441\u0442\u0435\u043c\u0443 \u043f\u043e\u0434 \u043b\u043e\u0433\u0438\u043d\u043e\u043c &#171;percona&#187;.<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">[percona@ip-192-168-1-111 ~]$ whoami\npercona\n[percona@ip-192-168-1-111 ~]$ mysql -upercona\nWelcome to the MySQL monitor.\u00a0 Commands end with ; or g.\nYour MySQL connection id is 19\nServer version: 8.0.16-7 Percona Server (GPL), Release 7, Revision 613e312\n\nCopyright (c) 2009-2019 Percona LLC and\/or its affiliates\nCopyright (c) 2000, 2019, 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; select user, host, plugin, authentication_string from mysql.user where user ='percona';\n+---------+-----------+-------------+-----------------------+\n| user\u00a0 \u00a0 | host \u00a0 | plugin \u00a0 | authentication_string |\n+---------+-----------+-------------+-----------------------+\n| percona | localhost | auth_socket | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\n+---------+-----------+-------------+-----------------------+\n1 row in set (0.00 sec)<\/code><\/pre>\n<p><\/p>\n<p>\u0418 \u0441\u043d\u043e\u0432\u0430 \u043f\u043e\u043b\u0443\u0447\u0438\u043b\u043e\u0441\u044c!<\/p>\n<p><\/p>\n<p>\u0412\u043e\u043f\u0440\u043e\u0441: \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u0441\u044f \u043b\u0438 \u0432\u043e\u0439\u0442\u0438 \u0432 \u0441\u0438\u0441\u0442\u0435\u043c\u0443 \u043f\u043e\u0434 \u0442\u0435\u043c \u0436\u0435 \u043b\u043e\u0433\u0438\u043d\u043e\u043c percona, \u043d\u043e \u043e\u0442 \u0434\u0440\u0443\u0433\u043e\u0433\u043e \u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f?<\/p>\n<p><\/p>\n<pre><code class=\"plaintext\">[percona@ip-192-168-1-111 ~]$ logout\n[root@ip-192-168-1-111 ~]# mysql -upercona\nERROR 1698 (28000): Access denied for user 'percona'@'localhost'<\/code><\/pre>\n<p><\/p>\n<p>\u041d\u0435\u0442, \u043d\u0435 \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u0441\u044f.<\/p>\n<p><\/p>\n<h3 id=\"vyvod\">\u0412\u044b\u0432\u043e\u0434<\/h3>\n<p><\/p>\n<p>MySQL \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u0433\u0438\u0431\u043a\u0430\u044f \u0432 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 \u0430\u0441\u043f\u0435\u043a\u0442\u0430\u0445, \u043e\u0434\u0438\u043d \u0438\u0437 \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u2014 \u043c\u0435\u0442\u043e\u0434 \u0430\u0443\u0442\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0446\u0438\u0438. \u041a\u0430\u043a \u0432\u0438\u0434\u043d\u043e \u0438\u0437 \u044d\u0442\u043e\u0433\u043e \u043f\u043e\u0441\u0442\u0430, \u0434\u043e\u0441\u0442\u0443\u043f \u043c\u043e\u0436\u043d\u043e \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u0431\u0435\u0437 \u043f\u0430\u0440\u043e\u043b\u0435\u0439, \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0430\u043d\u0438\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 \u041e\u0421. \u042d\u0442\u043e \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043f\u043e\u043b\u0435\u0437\u043d\u043e \u043f\u0440\u0438 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u043d\u044b\u0445 \u0441\u0446\u0435\u043d\u0430\u0440\u0438\u044f\u0445, \u0438 \u043e\u0434\u0438\u043d \u0438\u0437 \u043d\u0438\u0445 \u2014 \u043a\u043e\u0433\u0434\u0430 \u043c\u0438\u0433\u0440\u0438\u0440\u0443\u0435\u0442\u0435 \u0441 RDS\/Aurora \u043d\u0430 \u043e\u0431\u044b\u0447\u043d\u0443\u044e MySQL, \u043f\u043e\u043b\u044c\u0437\u0443\u044f\u0441\u044c <noindex><a rel=\"nofollow\" href=\"https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/UserGuide\/UsingWithRDS.IAMDBAuth.html\">\u0430\u0443\u0442\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0446\u0438\u0435\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 IAM<\/a><\/noindex>, \u0447\u0442\u043e\u0431\u044b \u043f\u043e-\u043f\u0440\u0435\u0436\u043d\u0435\u043c\u0443 \u043f\u043e\u043b\u0443\u0447\u0430\u0442\u044c \u0434\u043e\u0441\u0442\u0443\u043f, \u043d\u043e \u0431\u0435\u0437 \u043f\u0430\u0440\u043e\u043b\u0435\u0439.<\/p>\n<p>\u0418\u0441\u0442\u043e\u0447\u043d\u0438\u043a: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/southbridge\/blog\/478930\/\">habr.com<\/a><\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0413\u043e\u0432\u043e\u0440\u044f\u0442, \u0447\u0442\u043e \u043b\u0443\u0447\u0448\u0438\u0439 \u043f\u0430\u0440\u043e\u043b\u044c \u2014 \u0442\u043e\u0442, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043d\u0435 \u043d\u0430\u0434\u043e \u0437\u0430\u043f\u043e\u043c\u0438\u043d\u0430\u0442\u044c. \u0412 \u0441\u043b\u0443\u0447\u0430\u0435 \u0441 MySQL \u044d\u0442\u043e \u0440\u0435\u0430\u043b\u044c\u043d\u043e \u0431\u043b\u0430\u0433\u043e\u0434\u0430\u0440\u044f \u043f\u043b\u0430\u0433\u0438\u043d\u0443 auth_socket \u0438 \u0435\u0433\u043e \u0432\u0435\u0440\u0441\u0438\u0438 \u0434\u043b\u044f MariaDB \u2014 unix_socket. \u041e\u0431\u0430 \u044d\u0442\u0438 \u043f\u043b\u0430\u0433\u0438\u043d\u0430 \u2014 \u0432\u043e\u0432\u0441\u0435 \u043d\u0435 \u043d\u043e\u0432\u044b, \u043e \u043d\u0438\u0445 \u043c\u043d\u043e\u0433\u043e \u0433\u043e\u0432\u043e\u0440\u0438\u043b\u043e\u0441\u044c \u0432 \u044d\u0442\u043e\u043c \u0436\u0435 \u0431\u043b\u043e\u0433\u0435, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 \u0432 \u0441\u0442\u0430\u0442\u044c\u0435 \u043e \u0442\u043e\u043c, \u043a\u0430\u043a \u0438\u0437\u043c\u0435\u043d\u044f\u0442\u044c \u043f\u0430\u0440\u043e\u043b\u0438 \u0432 MySQL 5.7, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u043f\u043b\u0430\u0433\u0438\u043d auth_socket. [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":53734,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-53733","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0413\u043e\u0432\u043e\u0440\u044f\u0442, \u0447\u0442\u043e \u043b\u0443\u0447\u0448\u0438\u0439 \u043f\u0430\u0440\u043e\u043b\u044c \u2014 \u0442\u043e\u0442, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043d\u0435 \u043d\u0430\u0434\u043e \u0437\u0430\u043f\u043e\u043c\u0438\u043d\u0430\u0442\u044c. \u0412 \u0441\u043b\u0443\u0447\u0430\u0435 \u0441 MySQL \u044d\u0442\u043e \u0440\u0435\u0430\u043b\u044c\u043d\u043e \u0431\u043b\u0430\u0433\u043e\u0434\u0430\u0440\u044f \u043f\u043b\u0430\u0433\u0438\u043d\u0443 auth_socket \u0438 \u0435\u0433\u043e \u0432\u0435\u0440\u0441\u0438\u0438 \u0434\u043b\u044f MariaDB \u2014 unix_socket. \u041e\u0431\u0430 \u044d\u0442\u0438 \u043f\u043b\u0430\u0433\u0438\u043d\u0430 \u2014 \u0432\u043e\u0432\u0441\u0435 \u043d\u0435 \u043d\u043e\u0432\u044b, \u043e \u043d\u0438\u0445 \u043c\u043d\u043e\u0433\u043e \u0433\u043e\u0432\u043e\u0440\u0438\u043b\u043e\u0441\u044c \u0432 \u044d\u0442\u043e\u043c \u0436\u0435 \u0431\u043b\u043e\u0433\u0435, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 \u0432 \u0441\u0442\u0430\u0442\u044c\u0435 \u043e \u0442\u043e\u043c, \u043a\u0430\u043a \u0438\u0437\u043c\u0435\u043d\u044f\u0442\u044c \u043f\u0430\u0440\u043e\u043b\u0438 \u0432 MySQL 5.7, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u043f\u043b\u0430\u0433\u0438\u043d auth_socket.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/de\/blog\/administrirovanie\/kak-ispolzovat-mysql-bez-parolya-i-riskov-dlya-bezopasnosti\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"de_DE\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u041a\u0430\u043a \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c MySQL \u0431\u0435\u0437 \u043f\u0430\u0440\u043e\u043b\u044f (\u0438 \u0440\u0438\u0441\u043a\u043e\u0432 \u0434\u043b\u044f \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u0438) | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0413\u043e\u0432\u043e\u0440\u044f\u0442, \u0447\u0442\u043e \u043b\u0443\u0447\u0448\u0438\u0439 \u043f\u0430\u0440\u043e\u043b\u044c \u2014 \u0442\u043e\u0442, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043d\u0435 \u043d\u0430\u0434\u043e \u0437\u0430\u043f\u043e\u043c\u0438\u043d\u0430\u0442\u044c. \u0412 \u0441\u043b\u0443\u0447\u0430\u0435 \u0441 MySQL \u044d\u0442\u043e \u0440\u0435\u0430\u043b\u044c\u043d\u043e \u0431\u043b\u0430\u0433\u043e\u0434\u0430\u0440\u044f \u043f\u043b\u0430\u0433\u0438\u043d\u0443 auth_socket \u0438 \u0435\u0433\u043e \u0432\u0435\u0440\u0441\u0438\u0438 \u0434\u043b\u044f MariaDB \u2014 unix_socket. \u041e\u0431\u0430 \u044d\u0442\u0438 \u043f\u043b\u0430\u0433\u0438\u043d\u0430 \u2014 \u0432\u043e\u0432\u0441\u0435 \u043d\u0435 \u043d\u043e\u0432\u044b, \u043e \u043d\u0438\u0445 \u043c\u043d\u043e\u0433\u043e \u0433\u043e\u0432\u043e\u0440\u0438\u043b\u043e\u0441\u044c \u0432 \u044d\u0442\u043e\u043c \u0436\u0435 \u0431\u043b\u043e\u0433\u0435, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 \u0432 \u0441\u0442\u0430\u0442\u044c\u0435 \u043e \u0442\u043e\u043c, \u043a\u0430\u043a \u0438\u0437\u043c\u0435\u043d\u044f\u0442\u044c \u043f\u0430\u0440\u043e\u043b\u0438 \u0432 MySQL 5.7, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u043f\u043b\u0430\u0433\u0438\u043d auth_socket.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/de\/blog\/administrirovanie\/kak-ispolzovat-mysql-bez-parolya-i-riskov-dlya-bezopasnosti\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-12-08T21:00:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-02-18T11:01:40+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47 So verwenden Sie MySQL ohne Passwort (und Sicherheitsrisiken) | ProHoster","description":"Es wird gesagt, das beste Passwort sei das, das man sich nicht merken muss. Im Fall von MySQL ist dies tats\u00e4chlich m\u00f6glich dank des auth_socket-Plugins sowie seiner Version f\u00fcr MariaDB \u2014 unix_socket. Beide Plugins sind nicht neu und wurden in diesem Blog bereits umfangreich behandelt, zum Beispiel in dem Artikel \u00fcber das \u00c4ndern von Passw\u00f6rtern in MySQL 5.7 mit dem auth_socket-Plugin.","canonical_url":"https:\/\/prohoster.info\/de\/blog\/administrirovanie\/kak-ispolzovat-mysql-bez-parolya-i-riskov-dlya-bezopasnosti","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"de_DE","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041a\u0430\u043a \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c MySQL \u0431\u0435\u0437 \u043f\u0430\u0440\u043e\u043b\u044f (\u0438 \u0440\u0438\u0441\u043a\u043e\u0432 \u0434\u043b\u044f \u0431\u0435\u0437\u043e\u043f\u0430\u0441\u043d\u043e\u0441\u0442\u0438) | ProHoster","og:description":"\u0413\u043e\u0432\u043e\u0440\u044f\u0442, \u0447\u0442\u043e \u043b\u0443\u0447\u0448\u0438\u0439 \u043f\u0430\u0440\u043e\u043b\u044c \u2014 \u0442\u043e\u0442, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043d\u0435 \u043d\u0430\u0434\u043e \u0437\u0430\u043f\u043e\u043c\u0438\u043d\u0430\u0442\u044c. \u0412 \u0441\u043b\u0443\u0447\u0430\u0435 \u0441 MySQL \u044d\u0442\u043e \u0440\u0435\u0430\u043b\u044c\u043d\u043e \u0431\u043b\u0430\u0433\u043e\u0434\u0430\u0440\u044f \u043f\u043b\u0430\u0433\u0438\u043d\u0443 auth_socket \u0438 \u0435\u0433\u043e \u0432\u0435\u0440\u0441\u0438\u0438 \u0434\u043b\u044f MariaDB \u2014 unix_socket. \u041e\u0431\u0430 \u044d\u0442\u0438 \u043f\u043b\u0430\u0433\u0438\u043d\u0430 \u2014 \u0432\u043e\u0432\u0441\u0435 \u043d\u0435 \u043d\u043e\u0432\u044b, \u043e \u043d\u0438\u0445 \u043c\u043d\u043e\u0433\u043e \u0433\u043e\u0432\u043e\u0440\u0438\u043b\u043e\u0441\u044c \u0432 \u044d\u0442\u043e\u043c \u0436\u0435 \u0431\u043b\u043e\u0433\u0435, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 \u0432 \u0441\u0442\u0430\u0442\u044c\u0435 \u043e \u0442\u043e\u043c, \u043a\u0430\u043a \u0438\u0437\u043c\u0435\u043d\u044f\u0442\u044c \u043f\u0430\u0440\u043e\u043b\u0438 \u0432 MySQL 5.7, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u043f\u043b\u0430\u0433\u0438\u043d auth_socket.","og:url":"https:\/\/prohoster.info\/de\/blog\/administrirovanie\/kak-ispolzovat-mysql-bez-parolya-i-riskov-dlya-bezopasnosti","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-12-08T21:00:00+00:00","article:modified_time":"2020-02-18T11:01:40+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"53733","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-24 08:32:22","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 14:11:13","updated":"2026-01-24 08:32:22"},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts\/53733","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/comments?post=53733"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts\/53733\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/media\/53734"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/media?parent=53733"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/categories?post=53733"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/tags?post=53733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}