{"id":707,"date":"2014-09-01T16:57:11","date_gmt":"2014-09-01T16:57:11","guid":{"rendered":"http:\/\/adriangrigoras.com\/blog\/?p=707"},"modified":"2016-09-01T16:58:48","modified_gmt":"2016-09-01T16:58:48","slug":"enable-remote-access-mysql-ubuntu","status":"publish","type":"post","link":"https:\/\/adriangrigoras.com\/blog\/enable-remote-access-mysql-ubuntu\/","title":{"rendered":"Enable remote access of MySql on Ubuntu"},"content":{"rendered":"

By default MySQL only listens to localhost, if we want to enable the remote access to it, then we need to made some changes in my.cnf<\/span> file:<\/p>\n

We need to comment out the bind-address and skip-external-locking lines.<\/p>\n

 <\/p>\n

Restart mysql<\/p>\n

 <\/p>\n

Check the process:<\/p>\n

lsof <\/span>-<\/span>i <\/span>-<\/span>P <\/span>|<\/span> grep <\/span>:<\/span>3306\r\n\r\nCreate user:\r\n<\/span><\/code><\/pre>\n
CREATE<\/span> USER<\/span> 'myuser'<\/span>@<\/span>'localhost'<\/span> IDENTIFIED <\/span>BY<\/span> 'mypass'<\/span>;<\/span>\r\nCREATE<\/span> USER<\/span> 'myuser'<\/span>@<\/span>'%'<\/span> IDENTIFIED <\/span>BY<\/span> 'mypass'<\/span>;\r\n\r\n<\/span><\/code>Grant access:<\/pre>\n
GRANT<\/span> ALL<\/span> ON<\/span> *.*<\/span> TO<\/span> 'myuser'<\/span>@<\/span>'localhost'<\/span>;<\/span>\r\nGRANT<\/span> ALL<\/span> ON<\/span> *.*<\/span> TO<\/span> 'myuser'<\/span>@<\/span>'%'<\/span>;<\/span><\/code><\/pre>\n
FLUSH PRIVILEGES<\/span>;<\/span> <\/code><\/pre>\n
\u00a0<\/span><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
By default MySQL only listens to localhost, if we want to enable the remote access to it, then we need to made some changes in my.cnf file: We need to comment out the bind-address and skip-external-locking lines.   Restart mysql   Check the process: lsof -i -P | grep :3306 Create user: CREATE USER ‘myuser’@’localhost’\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-707","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/adriangrigoras.com\/blog\/wp-json\/wp\/v2\/posts\/707","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adriangrigoras.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adriangrigoras.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adriangrigoras.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adriangrigoras.com\/blog\/wp-json\/wp\/v2\/comments?post=707"}],"version-history":[{"count":1,"href":"https:\/\/adriangrigoras.com\/blog\/wp-json\/wp\/v2\/posts\/707\/revisions"}],"predecessor-version":[{"id":708,"href":"https:\/\/adriangrigoras.com\/blog\/wp-json\/wp\/v2\/posts\/707\/revisions\/708"}],"wp:attachment":[{"href":"https:\/\/adriangrigoras.com\/blog\/wp-json\/wp\/v2\/media?parent=707"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adriangrigoras.com\/blog\/wp-json\/wp\/v2\/categories?post=707"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adriangrigoras.com\/blog\/wp-json\/wp\/v2\/tags?post=707"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}