I-HowTo: Inkonzo ye-FTP isebenzisa isiseko sedatha se-MySQL

Ngaphandle kokungaqiniseki okunokujikeleza i-MySQL, ngokobuqu ndikhetha ukusebenza nale DB ekusebenziseni enye into. Andinanto ngokuchasene nePostgre, ndisebenzise nje i-MySQL ebomini, kwaye kude kube ngoku andinasizathu sokuphinda ndiyisebenzise.

Ngeli xesha ndiza kukufundisa ukuba ungayifaka njani iseva ye-FTP, kodwa ayisiyiyo loo nto kuphela, ndiza kukufundisa ngendlela entsonkothileyo, indlela yokwenza abasebenzisi, ipassword kunye nenye idatha yomsebenzisi igcinwe kwindawo yogcino lwedatha ye-MySQL, hayi kwiiakhawunti yendawo.

Kutheni oku kunje?

Ilula, kuba xa usenza i-backup, ukufaka iserver kwakhona okanye naluphi na utshintsho olukhulu, ukuhambisa inkonzo kuya kuba lula njengokukhuphela ifayile yoqwalaselo, kunye nokuthumela iziko ledatha le-MySQL kwi-FTP.

Ukufezekisa oku siya kusebenzisa Icocekile-FTPd, kulungile ... masiqalise 🙂

Ukufaka inkonzo ye-FTP nge-Pure-FTPd

1. Into yokuqala yokwenza kukufaka iphakheji: ecocekileyo-ftpd-mysql

Kwi-distros ezinje Debian okanye ezivela kwezinye: Ukufakwa ngokufanelekileyo kwi-pure-ftpd-mysql

2. Nje ukuba sifakelwe, sayiqala inkonzo kodwa kufuneka siyimise, ukuyimisa kwiinkqubo ezinje ngeDebian okanye ezinye, zanele:

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

Nangona kunjalo, ndikushiya umgca oya kumisa inkonzo ngaphandle kwendlela oyisebenzisa ngayo:

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

Ukulungiselela iimeko kwiseva ye-MySQL

Sele ndichazile kwakudala ukuba ungasenza njani isiseko sedatha, umsebenzisi kwaye unike loo mvume kumsebenzisi kwiziko ledatha: Abasebenzisi kunye neemvume kwi-MySQL

Masiqhubeke sizokwenza ntoni apha? ...

1. Siza kwenza idatabase ewe, kodwa kuqala siyafikelela kwi-MySQL:

mysql -u root -p

2. Nje ukuba ngaphakathi kwe-MySQL siqhubeke nokwenza isiseko sedatha mzantsi:

CREATE DATABASE myftpdb;

3. Ngoku siza kudala umsebenzisi myftpuser kwaye siya kunika imvume yokusebenzisa umsebenzisi kwiziko ledatha esisandula ukulenza, lo msebenzisi uya kuba negama eligqithisiweyo igama eliyigama:

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

4. Silungile, senze isiseko sedatha, umsebenzisi kunye nokuseta iimvume. Ngoku kufuneka singenise isiseko sedatha (okanye esicocekileyo) ukuze oku kugqitywe. Ukwenza oku, masiqale ukuphuma kwi-MySQL:

exit;

Ngoku masikhuphele isiseko sedatha endikunika sona:

Okanye kwiseva sebenzisa lo mgca ulandelayo:

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

Silungile, sele sinayo kwiserver yethu, ngoku kuhlala kuphela ukungenisa idatha yakho:

mysql -u root -p myftpdb < myftpdb.sql

Kwaye ulungile!

5. Kwaye konke oku kukuba neemeko ze-MySQL yethu ilungile.

Ukujoyina i-FTP kunye ne-MySQL

Ewe, sele sinayo inkonzo ye-FTP efakiweyo, inkonzo ye-MySQL efakiweyo kunye nesiseko sedatha yethu ... ngoku sifuna nje, Joyina inkonzo ye-FTP kunye ne-MySQL.

1. Kuqala kufuneka sikhuphele ifayile yoqwalaselo esiya kuyisebenzisa kulapha ngasentla. Kwisiphelo seserver masibeke lo mgca ulandelayo:

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

2. Ngoku siqala inkonzo ye-FTP ukuba iyisebenzise ukungqinisisa abasebenzisi be-MySQL, kwaye siza kubonisa ukuba yeyiphi na ifayile yoqwalaselo oza kuyisebenzisa ukunxibelelana ne-MySQL:

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

Kwaye voila 😀

Oku kwanele ukufakela iserver yethu ye-FTP eqinisekisa ngesiseko sedatha ye-MySQL.

Ukuba ufuna ukuba ngalo lonke ixesha iserver iqala ngokuzenzekelayo iqala inkonzo ye-FTP, kufuneka ubeke ifayile /etc/rc.local umgca esiwusebenzisayo ukwenza i-FTP, oko kukuthi, sibeka /etc/rc.local oku:

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

Ngendlela, unokufikelela kwi-FTP usebenzisa nasiphi na isikhangeli, kunye nabaxhasi be-FTP abanjengeFayilezilla ... kwaye ayisiyiyo loo nto kuphela, usebenzisa iibrawuza zefayile ezinjengeNautilus, iDolphin okanye iPCManFM unokukhuphela kwaye ulayishe iifayile

Umsebenzisi wovavanyo okwedatha

Usuario: umvavanyi

Inombolo yokuvula: igama lokugqitha

Indlela yokulawula abasebenzisi be-FTP?

Ewe, ucinga ukuba sisiseko sedatha se-MySQL, njengoko benditshilo apha ngasentla ... ukusebenzisa i-PHPMyAdmin okanye i-Adminer iyakwanela. Sebenzisa nje isicelo sakho osithandayo ukulawula isiseko sedatha, esineetafile enye: abasebenzisi ... kwaye kuyo abasebenzisi, nantsi umfanekiso-skrini:

Ukuba ufuna ukwenza umsebenzisi omtsha, unokuphinda kabini okanye udibanise umgca okhoyo kwaye utshintshe idatha eya kwahluka phakathi kwabo bobabini abasebenzisi, nantsi ndikubonisa umfanekiso weskrini:

Ewe ... ayikho enye into yokongeza i-🙂

Ndiyathemba ukuba oku kuluncedo kuwe kwaye uyazi, nayiphi na imibuzo okanye iingcebiso undazise.

Phendula nge quote

PD: Kule khokelo sisebenzisa amagama agqithisiweyo agciniweyo kwiziko ledatha kwisicatshulwa esicacileyo, ukuba ufuna ukhuseleko ngakumbi ndincoma ukuba uzame md5 😉