HowTo: Sabis ɗin FTP ta amfani da bayanan MySQL

Duk da wasu rashin tabbas da zasu iya kewaye MySQL, da kaina har yanzu na fi son aiki tare da wannan DB ɗin don amfani da wani. Ba ni da wani abu game da Postgre, kawai na yi amfani da MySQL ne har tsawon rayuwa, kuma har yanzu ba ni da dalilin sake yin tunanin amfani da shi.

A wannan karon zan koya muku yadda ake girka sabar FTP, amma ba haka kawai ba, zan koya muku ba ta hanya mai rikitarwa ba, yadda ake sanya masu amfani, kalmomin shiga da sauran bayanan mai amfani a cikin bayanan MySQL, kuma ba a cikin asusun ba na gida.

Me yasa haka?

Mai sauƙi, saboda lokacin yin ajiyar ajiya, sake shigar da sabar ko wani babban canji, matsar da sabis ɗin zai zama mai sauƙi kamar kwafin fayil ɗin daidaitawa, da fitar da bayanan MySQL zuwa FTP.

Don cimma wannan zamu yi amfani da shi Zalla-FTPd, da kyau ... bari mu fara 🙂

Shigar da sabis na FTP tare da Pure-FTPd

1. Abu na farko da za ayi shine shigar da kunshin: tsarkakakke-ftpd-mysql

A cikin diski kamar Debian ko Kalam: ƙwarewa shigar da tsabta-ftpd-mysql

2. Da zarar an girka, mun fara sabis ɗin amma dole ne mu dakatar da shi, don dakatar da shi a kan tsarin abubuwa kamar Debian ko abubuwan da suka samo asali ya isa tare da:

/etc/init.d/pure-ftpd-mysql stop

Koyaya, Na bar muku layin da zai dakatar da sabis ɗin ba tare da la'akari da ɓatar da kuke amfani da ita ba:

ps ax | grep pure | grep -v grep | awk '{print $1}' | xargs kill

Idan kanaso ka fahimci wannan layin daki-daki, ka karanta Wannan labarin

Ana shirya yanayi akan sabar MySQL

Na riga na yi bayani ba da daɗewa ba yadda za a ƙirƙiri rumbun adana bayanai, mai amfani da ba wa izinin mai amfani a cikin bayanan: Masu amfani da izini a cikin MySQL

Bari mu matsa kan me za mu yi anan? ...

1. Za mu ƙirƙiri bayanan bayanan Ee, amma da farko mun sami damar MySQL:

mysql -u root -p

Anan suka sanya asalin kalmar sirri kuma zasu sami damar zuwa tashar MySQL.

2. Da zarar mun shiga MySQL zamu ci gaba da ƙirƙirar bayanan myftpdb:

CREATE DATABASE myftpdb;

Lura da semicolon «;»A ƙarshen layin.

3. Yanzu zamu kirkiro mai amfani marwann kuma za mu ba da izini don amfani da mai amfani a kan rumbun adana bayanan da muka ƙirƙira, wannan mai amfani zai sami kalmar sirri kalma mai ma'ana:

CREATE USER 'myftpuser'@'localhost' IDENTIFIED BY 'myftppassword';
GRANT ALL PRIVILEGES ON myftpdb.* TO 'myftpuser'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES ;

4. Shirya, mun ƙirƙiri tushen bayanan, mai amfani kuma mun saita izinin. Yanzu dole ne mu shigo da tsoffin bayanan (ko tsafta) don wannan ya cika. Don yin wannan, bari mu fara fita daga MySQL:

exit;

Yanzu bari mu zazzage tushen bayanan da na ba ku:

Zazzage DB ta tsohuwa

Ko a kan sabar amfani da layi mai zuwa:

wget http://ftp.desdelinux.net/myftpdb.sql

Shirya, dama muna da shi akan sabarmu, yanzu kawai ya rage don shigo da bayananku:

mysql -u root -p myftpdb < myftpdb.sql

Kuma a shirye!

Hakanan zasu iya amfani da wasu aikace-aikacen yanar gizo kamar Mai Gudanarwa o PHPMyAdmin don shigo da bayanan, na bar shi ya dandana.

