Gcina iidatha zakho ze-MySQL zikhuselekile ngokwenza abasebenzisi abahlukeneyo kunye neemvume

Ndihlala ndingumhlobo wezenzo ezilungileyo, ngakumbi ukuba ziyasinceda ukugcina ukhuseleko kwiiseva zethu, iinkonzo, okanye ngokulula ulwazi lwethu.

Umkhwa (umkhwa ombi) ukuba uninzi lwabalawuli okanye abasebenzisi banako ukusebenzisa ukufikelela nawo Ingcambu Lonke ulwazi, oko kukuthi ... bafaka indawo besebenzisa i-CMS yeWordPress, kwaye njengedatha yokufikelela kwindawo yogcino lwedatha (ukuze i-WP isebenzise iseva ye-MySQL kwaye isebenzise i-DB yayo) babeka umsebenzisi wolawulo lweseva ye-MySQL: ingcambu

Kananjalo, bafaka nasiphi na esinye isicelo sewebhu (incoko, uncamathisele, iqonga, njl.njl) kwaye benze okufanayo, bahlala besebenzisa ingcambu yomsebenzisi we-MySQL ...

IPHUTHA !!!

Lo ngumkhwa nje obulalayo.

Masithi sinezi nkonzo zilandelayo kwiserver:

1. Indawo okanye i-portal esebenzisa i-WordPress.
2. Iforum yethu yenkxaso, iintetho, njl njl.
3. I-FTP esebenzisa isiseko sedatha se-MySQL ukugcina abasebenzisi kunye neephasiwedi.
4. Abasebenzisi be-imeyile bayagcinwa (abasebenzisi kunye neephasiwedi) kwindawo yedatha ye-MySQL.
5. I-WebChat encinci esiyifakayo ukuncokola nomntu omaziyo.

Kwaye kuzo zonke, kwiinkonzo ezi-5 sisebenzisa umsebenzisi wengcambu ye-MySQL ukuze inkonzo nganye ifikelele kwaye igcine idatha kwiziko ledatha ehambelana nayo.

Olunye usuku oluhle, naluphi na uninzi lwetroll phaya, kodwa ayisiyiyo nje troll kuphela, kodwa ikwabonisa ukuxhaphaza okuthile, ukuba semngciphekweni, ukugxeka, njlnjl. Ithathe isigqibo sokwenza into eyingozi kuthi.

Fumana ibug kwiWebhuChat esiyisebenzisayo, sisebenzisa le bug, iyakwazi ukufikelela kwiifayile zeWebhu zeChat, kubandakanya ifayile yoqwalaselo yeWebhuChat, kwaye… kule fayile, ngokucacileyo, kukho igama lomsebenzisi kunye negama eligqithisiweyo elisebenzisa iWebhuChat ukufikelela Iseva ye-MySQL, kwaye uqikelele ntoni? … Akukho nto inye kwaye akukho nto ingaphantsi UMSEBENZI WENJONGO!

Ngokufumana olu lwazi, ngendlela elula kakhulu i-troll inoku:

1. Sicime kunye / okanye ubambe yonke into enxulumene nesiza okanye i-portal esinayo (WordPress).
2. Ungayicima kwaye / okanye ube ulwazi kuthi nakubasebenzisi bethu abasebenzisa iQonga, uluntu esiludalayo.
3. Unokuba igama lomsebenzisi kunye negama eligqithisiweyo BONKE abasebenzisi abaneakhawunti ye-imeyile kwiseva yethu, kunye nokuba ulwazi lwabo lwe-imeyile, ukuzenza, njl.
4. Kwaye ngoku ekugqibeleni, ungasebenzisa iakhawunti kwiseva yethu ye-FTP, kwaye ulayishe nayiphi na ifayile equlathe i-malware, eya kukuvumela ukuba ufumane u-ABSOLUTE kunye nolawulo lwe-TOTAL kwiseva yethu.

Ewe ... ucinga ntoni? … 🙂

Ngaba uyayibona yonke into enokwenzeka ngokungadali abasebenzisi abazimeleyo kwiziko ledatha ngalinye esinalo?

ASIYIbahlobo ebaxwayo, oku kunokwenzeka ngokukhululeka okumangalisayo ..., konke okufunekayo ukubangela intlekele sisiphazamisi kwezinye iinkqubo zewebhu ozifakileyo.

Ngoku…

Indlela yokwenza abasebenzisi abahlukeneyo be-MySQL kwisicelo ngasinye sewebhu?

Kuqala kufuneka singene kwiserver ye-MySQL kunye nengcambu yomsebenzisi, kuba nguye onelungelo lokudala iziseko zedatha, ukuseka iimvume, ukudala abasebenzisi, njl.

mysql -u root -p

Xa bebhala oku kungasentla kwaye cinezela [Ngena] Baza kucelwa iphasiwedi yomsebenzisi wengcambu ye-MySQL, bayichwetheze kwaye bacinezele [Ngena] kwakhona, uya kuboniswa kwangoko into enje: Ngoku siza kwenza i-database enegama «yewebhu":
CREATE DATABASE webchatdb;

Ilungile, sele uyenzile idathabheyisi, ngoku masiqhubeke senze umsebenzisi «webchatuser«Ngegama eligqithisiweyo«igama eligqithisiweyo":

CREATE USER 'webchatuser'@'localhost' IDENTIFIED BY 'passworddelputowebchat';

Ngoku umlingo ... siza kunika onke amalungelo (funda kwaye ubhale) kuwo webchatuser KUPHELA kwi-DB yewebhu:

GRANT ALL PRIVILEGES ON webchatdb.* TO 'webchatuser'@'localhost' WITH GRANT OPTION;

Kwaye i-voila, umsebenzisi sele enayo imvume kwiziko ledatha ... ngoku kuhlala kuphela ukuvuselela iimvume kwi-MySQL, oko kukuthi, xelela i-MySQL ukuba iphinde ifunde amalungelo abasebenzisi ngenxa yokuba senze utshintsho kubo:

FLUSH PRIVILEGES ;

Ndikushiya umfanekiso weskrini: Kwaye ibiyiyo yonke into. Ngokwenza oku kwisicelo ngasinye sewebhu esisisebenzisayo, siyaqinisekisa ukuba xa bekwazi ukwaphula enye yezi zicelo zewebhu, ezinye ziya kukhuseleka (ubuncinci ukusuka kwindawo yokujonga ye-MySQL)

Yintoni elungileyo? 😉

Ndiyathemba ukuba iluncedo kuwe njengokuba injalo nakum, kuba ndizamile ukuyicacisa ngokulula kangangoko ndinako.

Phendula nge quote