{"id":46,"date":"2015-08-11T14:51:11","date_gmt":"2015-08-11T13:51:11","guid":{"rendered":"http:\/\/www.haxed.me.uk\/?p=46"},"modified":"2015-08-12T18:00:28","modified_gmt":"2015-08-12T17:00:28","slug":"remotely-administering-a-mysql-server-and-error-10060","status":"publish","type":"post","link":"https:\/\/haxed.me.uk\/index.php\/2015\/08\/11\/remotely-administering-a-mysql-server-and-error-10060\/","title":{"rendered":"Remotely administering a MySQL server, and error 10060"},"content":{"rendered":"<p>Note to self 10060 is caused by an iptables problem, not a MySQL grant problem!!!<\/p>\n<p>Will update this article in coming week.<\/p>\n<p>We had a customer which was getting an error 10060 when trying to connect to MySQL Server. Obviously 10060 error code is explaining that MySQL doesn&#8217;t think the remote is allowed, so closes the connection.<\/p>\n<p>The user only has to do a few things to make sure they are allowed, which is basically make sure the right MySQL grants are added on the mysql server they are trying to access remotely. Please note that the section &#8216;<code class=\"bash string\">5F398fDKof$%<\/code>&#8216; denotes the password, and somemysqluser denotes the username and the 10.2.1.1 denotes the ip address. you will need to replace the ip address with the remote machine you want to access your mysql server, and replace the username with the user you want to connect with. Please, use a different password than &#8216;<code class=\"bash string\">5F398fDKof$%<\/code>&#8216; as well, to ensure your installation is as secure as it possibly can be.<\/p>\n<p>So, something like this, will be great:<\/p>\n<blockquote>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\"><\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">GRANT ALL PRIVILEGES ON DB_NAME.* TO <\/code><code class=\"bash string\">'somemysqluser'<\/code><code class=\"bash plain\">@<\/code><code class=\"bash string\">'10.2.1.1'<\/code> <code class=\"bash plain\">IDENTIFIED BY <\/code><code class=\"bash string\">'5F398fDKof$%'<\/code><code class=\"bash plain\">;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Note to self 10060 is caused by an iptables problem, not a MySQL grant problem!!! Will update this article in coming week. We had a customer which was getting an error 10060 when trying to connect to MySQL Server. Obviously &hellip; <a href=\"https:\/\/haxed.me.uk\/index.php\/2015\/08\/11\/remotely-administering-a-mysql-server-and-error-10060\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/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-46","post","type-post","status-publish","format-standard","hentry","category-uncategorised"],"_links":{"self":[{"href":"https:\/\/haxed.me.uk\/index.php\/wp-json\/wp\/v2\/posts\/46","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/haxed.me.uk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/haxed.me.uk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/haxed.me.uk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/haxed.me.uk\/index.php\/wp-json\/wp\/v2\/comments?post=46"}],"version-history":[{"count":0,"href":"https:\/\/haxed.me.uk\/index.php\/wp-json\/wp\/v2\/posts\/46\/revisions"}],"wp:attachment":[{"href":"https:\/\/haxed.me.uk\/index.php\/wp-json\/wp\/v2\/media?parent=46"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/haxed.me.uk\/index.php\/wp-json\/wp\/v2\/categories?post=46"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/haxed.me.uk\/index.php\/wp-json\/wp\/v2\/tags?post=46"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}