5. Kuma wannan shine duk abin da za a shirya na MySQL ɗinmu a shirye.

Haɗa FTP tare da MySQL

Da kyau, mun riga mun sanya sabis na FTP, an shigar da sabis na MySQL kuma tare da saitin bayanan mu ... yanzu kawai muna buƙatar, shiga sabis na FTP tare da MySQL.

1. Da farko dole ne mu zazzage fayil ɗin sanyi wanda za mu yi amfani da shi don abubuwan da aka ambata. A cikin tashar sabar bari mu sanya layi mai zuwa:

cd /etc/pure-ftpd/ && wget http://ftp.desdelinux.net/pure-ftpd-mysql.conf

2. Yanzu mun fara sabis ɗin FTP muna faɗin shi don amfani dashi don tabbatar da masu amfani da MySQL, kuma za mu kuma nuna wane fayil ɗin daidaitawa don amfani da shi don haɗawa zuwa MySQL:

pure-ftpd-mysql -l mysql:/etc/pure-ftpd/pure-ftpd-mysql.conf

Kuma voila 😀

Wannan ya isa shigar da namu FTP uwar garken ingantacce tare da MySQL database.

Idan kana so cewa duk lokacin da sabar ta fara ta atomatik tana farawa da sabis na FTP, dole ne ka sanya cikin fayil ɗin /etc/rc.local layin da muke amfani dashi don aiwatar da FTP, ma'ana, mun saka /etc/rc.local wannan:

pure-ftpd-mysql -l mysql:/etc/pure-ftpd/pure-ftpd-mysql.conf

Af, zaku iya samun damar FTP ta amfani da duk wani burauzar, da kuma abokan FTP kamar Filezilla ... kuma ba haka kawai ba, ta amfani da masu binciken fayil kamar Nautilus, Dolphin ko PCManFM kuma zaku iya zazzagewa da loda fayiloli 😀

Gwajin mai amfani wanda ke cikin bayanan

Usuario: testuser

Kalmar wucewa: kalmar wucewa

Yadda ake sarrafa masu amfani da FTP?

Da kyau, la'akari da cewa shi tarin bayanan MySQL ne, kamar yadda na fada a sama ... amfani da PHPMyAdmin ko Adminer zai wadatar. Kawai yi amfani da aikace-aikacen da kuka fi so don sarrafa bayanan, wanda ya ƙunshi tebur ɗaya: users ... kuma a ciki akwai masu amfani, anan ga hoton hoto:

Idan kuna son ƙirƙirar sabon mai amfani, zaku iya yin kwafi ko kuma haɗa layin da ake ciki kuma ku canza bayanan da zai banbanta tsakanin masu amfani da su, anan na nuna muku hoto:

Da kyau ... babu wani abu da za a ƙara 🙂

Ina fatan wannan yana da amfani a gare ku kuma ku sani, duk wata tambaya ko shawarwari ku sanar da ni.

gaisuwa

PD: A cikin wannan darasin muna amfani da kalmomin shiga da aka adana a cikin matattarar bayanai, idan kuna son ƙarin tsaro ina ba ku shawarar gwada md5 😉


28 comments, bar naka

Bar tsokaci

Your email address ba za a buga. Bukata filayen suna alama da *

*

