{"id":39,"date":"2016-05-18T03:33:13","date_gmt":"2016-05-18T05:33:13","guid":{"rendered":"http:\/\/vejas.defas.lt\/?p=39"},"modified":"2018-02-10T11:04:54","modified_gmt":"2018-02-10T13:04:54","slug":"mysql-apache-php-instaliavimas","status":"publish","type":"post","link":"http:\/\/vejas.defas.lt\/?p=39","title":{"rendered":"MySQL, Apache, PHP instaliavimas"},"content":{"rendered":"<p>Pasileid\u017eiu termilnal\u0105 pasitiktinti, gal yra PHP?<br \/>\n#sudo su &#8211;<br \/>\n#find \/ -name php.ini<br \/>\nNieko nerado. Tada einu \u012f Menu-&gt;Preferences-&gt;Add\/Remove Software.Randu Apache HTTP Server (apache2-2.4.10-10+deb8u4), pa\u017eymiu varnele ir spaud\u017eiu OK. Pra\u0161o autorizacijos, pasirinkimui useris: pi arba root. \u0160iaip sistemoje root nesuteiktas slapta\u017eodis, ta\u010diau \u010dia root be slapta\u017eod\u017eio netinka. Pakei\u010diu root slapta\u017eod\u012f \u012f &#8216;root&#8217; komanda &#8216;passwd root&#8217; tame pa\u010diame, kaip ir failo paie\u0161kos terminaliniame lange. Toliau ie\u0161kau php5 paketo. Randu server-side, HTML-embeded scripting language(metapackage). Instaliuojam. Sekantis paketas MySQL database server. Papildomai suinstaliuojame mc paket\u0105.<\/p>\n<p>Teko perinstaliuoti vis\u0105 SD kortel\u0119, taigi pakartoti visas komandas. \u010cia pateiksiu santrauk\u0105, k\u0105 reikia instaliuoti<br \/>\nRadau rekomenduotin\u0105 eili\u0161kum\u0105 su papildomais paketais:<\/p>\n<pre style=\"font-size: small;\">apt-get install mysql-server mysql-client\r\napt-get install apache2 (<u>apt-get install apache2 -y<\/u> - k\u0105 rei\u0161kia raktas -y?)\r\napt-get install php5 libapache2-mod-php5 \r\n(\r\npaskutin\u0117je Rpi versijoje jau php7 instaliuojamas \r\n<u>apt-get install php libapache2-mod-php -y<\/u> \r\npataisyti <u>short_open_tag=on<\/u> faile \/etc\/php\/7.0\/apache2\/php.ini\r\nKad veikt\u0173 apache su mysql:sudo apt-get install php-mysqli.\r\nkad i\u0161vedin\u0117t\u0173 klaidas pataisom: display_errors=on nustatym\u0105 php.ini faile. \r\nBe jo error_reporting() funksija neveikia\r\n)\r\napt-get install proftpd \r\napt-get install libmysqlclient-dev \r\napt-get install wiringpi \r\napt-get install iptraf\r\n<\/pre>\n<p>Po to perstartuojame apache servis\u0105:<br \/>\nJei reikia kit\u0173 paket\u0173:<\/p>\n<pre>apt-get install php5-mysql php5-curl php5-gd php5-intl php-pear php5-imagick php5-imap php5-mcrypt php5-memcache php5-ming php5-ps php5-pspell php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5-xsl<\/pre>\n<p>Enable Remote Access (Grant) Home \/ Tutorials \/ Mysql \/ Enable Remote Access (Grant) If you try to connect to your mysql server from remote machine, and run into error like below, this article is for you.<\/p>\n<p>Change mysql config<br \/>\nStart with editing mysql config file<\/p>\n<pre>vim \/etc\/mysql\/my.cnf<\/pre>\n<p>Comment out following lines.<\/p>\n<pre>#bind-address           =127.0.0.1\r\n#skip-networking<\/pre>\n<p>If you do not find skip-networking line, add it and comment out it.<\/p>\n<p>Restart mysql server.<\/p>\n<pre>~\/etc\/init.d\/mysql restart<\/pre>\n<p>Change GRANT privilege<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pasileid\u017eiu termilnal\u0105 pasitiktinti, gal yra PHP? #sudo su &#8211; #find \/ -name php.ini Nieko nerado. Tada einu \u012f Menu-&gt;Preferences-&gt;Add\/Remove Software.Randu Apache HTTP Server (apache2-2.4.10-10+deb8u4), pa\u017eymiu varnele ir spaud\u017eiu OK. Pra\u0161o autorizacijos, pasirinkimui useris: pi arba root. \u0160iaip sistemoje root nesuteiktas slapta\u017eodis, ta\u010diau \u010dia root be slapta\u017eod\u017eio netinka. Pakei\u010diu root slapta\u017eod\u012f \u012f &#8216;root&#8217; komanda &#8216;passwd root&#8217; &hellip; <a href=\"http:\/\/vejas.defas.lt\/?p=39\" class=\"more-link\">Skaityti toliau: <span class=\"screen-reader-text\">MySQL, Apache, PHP instaliavimas<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-39","post","type-post","status-publish","format-standard","hentry","category-be-kategorijos"],"acf":[],"_links":{"self":[{"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/posts\/39","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=39"}],"version-history":[{"count":18,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/posts\/39\/revisions"}],"predecessor-version":[{"id":410,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=\/wp\/v2\/posts\/39\/revisions\/410"}],"wp:attachment":[{"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=39"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=39"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/vejas.defas.lt\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=39"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}