Ubuntu Linux - Apache, MySQL, PHP ინსტალაცია

LAMP არის Linux, Apache, MySQL, PHP. განკუთვნილია იმათთვის ვისაც აქვს ძალიან მცირე გამოცდილება ლინუქსში

აპაჩის ინსტალაცია

დასაწყისში უნდა დაყენდეს აპაჩი.

1. გახსენით ტერმინალი პროგრამები>აქსესუარები>ტერმინალი (Applications > Accessories > Terminal)

1. აკრიფეთ შემდეგი ბრძანება

---------------------------------------------- sudo apt-get install apache2

----------------------------------------------

აპაჩის ტესტირება ყველაფრის სისწორეში დარწმუნებისათვის უნდა მოხდეს აპაჩის ტესტირება. გახსენით ნებისმიერ ბრაუზერი და აკრიფეთ შემდეგი მისამართი:

1. მოთხოვნისას შეიყვანეთ პაროლი. და დაეთანხმეთ შემოთავაზებული პაკეტების ინსტალაციას.

--------------------------

http://localhost

--------------------------

უნდა გამოჩნდეს კატალოგი apache2-default/ გახსენით და თქვენ დაინახავთ შეტყობინებას "It works!"works!" , congrats to you!

დავაყენოთ PHP ახლა კი უნდა დავაყენოთ PHP 5.

1. ისევ გავხსნათ ტერმინალი.
2. ავკრიფოთ ბრძანება:

-----------------------------------------------------------------------------

sudo apt-get install php5 libapache2-mod-php5 -----------------------------------------------------------------------------

1. იმისათვის რომ ამუშავდეს PHP მოდული საჭიროა აპაჩის გადატვირთვა, ტერმინალში უნდა ავკრიფოთ

----------------------------------------------------- sudo /etc/init.d/apache2 restart -----------------------------------------------------

PHP ტესტირება

პრობლემების თავიდან ასაცილებლად ჩავატაროთ მარტივი ტესტი.

1. ტერმინალში ავკრიფოთ ბრძანება

------------------------------------------------------- sudo gedit /var/www/testphp.php -------------------------------------------------------

გაიხსნება ფაილი სახელით phptest.php.

1. გადაიტანეთ შემდეგი ტექსტი ფაილში:

---------------------------------- <?php phpinfo(); ?> ----------------------------------

1. &#4307;&#4304;&#4334;&#4323;&#4320;&#4308;&#4311; &#4307;&#4304; &#4328;&#4308;&#4312;&#4316;&#4304;&#4334;&#4308;&#4311; &#4324;&#4304;&#4312;&#4314;&#4312;

1. &#4306;&#4304;&#4334;&#4321;&#4308;&#4316;&#4312;&#4311; &#4305;&#4320;&#4304;&#4323;&#4310;&#4308;&#4320;&#4312; &#4307;&#4304; &#4304;&#4313;&#4320;&#4312;&#4324;&#4308;&#4311; &#4315;&#4312;&#4321;&#4304;&#4315;&#4304;&#4320;&#4311;&#4312;

----------------------------------------------

http://localhost/testphp.php

----------------------------------------------

&#4323;&#4316;&#4307;&#4304; &#4306;&#4304;&#4315;&#4317;&#4329;&#4316;&#4307;&#4308;&#4321; &#4315;&#4321;&#4306;&#4304;&#4309;&#4321;&#4312; &#4306;&#4309;&#4308;&#4320;&#4307;&#4312;:

MySQL &#4312;&#4316;&#4321;&#4322;&#4304;&#4314;&#4304;&#4330;&#4312;&#4304;.

&#4307;&#4304; &#4305;&#4317;&#4314;&#4317;&#4321; &#4323;&#4316;&#4307;&#4304; &#4307;&#4304;&#4309;&#4304;&#4327;&#4308;&#4316;&#4317;&#4311; MySQL.

1. &#4312;&#4321;&#4308;&#4309; &#4307;&#4304; &#4312;&#4321;&#4308;&#4309; &#4322;&#4308;&#4320;&#4315;&#4312;&#4316;&#4304;&#4314;&#4328;&#4312; &#4304;&#4309;&#4313;&#4312;&#4320;&#4324;&#4317;&#4311; &#4305;&#4320;&#4331;&#4304;&#4316;&#4308;&#4305;&#4304;

-----------------------------------------------------

sudo apt-get install mysql-server -----------------------------------------------------

