{"id":228,"date":"2010-05-21T15:00:56","date_gmt":"2010-05-21T13:00:56","guid":{"rendered":"http:\/\/www.mythryll.com\/?p=228"},"modified":"2011-04-07T12:08:57","modified_gmt":"2011-04-07T10:08:57","slug":"mysql-remote-access","status":"publish","type":"post","link":"https:\/\/www.mythryll.com\/?p=228","title":{"rendered":"Mysql remote access"},"content":{"rendered":"<p>Your mysql configuration file is probably \/etc\/my.cnf<br \/>\nMake sure your server is running. If not start it with<br \/>\n<code>\/etc\/init.d\/mysql start<\/code><br \/>\nEnter mysql command line mode:<br \/>\n<code>mysql -u root -p<\/code><br \/>\nYour first password should be blank. You then need to enable remote access with the following command, replace where necessary:<br \/>\n<code>mysql&gt; GRANT ALL PRIVILEGES ON *.* TO 'typeusername'@'localhost' IDENTIFIED BY 'typepasswordhere' WITH GRANT OPTION;<\/code><br \/>\nsources:<br \/>\n<a href=\"http:\/\/www.cyberciti.biz\/tips\/how-do-i-enable-remote-access-to-mysql-database-server.html\" target=\"_blank\">http:\/\/www.cyberciti.biz\/tips\/how-do-i-enable-remote-access-to-mysql-database-server.html<\/a><br \/>\n<a title=\"remote access\" href=\"http:\/\/forums.mysql.com\/read.php?34,92009,186960#msg-186960\" target=\"_blank\">http:\/\/forums.mysql.com\/read.php?34,92009,186960#msg-186960<\/a><br \/>\n<a href=\"http:\/\/ubuntuforums.org\/showthread.php?t=252842\" target=\"_blank\">http:\/\/ubuntuforums.org\/showthread.php?t=252842<\/a><br \/>\n<a href=\"http:\/\/blog.johan-mares.be\/ict\/linux\/installing-a-virtual-ubuntu-lamp-server-on-mac-os-x-using-virtualbox\/\" target=\"_blank\">http:\/\/blog.johan-mares.be\/ict\/linux\/installing-a-virtual-ubuntu-lamp-server-on-mac-os-x-using-virtualbox\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Your mysql configuration file is probably \/etc\/my.cnf Make sure your server is running. If not start it with \/etc\/init.d\/mysql start Enter mysql command line mode: mysql -u root -p Your first password should be blank. You then need to enable remote access with the following command, replace where necessary: mysql&gt; GRANT ALL PRIVILEGES ON *.*&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"class_list":["post-228","post","type-post","status-publish","format-standard","hentry","category-it"],"_links":{"self":[{"href":"https:\/\/www.mythryll.com\/index.php?rest_route=\/wp\/v2\/posts\/228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mythryll.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mythryll.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mythryll.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mythryll.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=228"}],"version-history":[{"count":7,"href":"https:\/\/www.mythryll.com\/index.php?rest_route=\/wp\/v2\/posts\/228\/revisions"}],"predecessor-version":[{"id":406,"href":"https:\/\/www.mythryll.com\/index.php?rest_route=\/wp\/v2\/posts\/228\/revisions\/406"}],"wp:attachment":[{"href":"https:\/\/www.mythryll.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mythryll.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mythryll.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}