*

  1. Wanda ke da alhakin bayanan: Miguel Ángel Gatón
  2. Manufar bayanan: Sarrafa SPAM, sarrafa sharhi.
  3. Halacci: Yarda da yarda
  4. Sadarwar bayanan: Ba za a sanar da wasu bayanan ga wasu kamfanoni ba sai ta hanyar wajibcin doka.
  5. Ajiye bayanai: Bayanin yanar gizo wanda Occentus Networks (EU) suka dauki nauyi
  6. Hakkoki: A kowane lokaci zaka iyakance, dawo da share bayanan ka.

  1.   LiGNUxer m

    KYAU KYAU !!! Makonni biyu da suka gabata na girka wannan amma tare da vsftpd kuma ban gamsu ba don haka zan gwada wannan don ganin yadda yake. na gode

    1.    KZKG ^ Gaara m

      Godiya aboki.
      vsftpd Bana tuna yaushe ne karo na karshe da nayi amfani dashi ... 'yan shekarun da suka gabata, ... idan na taba amfani dashi HAHA. A halin yanzu tare da PureFTPd Ina cikin farin ciki 😀

  2.   dace m

    Kyakkyawan taimako!

    1.    KZKG ^ Gaara m

      Na gode kwatancen 😀
      Kuna yin abin da za ku iya lol….

  3.   Computer Guardian m

    Uuumm, mai ban sha'awa ... wuce ni IP ɗin DB ɗin da nake so in sami tarin masu amfani da kalmomin shiga a hannu 😉

    Kar ka zama sharri, mutum

    1.    KZKG ^ Gaara m

      Ban gane hehehe… menene IP da DB kuke magana akai?
      Idan kana nufin cewa wannan bayanan da na sanya a cikin koyarwar shima zai iya kasancewa akan sabar, ee a can kana da gaskiya ... suna cikin sabis na FTP akan PC mai kwakwalwa akan kwamfutar tafi-da-gidanka, yana da KYAUTA mai kyau Tacewar zaɓi (iptables) don haka… HAHAHAHAHA tabbas kar ku zama mugaye LOL !!!

  4.   Computer Guardian m

    Joroña menene joroña…. Zai zama mai rikitarwa fiye da yadda ake ganin zai iya amfani da wasu yanayin rauni da kama bayanan 😉

  5.   Algave m

    Abin sha'awa sosai !! 🙂

    1.    KZKG ^ Gaara m

      Na gode
      Wannan shine abin da nake kokarin bambance mu da sauran shafukan ... da muke kokarin sanyawa ba labarai sosai ba amma a matsayin kayan fasaha 😀

  6.   giskar m

    Yaya azumin wannan idan aka kwatanta da Samba? (cibiyar sadarwar gida kawai)

    1.    LiGNUxer m

      cewa samba da ftp abubuwa 2 ne daban, ftp yarjejeniya ce mai mahimmanci kuma smb kawai don sauƙaƙa raba tsakanin nasara da Linux.
      Idan kuna neman aiki akan hanyar sadarwar, yi amfani da sabis ɗin FTP, in ba haka ba amfani da samba kawai ba tare da matsala ba

      1.    KZKG ^ Gaara m

        Daidai.
        A ce FTP ta fi Samba damuwa, aƙalla a ganina hakan ne.

        Ban yi wata alama ba ko kaɗan, amma wataƙila FTP tana da ɗan sauri.

        1.    giskar m

          Na gode. Ina amfani da Samba ta yadda daga Wii Console dina (ta amfani da wiimc) zan iya kallon fina-finai da jerin da na zazzage zuwa kwamfutata. Amma wiimc kuma iya haɗawa zuwa uwar garken ftp. Na yi amfani da Samba saboda shine mafi sauki, amma koyaushe nakan kasance da sha'awa idan zaiyi sauri da ftp. Dole ne in gwada.

          1.    KZKG ^ Gaara m

            Hakanan, kuna iya kawai hawa Dutsen Apache akan PC ɗinku, don haka Wii zai haɗu, dole ne ya fi samba sauri ... kuma yafi sauƙin daidaitawa fiye da FTP 😀

          2.    giskar m

            Wiimc (Wii Media Player) kawai yana karɓar haɗin Samba da FTP ne kawai.

  7.   Max Karfe m

    Madalla. Kuna buƙatar wani abu ga waɗannan nau'ikan labaran (da shafin gabaɗaya) don yin komai cikakke; samfurin CSS don samun damar buga labaran zuwa PDF ko a takarda.

  8.   LiGNUxer m

    Ban sani ba ko zai zama nawa, amma babban matsalar wannan shine masu amfani zasu iya ratsa dukkan kundin adireshi koda kuwa zan basu takamaiman kundin adireshi kamar "/ var / www / user_site" idan sun haɗu ta hanyar ftp su sami damar zuwa ko'ina daga pc ¬¬ na
    wannan bashi da aminci sosai haha

  9.   LiGNUxer m

    GASHI NAN!!!
    Don hana masu amfani da muke ƙirƙirar su damar iya kewayawa ta cikin dukkan tsarinmu, dole ne mu ƙara sigar "-A" lokacin ƙaddamar da tsarkakakken ...

    Don haka abin da muke ƙarawa zuwa /etc/rc.local da kuka sanya a cikin koyawa shine wannan
    tsarkakakke-ftpd-mysql -l mysql: /etc/pure-ftpd/pure-ftpd-mysql.conf

    kuma dole ne ku maye gurbin shi da wannan:
    tsarkakakke-ftpd-mysql -A -l mysql: /etc/pure-ftpd/pure-ftpd-mysql.conf

    Shin an yaba da shi? ... Wannan sabon layin yana ɗauke da -Na'idar da za ta ƙayyade kundin adireshin da kawai muka ba shi kuma ba wani abu ba, zai iya ƙirƙira amma ba zai iya daidaitawa ba.

    D: wannan kyakkyawa mai tsabta-fptd

    1.    KZKG ^ Gaara m

      Godiya ga tip 😀

  10.   Roberto m

    Barka dai, yana yiwuwa a aiwatar da adadin a cikin wannan aiwatar da MySQL da FTP, a halin yanzu ina da sabin ftp tare da vsftpd kuma ba ni da matsala game da adadin, amma kasancewar ni mai amfani ne (wanda aka kirkira a cikin MySQL) shin adadin zai yi daidai? na biyu kuma shine inda aka adana fayilolin da masu amfani suka ɗora, ma'ana, waɗanda sune kundin adireshin kowane mai amfani.

    1.    KZKG ^ Gaara m

      A ka'idar zaku iya aiwatar da adadin, a zahiri bayanan bayanan suna da filayen da aka kirkiresu, kuma fayil ɗin sanyi na sabis na FTP yana da tambayoyin da aka saita don wannan, wanda a zahiri ban gwada wannan ba 😉

      Game da inda masu amfani zasu sanya fayilolin, kun bayyana shi a cikin filin 5, duba hotunan hoto: https://blog.desdelinux.net/wp-content/uploads/2012/09/phpmyadmin-screenshot-nuevo-usuario.jpg

  11.   Roberto m

    Na gode sosai da bayaninka, zan gwada wannan tsarin a kan sabar gwaji kuma in yi tsokaci a kan sakamakon, ina fata zan iya saboda hanya ce mai kyau don samun komai a cikin tsari, kuma tare da RAID kuna da tsayayyen ajiya tsarin: D.

    1.    KZKG ^ Gaara m

      Na gode da ku don sharhin 🙂

  12.   Roberto m

    Ina da tambaya, na riga na gudanar da girka mai tsafta-ftp tare da MySQL da adadi, batun yanzu shine ta yaya zan iya dakatar da wani asusu daga teburin mysql kansa, ba tare da canza kalmar shiga ta mai amfani ba ko fayilolin da aka loda ba.

    1.    KZKG ^ Gaara m

      Zan iya tunanin hanyoyi biyu, mafi sauki shine canza darajar Status daga 1 zuwa 0, a ka'ida idan ya kasance a 0 aka kashe asusun, gwada wannan kuma faɗa mani 🙂

  13.   birkoff m

    Roberto, ta yaya kuka gudanar da saita kudade ta amfani da wannan kayan aikin? Da fatan za a raba bayanin.
    Kyakkyawan shiga !!

    1.    Roberto Sotelo m

      Birkhoff, kawai a shafin yanar gizon kaina na ƙirƙiri wani maudu'i game da hakan, na bar mahaɗin don ku sake nazari:

      http://aprendelinux.net/instalar-servidor-ftp-pure-ftp-con-cuentas-virtuales-en-mysql/

  14.   Klaus m

    Na gode!

    Ina kokarin bin komai amma na sami kuskure 501 kuma mafi yawansu zan koma zuwa ga gaskiyar cewa kalmar sirri ba daidai bace lokacin da na san cewa yana da kyau