1. (&#4328;&#4308;&#4320;&#4329;&#4308;&#4309;&#4312;&#4311;) &#4312;&#4315;&#4312;&#4321;&#4304;&#4311;&#4309;&#4312;&#4321; &#4320;&#4317;&#4315; &#4321;&#4334;&#4309;&#4304; &#4313;&#4317;&#4315;&#4318;&#4312;&#4323;&#4322;&#4308;&#4320;&#4308;&#4305;&#4315;&#4304; &#4328;&#4308;&#4331;&#4314;&#4317;&#4316; &#4315;&#4323;&#4328;&#4304;&#4317;&#4305;&#4304; &#4311;&#4325;&#4309;&#4308;&#4316;&#4321; &#4315;&#4317;&#4316;&#4304;&#4330;&#4308;&#4315;&#4311;&#4304; &#4305;&#4304;&#4310;&#4308;&#4305;&#4311;&#4304;&#4316;, &#4323;&#4316;&#4307;&#4304; &#4328;&#4308;&#4330;&#4309;&#4304;&#4314;&#4317;&#4311; "Bind Address". &#4304;&#4315;&#4312;&#4321;&#4304;&#4311;&#4309;&#4312;&#4321; &#4322;&#4308;&#4320;&#4315;&#4312;&#4316;&#4304;&#4314;&#4328;&#4312; &#4304;&#4313;&#4320;&#4312;&#4324;&#4308;&#4311; &#4305;&#4320;&#4331;&#4304;&#4316;&#4308;&#4305;&#4304;

---------------------------------------------------

gksudo gedit /etc/mysql/my.cnf

---------------------------------------------------

&#4328;&#4308;&#4330;&#4309;&#4304;&#4314;&#4308;&#4311; &#4321;&#4322;&#4320;&#4312;&#4325;&#4317;&#4316;&#4312;

------------------------------------------

bind-address = 127.0.0.1

------------------------------------------

&#4307;&#4304; &#4328;&#4308;&#4330;&#4309;&#4304;&#4314;&#4308;&#4311; 127.0.0.1 &#4311;&#4325;&#4309;&#4308;&#4316;&#4312; &#4315;&#4312;&#4321;&#4304;&#4315;&#4304;&#4320;&#4311;&#4312;&#4311;.

1. &#4304;&#4334;&#4314;&#4304; &#4313;&#4312; &#4304;&#4313;&#4320;&#4312;&#4324;&#4308;&#4311; &#4328;&#4308;&#4315;&#4307;&#4308;&#4306;&#4312; &#4321;&#4322;&#4320;&#4312;&#4325;&#4317;&#4316;&#4312; &#4322;&#4308;&#4320;&#4315;&#4312;&#4316;&#4304;&#4314;&#4328;&#4312;

----------------------- mysql -u root -----------------------

&#4328;&#4308;&#4315;&#4307;&#4308;&#4306; &#4304;&#4313;&#4320;&#4312;&#4324;&#4308;&#4311;

-------------------------------------------------------------------------------------------------------------------------------- mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword'); -------------------------------------------------------------------------------------------------------------------------------- &#4304;&#4323;&#4330;&#4312;&#4314;&#4308;&#4305;&#4314;&#4304;&#4307; yourpassword-&#4312;&#4321; &#4316;&#4304;&#4330;&#4309;&#4314;&#4304;&#4307; &#4315;&#4312;&#4323;&#4311;&#4312;&#4311;&#4308;&#4311; &#4320;&#4304;&#4315;&#4308; &#4318;&#4304;&#4320;&#4317;&#4314;&#4312;.

&#4322;&#4308;&#4320;&#4315;&#4312;&#4316;&#4304;&#4314;&#4328;&#4312; &#4304;&#4309;&#4313;&#4320;&#4312;&#4324;&#4317;&#4311;:

1. &#4304;&#4334;&#4314;&#4304; &#4313;&#4312; &#4307;&#4304;&#4309;&#4304;&#4327;&#4308;&#4316;&#4317;&#4311; &#4315;&#4317;&#4316;&#4304;&#4330;&#4308;&#4315;&#4311;&#4304; &#4305;&#4304;&#4310;&#4308;&#4305;&#4312;&#4321; &#4304;&#4307;&#4315;&#4312;&#4316;&#4312;&#4321;&#4322;&#4320;&#4312;&#4320;&#4308;&#4305;&#4312;&#4321; &#4312;&#4316;&#4321;&#4322;&#4320;&#4323;&#4315;&#4308;&#4316;&#4322;&#4312; phpMyAdmin.

------------------------------------------------------------------------------------

sudo apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin

------------------------------------------------------------------------------------

&#4328;&#4308;&#4315;&#4307;&#4308;&#4306; &#4312;&#4321;&#4308;&#4309; &#4322;&#4308;&#4320;&#4315;&#4312;&#4316;&#4304;&#4314;&#4328;&#4312;:

-----------------------------------------------

gksudo gedit /etc/php5/apache2/php.ini

-----------------------------------------------

&#4315;&#4317;&#4309;&#4304;&#4328;&#4317;&#4320;&#4317;&#4311; &#4313;&#4317;&#4315;&#4308;&#4316;&#4322;&#4304;&#4320;&#4312;&#4321; &#4316;&#4312;&#4328;&#4304;&#4316;&#4312; &#4321;&#4322;&#4320;&#4312;&#4325;&#4317;&#4316;&#4321; (;).

&#4308;&#4321; &#4321;&#4322;&#4320;&#4312;&#4325;&#4317;&#4316;&#4312;

;extension=mysql.so

&#4323;&#4316;&#4307;&#4304; &#4312;&#4327;&#4317;&#4321; &#4304;&#4321;&#4308;:

extension=mysql.so

&#4306;&#4304;&#4307;&#4304;&#4322;&#4309;&#4312;&#4320;&#4311;&#4308;&#4311; &#4304;&#4318;&#4304;&#4329;&#4312;:

--------------------------------------

sudo /etc/init.d/apache2 restart

--------------------------------------

&#4307;&#4304; &#4305;&#4317;&#4314;&#4317;&#4321; &#4307;&#4304;&#4309;&#4304;&#4327;&#4308;&#4316;&#4317;&#4311; PHPMyAdmin

--------------------------------------------

sudo apt-get install phpmyadmin

-------------------------------------------

&#4306;&#4304;&#4309;&#4334;&#4321;&#4316;&#4304;&#4311; &#4305;&#4320;&#4304;&#4323;&#4310;&#4308;&#4320;&#4312; &#4307;&#4304; &#4304;&#4313;&#4320;&#4312;&#4324;&#4308;&#4311; &#4315;&#4312;&#4321;&#4304;&#4315;&#4304;&#4320;&#4311;&#4312;

http://localhost/phpmyadmin

&#4328;&#4308;&#4312;&#4327;&#4309;&#4304;&#4316;&#4308;&#4311; mysql&#8211;&#4312;&#4321; root &#4315;&#4317;&#4315;&#4334;&#4315;&#4304;&#4320;&#4308;&#4305;&#4314;&#4312;&#4321; &#4318;&#4304;&#4320;&#4317;&#4314;&#4312;.

&#4317;&#4318;&#4308;&#4320;&#4304;&#4330;&#4312;&#4312;&#4321; &#4332;&#4304;&#4320;&#4315;&#4304;&#4322;&#4308;&#4305;&#4312;&#4311; &#4307;&#4304;&#4321;&#4320;&#4323;&#4314;&#4308;&#4305;&#4304; &#4312;&#4315;&#4312;&#4321; &#4307;&#4304;&#4321;&#4322;&#4323;&#4320;&#4312; &#4312;&#4325;&#4316;&#4308;&#4305;&#4304; &#4320;&#4317;&#4315; &#4327;&#4309;&#4308;&#4314;&#4304;&#4324;&#4308;&#4320;&#4312; &#4320;&#4312;&#4306;&#4310;&#4308;&#4304; &#4307;&#4304; &#4328;&#4308;&#4306;&#4312;&#4331;&#4314;&#4312;&#4304;&#4311; &#4312;&#4321;&#4304;&#4320;&#4306;&#4308;&#4305;&#4314;&#4317;&#4311; &#4315;&#4317;&#4316;&#4304;&#4330;&#4308;&#4315;&#4311;&#4304; &#4305;&#4304;&#4310;&#4308;&#4305;&#4312;&#4311;

&#4312;&#4315;&#4312;&#4321;&#4304;&#4311;&#4309;&#4312;&#4321; &#4320;&#4317;&#4315; &#4321;&#4308;&#4320;&#4309;&#4308;&#4320;&#4310;&#4308; &#4329;&#4304;&#4309;&#4321;&#4309;&#4304;&#4311; &#4312;&#4316;&#4307;&#4308;&#4325;&#4321; &#4324;&#4304;&#4312;&#4314;&#4308;&#4305;&#4312; &#4307;&#4304; &#4329;&#4309;&#4308;&#4316;&#4312; &#4318;&#4320;&#4317;&#4308;&#4325;&#4322;&#4308;&#4305;&#4312; &#4321;&#4304;&#4333;&#4312;&#4320;&#4317;&#4304; &#4304;&#4307;&#4315;&#4312;&#4316;&#4312;&#4321;&#4322;&#4320;&#4304;&#4330;&#4312;&#4323;&#4314;&#4312; &#4323;&#4324;&#4314;&#4308;&#4305;&#4308;&#4305;&#4312;

&#4304;&#4315;&#4312;&#4321;&#4304;&#4311;&#4309;&#4312;&#4321; &#4304;&#4313;&#4320;&#4312;&#4324;&#4308;&#4311;

---------------------------------------- sudo nautilus ----------------------------------------

&#4307;&#4304; &#4306;&#4304;&#4307;&#4304;&#4307;&#4312;&#4311; /var/www/ &#4307;&#4304;&#4321;&#4322;&#4304;&#4328;&#4312; &#4321;&#4304;&#4307;&#4304;&#4330; &#4328;&#4308;&#4306;&#4312;&#4331;&#4314;&#4312;&#4304;&#4311; &#4306;&#4304;&#4316;&#4304;&#4311;&#4304;&#4309;&#4321;&#4317;&#4311; &#4316;&#4308;&#4305;&#4312;&#4321;&#4315;&#4312;&#4308;&#4320;&#4312; &#4324;&#4304;&#4312;&#4314;&#4312;.

da

&#4313;&#4304;&#4320;&#4306;&#4312;&#4304;!

&#4327;&#4309;&#4308;&#4314;&#4304;&#4324;&#4308;&#4320;&#4312; &#4331;&#4304;&#4314;&#4312;&#4304;&#4316; &#4313;&#4304;&#4320;&#4306;&#4304;&#4307;&#4304;&#4304; &#4304;&#4326;&#4332;&#4308;&#4320;&#4312;&#4314;&#4312;, &#4320;&#4312;&#4321;&#4311;&#4309;&#4312;&#4321;&#4304;&#4330; &#4307;&#4312;&#4307;&#4312; &#4315;&#4304;&#4307;&#4314;&#4317;&#4305;&#4304; &#4304;&#4309;&#4322;&#4317;&#4320;&#4321;, &#4311;&#4312;&#4311;&#4325;&#4315;&#4312;&#4321; &#4306;&#4304;&#4309;&#4304;&#4313;&#4308;&#4311;&#4308; &#4313;&#4312;&#4307;&#4308;&#4330;, &#4321;&#4325;&#4314;-&#4312;&#4330; &#4307;&#4304;&#4309;&#4304;&#4327;&#4308;&#4316;&#4308;... &#4311;&#4304;&#4309;&#4312;&#4307;&#4304;&#4316;, &#4320;&#4317;&#4330;&#4304; &#4328;&#4308;&#4309;&#4307;&#4312;&#4309;&#4304;&#4320; &#4309;&#4308;&#4305;&#4315;&#4312;&#4316;&#4328;&#4312;, &#4318;&#4320;&#4317;&#4305;&#4314;&#4308;&#4315;&#4304; &#4304;&#4320;&#4304;&#4304;, &#4312;&#4325; &#4309;&#4312;&#4320;&#4329;&#4308;&#4309; &#4321;&#4308;&#4320;&#4309;&#4308;&#4320;&#4321;-sql-&#4321;, &#4315;&#4304;&#4306;&#4320;&#4304;&#4315; &#4304;&#4320; &#4312;&#4320;&#4311;&#4309;&#4308;&#4305;&#4304; (&#4320;&#4304;&#4315;&#4307;&#4308;&#4316;&#4312;&#4315;&#4308; &#4307;&#4326;&#4312;&#4321; &#4332;&#4312;&#4316; &#4312;&#4320;&#4311;&#4309;&#4308;&#4305;&#4317;&#4307;&#4304;) &#4315;&#4312;&#4332;&#4308;&#4320;&#4321; &#4304;&#4312; &#4304;&#4315;&#4304;&#4321; Click this button to start the MySQL database server on your system with the command /etc/init.d/mysql start >/dev/null 2>&1 &. &#4313;&#4312;&#4307;&#4308;&#4309; &#4312;&#4321; &#4315;&#4304;&#4312;&#4316;&#4322;&#4308;&#4320;&#4308;&#4321;&#4308;&#4305;&#4321;, &#4311;&#4323; &#4320;&#4304; &#4323;&#4316;&#4307;&#4304; &#4309;&#4325;&#4316;&#4304; &#4312;&#4315;&#4312;&#4321;&#4311;&#4309;&#4312;&#4321;, &#4320;&#4317;&#4315; &#4321;&#4334;&#4309;&#4304; &#4313;&#4317;&#4318;&#4312;&#4323;&#4322;&#4308;&#4320;&#4312;&#4307;&#4304;&#4316; &#4309;&#4312;&#4316;&#4315;&#4308;&#4315; &#4306;&#4304;&#4307;&#4315;&#4317;&#4332;&#4308;&#4320;&#4317;&#4321; &#4329;&#4308;&#4315;&#4312; &#4309;&#4308;&#4305;-&#4321;&#4308;&#4320;&#4309;&#4308;&#4320;&#4312;&#4307;&#4304;&#4316; &#4320;&#4304;&#4315;&#4308;. &#4304;&#4316;&#4323;, &#4320;&#4304;&#4330; &#4304;&#4315; &#4321;&#4322;&#4304;&#4322;&#4312;&#4304;&#4328;&#4312;&#4304; &#4304;&#4326;&#4332;&#4308;&#4320;&#4312;&#4314;&#4312; &#4308;&#4321; &#4312;&#4316;&#4324;&#4317;&#4320;&#4315;&#4304;&#4330;&#4312;&#4304; &#4313;&#4315;&#4304;&#4320;&#4304; &#4327;&#4317;&#4309;&#4308;&#4314;&#4312;&#4309;&#4308; &#4304;&#4315;&#4312;&#4321;&#4311;&#4309;&#4312;&#4321;? &#4311;&#4323; &#4313;&#4312;&#4307;&#4308;&#4309;, &#4307;&#4304;&#4315;&#4304;&#4322;&#4308;&#4305;&#4312;&#4311; &#4320;&#4304;&#4312;&#4315;&#4308; &#4323;&#4316;&#4307;&#4304; &#4328;&#4308;&#4309;&#4312;&#4327;&#4309;&#4304;&#4316;&#4317;? bind &#4315;&#4312;&#4321;&#4304;&#4315;&#4304;&#4320;&#4311;&#4321; &#4320;&#4317;&#4315; &#4309;&#4330;&#4309;&#4314;&#4312; 127.0.0.1-&#4321; &#4329;&#4308;&#4315;&#4312; &#4318;&#4312;&#4320;&#4304;&#4307;&#4312; IP-&#4312;&#4311; (192.168.1.37) &#4321;&#4332;&#4317;&#4320;&#4304;&#4307; &#4309;&#4304;&#4313;&#4308;&#4311;&#4308;&#4305;? &#4304;&#4325; &#4304;&#4326;&#4332;&#4308;&#4320;&#4312;&#4314;&#4312; &#4307;&#4304;&#4334;&#4315;&#4304;&#4320;&#4308;&#4305;&#4312;&#4321; &#4315;&#4312;&#4334;&#4308;&#4307;&#4309;&#4312;&#4311; &#4309;&#4312;&#4315;&#4317;&#4325;&#4315;&#4308;&#4307;&#4308;, &#4315;&#4304;&#4306;&#4320;&#4304;&#4315; &#4321;&#4334;&#4309;&#4304; &#4313;&#4317;&#4315;&#4318;&#4312;&#4307;&#4304;&#4316; &#4309;&#4308;&#4320; &#4328;&#4308;&#4309;&#4312;&#4307;&#4316;&#4308;&#4316;. &#4320;&#4312;&#4321;&#4312; &#4305;&#4320;&#4304;&#4314;&#4312;&#4304; &#4308;&#4321;? &#4331;&#4304;&#4314;&#4312;&#4304;&#4316; &#4306;&#4311;&#4334;&#4317;&#4309;&#4311; &#4306;&#4304;&#4315;&#4304;&#4320;&#4313;&#4309;&#4312;&#4317;&#4311; &#4320;&#4304;... :confused: &#4332;&#4312;&#4316;&#4304;&#4321;&#4332;&#4304;&#4320; &#4307;&#4312;&#4307;&#4312; &#4315;&#4304;&#4307;&#4314;&#4317;&#4305;&#4304; &#4306;&#4304;&#4312;&#4311;&#4309;&#4304;&#4314;&#4312;&#4321;&#4332;&#4312;&#4316;&#4308;&#4311;, &#4320;&#4317;&#4315; &#4304;&#4334;&#4304;&#4314;&#4305;&#4308;&#4307;&#4304; &#4309;&#4304;&#4320; &#4309;&#4308;&#4305;-&#4321;&#4308;&#4320;&#4309;&#4308;&#4320;&#4308;&#4305;&#4312;&#4321; &#4328;&#4308;&#4325;&#4315;&#4316;&#4304;-&#4315;&#4304;&#4320;&#4311;&#4309;&#4304;&#4328;&#4312;:)

&#4304;&#4325;, &#4304;&#4320;&#4312;&#4321; &#4309;&#4312;&#4316;&#4315;&#4308;? :confused:

&#4315;&#4317;&#4313;&#4314;&#4308;&#4307; &#4320;&#4304; ip &#4306;&#4304;&#4309;&#4332;&#4308;&#4320;&#4317; &#4307;&#4304; &#4321;&#4304;&#4307;, &#4321;&#4334;&#4309;&#4304; &#4313;&#4317;&#4315;&#4318;&#4312;&#4323;&#4322;&#4308;&#4320;&#4308;&#4305;&#4312;&#4307;&#4304;&#4316; &#4320;&#4317;&#4315; &#4328;&#4308;&#4331;&#4314;&#4317;&#4316; &#4312;&#4316;&#4324;&#4317;&#4320;&#4315;&#4304;&#4330;&#4312;&#4312;&#4321; &#4306;&#4304;&#4307;&#4304;&#4332;&#4308;&#4320;&#4304;, &#4329;&#4308;&#4315;&#4312; &#4309;&#4308;&#4305; &#4321;&#4308;&#4320;&#4309;&#4308;&#4320;&#4312;&#4307;&#4304;&#4316;? &#4332;&#4312;&#4316;&#4304;&#4321;&#4332;&#4304;&#4320; &#4315;&#4307;&#4314;&#4317;&#4305;

joto said: &#4315;&#4317;&#4313;&#4314;&#4308;&#4307; &#4320;&#4304; ip &#4306;&#4304;&#4309;&#4332;&#4308;&#4320;&#4317; &#4307;&#4304; &#4321;&#4304;&#4307;, &#4321;&#4334;&#4309;&#4304; &#4313;&#4317;&#4315;&#4318;&#4312;&#4323;&#4322;&#4308;&#4320;&#4308;&#4305;&#4312;&#4307;&#4304;&#4316; &#4320;&#4317;&#4315; &#4328;&#4308;&#4331;&#4314;&#4317;&#4316; &#4312;&#4316;&#4324;&#4317;&#4320;&#4315;&#4304;&#4330;&#4312;&#4312;&#4321; &#4306;&#4304;&#4307;&#4304;&#4332;&#4308;&#4320;&#4304;, &#4329;&#4308;&#4315;&#4312; &#4309;&#4308;&#4305; &#4321;&#4308;&#4320;&#4309;&#4308;&#4320;&#4312;&#4307;&#4304;&#4316;?

&#4332;&#4312;&#4316;&#4304;&#4321;&#4332;&#4304;&#4320; &#4315;&#4307;&#4314;&#4317;&#4305;

&#4321;&#4304;&#4315;&#4332;&#4323;&#4334;&#4304;&#4320;&#4317;&#4307; &#4312;&#4316;&#4322;&#4308;&#4320;&#4316;&#4308;&#4322;&#4312; &#4304;&#4320; &#4315;&#4325;&#4317;&#4316;&#4307;&#4304; 2 &#4311;&#4309;&#4308;!

&#4308;&#4321;&#4308;&#4312;&#4306;&#4312;, &#4321;&#4304;&#4333;&#4312;&#4320;&#4317;&#4304; no-ip.org -&#4310;&#4308; &#4320;&#4308;&#4306;&#4312;&#4321;&#4322;&#4320;&#4304;&#4330;&#4312;&#4304;. &#4307;&#4304; no-ip &#4307;&#4308;&#4315;&#4317;&#4316;&#4312;&#4321; &#4307;&#4304;&#4327;&#4308;&#4316;&#4308;&#4305;&#4304;.

&#4304;&#4306;&#4308;&#4320; &#4304;&#4334;&#4321;&#4316;&#4312;&#4314;&#4312;&#4304; &#4327;&#4309;&#4308;&#4314;&#4304;&#4324;&#4308;&#4320;&#4312;!

http://ubuntulinuxhowto.blogspot.com/2006/06/dynamic-dns-no-ip.html

&#4312;&#4315;&#4308;&#4307;&#4312;&#4304; &#4306;&#4304;&#4315;&#4317;&#4306;&#4304;&#4307;&#4306;&#4308;&#4305;&#4304;! :KS

alinux said: &#4321;&#4304;&#4315;&#4332;&#4323;&#4334;&#4304;&#4320;&#4317;&#4307; &#4312;&#4316;&#4322;&#4308;&#4320;&#4316;&#4308;&#4322;&#4312; &#4304;&#4320; &#4315;&#4325;&#4317;&#4316;&#4307;&#4304; 2 &#4311;&#4309;&#4308;!

&#4308;&#4321;&#4308;&#4312;&#4306;&#4312;, &#4321;&#4304;&#4333;&#4312;&#4320;&#4317;&#4304; no-ip.org -&#4310;&#4308; &#4320;&#4308;&#4306;&#4312;&#4321;&#4322;&#4320;&#4304;&#4330;&#4312;&#4304;. &#4307;&#4304; no-ip &#4307;&#4308;&#4315;&#4317;&#4316;&#4312;&#4321; &#4307;&#4304;&#4327;&#4308;&#4316;&#4308;&#4305;&#4304;.

&#4304;&#4306;&#4308;&#4320; &#4304;&#4334;&#4321;&#4316;&#4312;&#4314;&#4312;&#4304; &#4327;&#4309;&#4308;&#4314;&#4304;&#4324;&#4308;&#4320;&#4312;!

http://ubuntulinuxhowto.blogspot.com/2006/06/dynamic-dns-no-ip.html

&#4312;&#4315;&#4308;&#4307;&#4312;&#4304; &#4306;&#4304;&#4315;&#4317;&#4306;&#4304;&#4307;&#4306;&#4308;&#4305;&#4304;! :KS

&#4315;&#4304;&#4307;&#4314;&#4317;&#4305; &#4314;&#4304;&#4307;&#4317;, &#4306;&#4304;&#4315;&#4317;&#4334;&#4315;&#4304;&#4323;&#4320;&#4308;&#4305;&#4312;&#4321;&#4311;&#4309;&#4312;&#4321;! &#4309;&#4308;&#4333;&#4309;&#4317;&#4305;, &#4320;&#4317;&#4315; &#4310;&#4323;&#4321;&#4322;&#4304;&#4307; &#4309;&#4308;&#4320; &#4306;&#4304;&#4315;&#4312;&#4306;&#4308;, &#4320;&#4304; &#4315;&#4312;&#4316;&#4307;&#4304;, &#4304;&#4316; &#4315;&#4308; &#4309;&#4308;&#4320; &#4309;&#4334;&#4309;&#4307;&#4308;&#4305;&#4312;:) &#4315;&#4317;&#4313;&#4314;&#4308;&#4307;, &#4304;&#4312;, &#4330;&#4312;&#4322;&#4304;&#4322;&#4304;, &#4320;&#4304;&#4330; &#4304;&#4315; &#4311;&#4308;&#4315;&#4304;&#4328;&#4312;&#4304; &#4315;&#4317;&#4327;&#4309;&#4304;&#4316;&#4312;&#4314;&#4312;:

1. (&#4328;&#4308;&#4320;&#4329;&#4308;&#4309;&#4312;&#4311;)&#4312;&#4315;&#4312;&#4321;&#4304;&#4311;&#4309;&#4312;&#4321; &#4320;&#4317;&#4315; &#4321;&#4334;&#4309;&#4304; &#4313;&#4317;&#4315;&#4318;&#4312;&#4323;&#4322;&#4308;&#4320;&#4308;&#4305;&#4315;&#4304; &#4328;&#4308;&#4331;&#4314;&#4317;&#4316; &#4315;&#4323;&#4328;&#4304;&#4317;&#4305;&#4304; &#4311;&#4325;&#4309;&#4308;&#4316;&#4321; &#4315;&#4317;&#4316;&#4304;&#4330;&#4308;&#4315;&#4311;&#4304; &#4305;&#4304;&#4310;&#4308;&#4305;&#4311;&#4304;&#4316;, &#4323;&#4316;&#4307;&#4304; &#4328;&#4308;&#4330;&#4309;&#4304;&#4314;&#4317;&#4311; "Bind Address". &#4304;&#4315;&#4312;&#4321;&#4304;&#4311;&#4309;&#4312;&#4321; &#4322;&#4308;&#4320;&#4315;&#4312;&#4316;&#4304;&#4314;&#4328;&#4312; &#4304;&#4313;&#4320;&#4312;&#4324;&#4308;&#4311; &#4305;&#4320;&#4331;&#4304;&#4316;&#4308;&#4305;&#4304;

---------------------------------------------------

gksudo gedit /etc/mysql/my.cnf

---------------------------------------------------

&#4328;&#4308;&#4330;&#4309;&#4304;&#4314;&#4308;&#4311; &#4321;&#4322;&#4320;&#4312;&#4325;&#4317;&#4316;&#4312;

------------------------------------------

bind-address = 127.0.0.1

------------------------------------------

&#4307;&#4304; &#4328;&#4308;&#4330;&#4309;&#4304;&#4314;&#4308;&#4311; 127.0.0.1 &#4311;&#4325;&#4309;&#4308;&#4316;&#4312; &#4315;&#4312;&#4321;&#4304;&#4315;&#4304;&#4320;&#4311;&#4312;&#4311;.

&#4304;&#4316;&#4323;, &#4328;&#4308;&#4309;&#4307;&#4312;&#4309;&#4304;&#4320; &#4310;&#4308;&#4315;&#4317;&#4334;&#4321;&#4308;&#4316;&#4308;&#4305;&#4323;&#4314; my.cnf &#4324;&#4304;&#4312;&#4314;&#4328;&#4312;, &#4309;&#4316;&#4304;&#4334;&#4323;&#4314;&#4317;&#4305; bind adress = 127.0.0.1 &#4321;&#4322;&#4320;&#4312;&#4325;&#4317;&#4316;&#4321; &#4307;&#4304; &#4315;&#4308;&#4320;&#4308; &#4309;&#4312;&#4333;&#4308;&#4307;&#4308;&#4305;&#4312;:( &#4304;&#4316;&#4323;, &#4304;&#4320; &#4309;&#4312;&#4330;&#4312; 127.0.0.1-&#4312;&#4321; &#4315;&#4304;&#4306;&#4312;&#4309;&#4320;&#4304;&#4307; &#4320;&#4304; &#4328;&#4308;&#4309;&#4312;&#4327;&#4309;&#4304;&#4316;&#4317; :confused: &#4328;&#4308;&#4330;&#4309;&#4304;&#4314;&#4308;&#4311; &#4311;&#4325;&#4309;&#4308;&#4316;&#4312;&#4311;&#4317;, &#4332;&#4308;&#4320;&#4312;&#4304;... &#4309;&#4308;&#4320; &#4309;&#4334;&#4309;&#4307;&#4308;&#4305;&#4312;, &#4320;&#4304; &#4329;&#4304;&#4309;&#4323;&#4332;&#4308;&#4320;&#4317;? &#4307;&#4312;&#4307;&#4312; &#4315;&#4304;&#4307;&#4314;&#4317;&#4305;&#4308;&#4314;&#4312; &#4309;&#4312;&#4325;&#4316;&#4308;&#4305;&#4312;, &#4311;&#4323; &#4307;&#4304;&#4315;&#4304;&#4313;&#4309;&#4304;&#4314;&#4312;&#4304;&#4316;&#4308;&#4305;:)

&#4315;&#4308;&#4330; &#4309;&#4308;&#4320; &#4315;&#4312;&#4309;&#4334;&#4309;&#4307;&#4312;... &#4328;&#4312;&#4307;&#4304; &#4325;&#4321;&#4308;&#4314;&#4312;&#4321; &#4315;&#4312;&#4321;&#4304;&#4315;&#4304;&#4320;&#4311;&#4310;&#4308;&#4304; &#4321;&#4304;&#4323;&#4305;&#4304;&#4320;&#4312; &#4311;&#4323; &#4306;&#4304;&#4320;&#4308; &#4315;&#4312;&#4321;&#4304;&#4315;&#4304;&#4320;&#4311;&#4310;&#4308;...

&#4315;&#4304;&#4306;&#4304;&#4314;&#4312;&#4311;&#4304;&#4307; &#4328;&#4308;&#4316;&#4312; &#4306;&#4304;&#4320;&#4308; &#4315;&#4312;&#4321;&#4304;&#4315;&#4304;&#4320;&#4311;&#4312;&#4321; &#4306;&#4304;&#4306;&#4308;&#4305;&#4304; &#4311;&#4323; &#4306;&#4312;&#4316;&#4307;&#4304;... &#4323;&#4316;&#4307;&#4304; &#4328;&#4308;&#4334;&#4309;&#4312;&#4307;&#4304; &#4321;&#4304;&#4312;&#4311;&#4310;&#4308;: http://whatismyip.org/

&#4321;&#4330;&#4304;&#4307;&#4308; &#4308;&#4321; &#4312;&#4318;&#4312; &#4328;&#4308;&#4312;&#4327;&#4309;&#4304;&#4316;&#4317;... &#4311;&#4323; &#4304;&#4320; &#4306;&#4304;&#4315;&#4317;&#4309;&#4312;&#4307;&#4304; &#4315;&#4304;&#4328;&#4312;&#4316; &#4311;&#4309;&#4312;&#4311; &#4307;&#4304;&#4309;&#4311;&#4321; &#4315;&#4312;&#4315;&#4304;&#4320;&#4311;&#4308;! :KS

&#4315;&#4317;&#4313;&#4314;&#4308;&#4307; &#4320;&#4317;&#4315; &#4309;&#4311;&#4309;&#4304;, Lamp &#4307;&#4304;&#4309;&#4304;&#4327;&#4308;&#4316;&#4308;, &#4308;&#4334;&#4314;&#4304; &#4315;&#4312;&#4316;&#4307;&#4304;, &#4320;&#4317;&#4315; &#4329;&#4308;&#4315;&#4321; &#4321;&#4308;&#4320;&#4309;&#4308;&#4320;&#4310;&#4308; &#4329;&#4304;&#4306;&#4307;&#4308;&#4305;&#4323;&#4314;&#4312; &#4324;&#4304;&#4312;&#4314;&#4308;&#4305;&#4312; &#4306;&#4304;&#4307;&#4304;&#4332;&#4308;&#4320;&#4317;&#4321; &#4321;&#4334;&#4309;&#4304;&#4315;&#4304;&#4330;, &#4320;&#4317;&#4306;&#4317;&#4320; &#4315;&#4317;&#4309;&#4312;&#4325;&#4330;&#4308;?:) &#4314;&#4304;&#4307;&#4317;, &#4307;&#4304;&#4309;&#4312;&#4311;&#4321; &#4320;&#4317;&#4306;&#4317;&#4320; &#4315;&#4312;&#4309;&#4315;&#4304;&#4320;&#4311;&#4317;? &#4304;&#4312;, &#4321;&#4323;&#4320;&#4304;&#4311;&#4312;, &#4321;&#4304;&#4307;&#4304;&#4330; &#4329;&#4304;&#4316;&#4321;, &#4329;&#4308;&#4315;&#4312; &#4309;&#4308;&#4305; &#4321;&#4308;&#4320;&#4309;&#4308;&#4320;&#4312;&#4321; &#4306;&#4309;&#4308;&#4320;&#4307;&#4312;. &#4304;&#4316;&#4323;, &#4321;&#4334;&#4309;&#4304; &#4304;&#4315; &#4306;&#4309;&#4308;&#4320;&#4307;&#4321; &#4309;&#4308;&#4320; &#4316;&#4304;&#4334;&#4323;&#4314;&#4317;&#4305;&#4321; &#4307;&#4304; &#4308;&#4306; &#4309;&#4308;&#4320; &#4306;&#4304;&#4309;&#4312;&#4306;&#4308;, &#4320;&#4304;&#4322;&#4317;&#4315;:(((

joto said: &#4315;&#4317;&#4313;&#4314;&#4308;&#4307; &#4320;&#4317;&#4315; &#4309;&#4311;&#4309;&#4304;, Lamp &#4307;&#4304;&#4309;&#4304;&#4327;&#4308;&#4316;&#4308;, &#4308;&#4334;&#4314;&#4304; &#4315;&#4312;&#4316;&#4307;&#4304;, &#4320;&#4317;&#4315; &#4329;&#4308;&#4315;&#4321; &#4321;&#4308;&#4320;&#4309;&#4308;&#4320;&#4310;&#4308; &#4329;&#4304;&#4306;&#4307;&#4308;&#4305;&#4323;&#4314;&#4312; &#4324;&#4304;&#4312;&#4314;&#4308;&#4305;&#4312; &#4306;&#4304;&#4307;&#4304;&#4332;&#4308;&#4320;&#4317;&#4321; &#4321;&#4334;&#4309;&#4304;&#4315;&#4304;&#4330;, &#4320;&#4317;&#4306;&#4317;&#4320; &#4315;&#4317;&#4309;&#4312;&#4325;&#4330;&#4308;?:)

&#4314;&#4304;&#4307;&#4317;, &#4307;&#4304;&#4309;&#4312;&#4311;&#4321; &#4320;&#4317;&#4306;&#4317;&#4320; &#4315;&#4312;&#4309;&#4315;&#4304;&#4320;&#4311;&#4317;? &#4304;&#4312;, &#4321;&#4323;&#4320;&#4304;&#4311;&#4312;, &#4321;&#4304;&#4307;&#4304;&#4330; &#4329;&#4304;&#4316;&#4321;, &#4329;&#4308;&#4315;&#4312; &#4309;&#4308;&#4305; &#4321;&#4308;&#4320;&#4309;&#4308;&#4320;&#4312;&#4321; &#4306;&#4309;&#4308;&#4320;&#4307;&#4312;. &#4304;&#4316;&#4323;, &#4321;&#4334;&#4309;&#4304; &#4304;&#4315; &#4306;&#4309;&#4308;&#4320;&#4307;&#4321; &#4309;&#4308;&#4320; &#4316;&#4304;&#4334;&#4323;&#4314;&#4317;&#4305;&#4321; &#4307;&#4304; &#4308;&#4306; &#4309;&#4308;&#4320; &#4306;&#4304;&#4309;&#4312;&#4306;&#4308;, &#4320;&#4304;&#4322;&#4317;&#4315;:(((

&#4328;&#4308;&#4316;&#4321; &#4306;&#4309;&#4308;&#4320;&#4307;&#4321; &#4316;&#4304;&#4334;&#4304;&#4309;&#4308;&#4316; &#4311;&#4323; &#4306;&#4304;&#4320;&#4308; &#4312;&#4318;-&#4312;&#4321; &#4308;&#4322;&#4327;&#4309;&#4312; &#4328;&#4308;&#4316;&#4321; &#4334;&#4304;&#4334;&#4314;&#4321;. &#4311;&#4323; &#4307;&#4312;&#4316;&#4304;&#4315;&#4312;&#4323;&#4320;&#4312; IP &#4306;&#4304;&#4325;&#4309;&#4321; &#4307;&#4304; &#4321;&#4322;&#4304;&#4322;&#4312;&#4313;&#4323;&#4320;&#4312; &#4306;&#4312;&#4316;&#4307;&#4304; &#4306;&#4304;&#4334;&#4304;&#4307;&#4317; &#4315;&#4304;&#4328;&#4312;&#4316;: http://ubuntulinuxhowto.blogspot.com/2006/06/dynamic-dns-no-ip.html &#4308;&#4321; &#4315;&#4317;&#4306;&#4308;&#4328;&#4309;&#4308;&#4314;&#4308;&#4305;&#4304;! :KS

alinux said: &#4328;&#4308;&#4316;&#4321; &#4306;&#4309;&#4308;&#4320;&#4307;&#4321; &#4316;&#4304;&#4334;&#4304;&#4309;&#4308;&#4316; &#4311;&#4323; &#4306;&#4304;&#4320;&#4308; &#4312;&#4318;-&#4312;&#4321; &#4308;&#4322;&#4327;&#4309;&#4312; &#4328;&#4308;&#4316;&#4321; &#4334;&#4304;&#4334;&#4314;&#4321;. &#4311;&#4323; &#4307;&#4312;&#4316;&#4304;&#4315;&#4312;&#4323;&#4320;&#4312; IP &#4306;&#4304;&#4325;&#4309;&#4321; &#4307;&#4304; &#4321;&#4322;&#4304;&#4322;&#4312;&#4313;&#4323;&#4320;&#4312; &#4306;&#4312;&#4316;&#4307;&#4304; &#4306;&#4304;&#4334;&#4304;&#4307;&#4317; &#4315;&#4304;&#4328;&#4312;&#4316;:

http://ubuntulinuxhowto.blogspot.com/2006/06/dynamic-dns-no-ip.html &#4308;&#4321; &#4315;&#4317;&#4306;&#4308;&#4328;&#4309;&#4308;&#4314;&#4308;&#4305;&#4304;! :KS &#4329;&#4308;&#4315;&#4312; IP &#4304;&#4320;&#4312;&#4321; 85.114.248.105 &#4304;&#4316;&#4323; &#4322;&#4308;&#4314;&#4316;&#4308;&#4322;&#4312;&#4311; &#4320;&#4317;&#4315; &#4328;&#4308;&#4309;&#4307;&#4312;&#4309;&#4304;&#4320; &#4329;&#4308;&#4315;&#4321; &#4320;&#4317;&#4323;&#4322;&#4308;&#4320;&#4328;&#4312; (&#4315;&#4317;&#4307;&#4308;&#4315;&#4328;&#4312;) &#4312;&#4325; &#4304;&#4315;&#4304;&#4321; &#4315;&#4312;&#4329;&#4309;&#4308;&#4316;&#4308;&#4305;&#4321;. &#4328;&#4308;&#4316; &#4320;&#4304; &#4321;&#4304;&#4312;&#4322;&#4312;&#4321; &#4322;&#4323;&#4322;&#4317;&#4320;&#4312;&#4304;&#4314;&#4312;&#4330; &#4315;&#4317;&#4315;&#4308;&#4330;&#4312;, &#4315;&#4312;&#4309;&#4327;&#4308;&#4309;&#4312;, &#4306;&#4304;&#4309;&#4304;&#4313;&#4308;&#4311;&#4308; &#4305;&#4317;&#4314;&#4317;&#4315;&#4307;&#4308;, &#4315;&#4304;&#4306;&#4320;&#4304;&#4315; &#4328;&#4308;&#4307;&#4308;&#4306;&#4312; &#4309;&#4308;&#4320; &#4315;&#4312;&#4309;&#4312;&#4326;&#4308;. &#4304;&#4316;&#4323; &#4304;&#4315; IP-&#4320;&#4317;&#4315; &#4309;&#4313;&#4320;&#4308;&#4324; &#4305;&#4320;&#4304;&#4323;&#4321;&#4308;&#4320;&#4328;&#4312;, &#4306;&#4304;&#4307;&#4304;&#4309;&#4307;&#4312;&#4309;&#4304;&#4320; &#4329;&#4308;&#4315;&#4312; ZyXEL-&#4312;&#4321; &#4324;&#4312;&#4320;&#4315;&#4312;&#4321; &#4315;&#4317;&#4307;&#4308;&#4315;&#4312;&#4321; &#4311;&#4323; &#4320;&#4317;&#4323;&#4322;&#4308;&#4320;&#4312;&#4321; &#4318;&#4304;&#4320;&#4304;&#4315;&#4308;&#4322;&#4320;&#4308;&#4305;&#4328;&#4312; :confused: &#4312;&#4325; &#4307;&#4304;&#4309;&#4320;&#4308;&#4306;&#4312;&#4321;&#4322;&#4320;&#4312;&#4320;&#4307;&#4312; &#4328;&#4308;&#4316; &#4320;&#4304; &#4321;&#4304;&#4312;&#4322;&#4312;&#4330; &#4315;&#4317;&#4315;&#4308;&#4330;&#4312; &#4307;&#4304; &#4308;&#4321;&#4308;&#4311;&#4312; &#4336;&#4317;&#4321;&#4322;&#4312; &#4315;&#4312;&#4309;&#4312;&#4326;&#4308;: http://joto.no-ip.org &#4304;&#4315; &#4315;&#4312;&#4321;&#4304;&#4315;&#4304;&#4320;&#4311;&#4312;&#4321; &#4304;&#4313;&#4320;&#4308;&#4324;&#4312;&#4321; &#4328;&#4308;&#4315;&#4307;&#4308;&#4306;&#4304;&#4330;, &#4306;&#4304;&#4307;&#4304;&#4309;&#4307;&#4312;&#4309;&#4304;&#4320; &#4329;&#4308;&#4315;&#4321; &#4315;&#4317;&#4307;&#4308;&#4315;&#4328;&#4312;, &#4304;&#4316;&#4323; &#4329;&#4315;&#4308;&#4321; &#4309;&#4308;&#4305; &#4321;&#4308;&#4320;&#4309;&#4308;&#4320;&#4321; &#4304;&#4315; IP-&#4310;&#4308; &#4309;&#4308;&#4320; &#4309;&#4321;&#4309;&#4304;&#4315;. &#4312;&#4325;&#4316;&#4308;&#4305; &#4318;&#4320;&#4317;&#4309;&#4304;&#4312;&#4307;&#4308;&#4320;&#4321; &#4315;&#4312;&#4309;&#4315;&#4304;&#4320;&#4311;&#4317;? &#4312;&#4314;&#4323;&#4321;&#4322;&#4320;&#4304;&#4330;&#4312;&#4312;&#4321;&#4311;&#4309;&#4312;&#4321; &#4321;&#4323;&#4320;&#4304;&#4311;&#4308;&#4305;&#4321;&#4304;&#4330; &#4307;&#4304;&#4309;&#4307;&#4308;&#4305;... &#4320;&#4304;&#4326;&#4304;&#4330; &#4323;&#4304;&#4310;&#4320;&#4317;&#4305;&#4304; &#4306;&#4304;&#4315;&#4317;&#4307;&#4312;&#4321; &#4320;&#4304;:(