{"id":6368,"date":"2020-02-06T16:09:25","date_gmt":"2020-02-06T07:09:25","guid":{"rendered":"http:\/\/auctionpro.co.kr\/?p=6368"},"modified":"2023-05-12T16:33:51","modified_gmt":"2023-05-12T07:33:51","slug":"mysql-workbench-warning-when-connecting-to-mariadb","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=6368","title":{"rendered":"MySQL Workbench warning when connecting to MariaDB"},"content":{"rendered":"\n

CenOS\uc5d0 MariaDB \uc124\uce58 \ud6c4<\/h2>\n\n\n\n

remote \uc5f4\uae30<\/h4>\n\n\n\n
cd \/etc\/my.cnf.d\n# ls\nclient.cnf  enable_encryption.preset  mysql-clients.cnf  server.cnf  tokudb.cnf\n<\/pre>\n\n\n\n
#sudo vi \/etc\/mysql\/mariadb.conf.d\/50-server.cnf\n\n \nbind-address=0.0.0.0\n<\/pre>\n\n\n\n
3306 \ud3ec\ud2b8 \uc5f4\uae30<\/p>\n\n\n\n
[root@localhost my.cnf.d]# cat \/etc\/sysconfig\/iptables\n# sample configuration for iptables service\n# you can edit this manually or use system-config-firewall\n# please do not ask us to add additional ports\/services to this default configuration\n*filter\n:INPUT ACCEPT [0:0]\n:FORWARD ACCEPT [0:0]\n:OUTPUT ACCEPT [0:0]\n-A INPUT -m state --state RELATED,ESTABLISHED -j ACCEPT\n-A INPUT -p icmp -j ACCEPT\n-A INPUT -i lo -j ACCEPT\n-A INPUT -p tcp -m state --state NEW -m tcp --dport 22 -j ACCEPT\n-A INPUT -p tcp -m state --state NEW -m tcp --dport 80 -j ACCEPT\n-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT\n-A INPUT -j REJECT --reject-with icmp-host-prohibited\n-A FORWARD -j REJECT --reject-with icmp-host-prohibited\nCOMMIT<\/pre>\n\n\n\n
ubuntu ufw<\/h2>\n\n\n\n
$ sudo ufw allow 3306\n$ sudo ufw reload<\/pre><\/div>\n\n\n\n
root \uacc4\uc815 \ub9ac\ubaa8\ud2b8(%) \uac00\ub2a5 \uc73c\ub85c \ubcc0\uacbd (10.5 \uc774\ud558\uc5d0\uc11c\ub9cc \uac00\ub2a5)
 \"\"<\/h4>\n\n\n\n
MariaDB 10.5 \uc774\uc0c1\uc5d0\uc11c \uc5d0\ub7ec<\/h2>\n\n\n\n
MariaDB [mysql]> UPDATE user SET Host='%' WHERE User='root'; \nERROR 1356 (HY000): View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer\/invoker of view lack rights to use them<\/pre><\/div>\n\n\n\n
MariaDB [mysql]> Select version();\n+-------------------+\n| version()         |\n+-------------------+\n| 10.11.2-MariaDB-1 |\n+-------------------+\n1 row in set (0.001 sec)\n<\/pre><\/div>\n\n\n\n
Solution<\/h2>\n\n\n\n
RENAME USER 'root'@'localhost' TO 'root'@'%\"; <\/pre><\/div>\n\n\n\n
MariaDB [mysql]> select user,host, password  from user;\n+-------------+-----------+-------------------------------------------+\n| User        | Host      | Password                                  |\n+-------------+-----------+-------------------------------------------+\n| mariadb.sys | localhost |                                           |\n| root        | %         | *04652067D332F58564F759B8E962EA90F3498EA1 |\n| mysql       | localhost | invalid                                   |\n+-------------+-----------+-------------------------------------------+\n<\/pre><\/div>\n\n\n\n
Password \ubcc0\uacbd<\/h2>\n\n\n\n
set password for 'root'@'localhost' = password('password');\nflush privileges;<\/pre><\/div>\n\n\n\n
iptable \ubc0f mysql \uc7ac\uc2dc\uc791\ud6c4 MySQL Workbench \ub85c \uc5f4\uae30
\n\uc544\ub798 \uba54\uc2dc\uc9c0 \ubb34\uc2dc
\n\ucc38\uc870 : https:\/\/unix.stackexchange.com\/questions\/252275\/mysql-workbench-warning-when-connecting-to-mariadb<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\uc5f0\uacb0\ub41c \uc0c1\ud0dc
\n\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"
CenOS\uc5d0 MariaDB \uc124\uce58 \ud6c4 remote \uc5f4\uae30 cd \/etc\/my.cnf.d # ls client.cnf enable_encryption.preset mysql-clients.cnf server.cnf tokudb.cnf #sudo vi \/etc\/mysql\/mariadb.conf.d\/50-server.cnf bind-address=0.0.0.0 3306 \ud3ec\ud2b8 \uc5f4\uae30 [root@localhost my.cnf.d]# cat […]<\/a><\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[225],"tags":[],"class_list":["post-6368","post","type-post","status-publish","format-standard","hentry","category-mariadb"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/6368","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6368"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/6368\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6368"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}