Ndakagara ndiri shamwari yemaitiro akanaka, zvakanyanya kana zvikatibatsira kuchengetedza chengetedzo yemaseva edu, masevhisi, kana kungoti ruzivo rwedu.
Tsika (yakaipa tsika) ine vatungamiriri vazhinji kana vashandisi vanayo kushandisa kuwana nayo mudzi kune ese dhatabhesi, ndiko kuti ... vanoisa saiti vachishandisa iyo WordPress CMS, uye sedata rekuwana kune dhatabhesi (kuti WP ishandise iyo MySQL server uye ishandise yayo DB) vanoisa iyo MySQL server server yekushandisa mushandisi: mudzi
Zvakare, ivo vanoisa chero imwe webhu application (chat, peta, foramu, nezvimwewo) uye voita zvakafanana, vanogara vachishandisa mudzi mushandisi weMySQL ...
Kanganiso !!!
Iyi ingori tsika inouraya.
Ngatitii tine anotevera masevhisi pane server:
- Saiti kana portal uchishandisa WordPress.
- Yedu musangano wekutsigira, hurukuro, nezvimwe ... nharaunda yese.
- FTP inoshandisa dhatabhesi reMySQL kuchengetedza vashandisi nemapassword.
- Vashandisi veemail vanochengetwa (vashandisi uye mapassword) mune dhatabhesi yeMySQL.
- Diki WebChat iyo yatinomisikidza kutaura nemumwe munhu waunoziva.
Uye mune ese iwo, mumasevhisi mashanu isu tinoshandisa mushandisi wemidzi yeMySQL kuitira kuti sevhisi yega yega isvike uye ichengetedze iyo data mune inoenderana dhatabhesi.
Rimwe zuva rakanakisa, chero eakawanda troll kunze uko, asi iyi haisi troll chete, asi zvakare inobata kumwe kushandiswa, kusagadzikana, kubiridzira, nezvimwe ... inosarudza kuita chimwe chinhu chinotikuvadza.
Tsvaga bug muWebhuChat yatiri kushandisa, kutora mukana weichi bug, inokwanisa kuwana mafaira eWebhuChat, kusanganisira iyo WebChat yekumisikidza faira, uye… mune ino faira, zviripachena, kune zita rekushandisa nephasiwedi iyo iyo WebChat inoshandisa kuwana iyo MySQL server, uye fungidzira chii? … Icho hachisi chimwe chinhu uye hapana chakaderera MUDZIMAI ANOSHANDISA!
Nekuwana urwu ruzivo, nenzira yakapusa troll inogona:
- Bvisa isu uye / kana kuba zvese zvine chekuita nesaiti kana portal yatinayo (WordPress).
- Unogona kudzima uye / kana kuba ruzivo kubva kwatiri uye kubva kune vashandisi vedu vanoshandisa iyo foramu, nharaunda yatinogadzira.
- Iwe unogona zvakare kuba zita rekushandisa uye password yeVASHANDI vese vashandisi vane email account pane yedu server, pamwe nekuba yavo email ruzivo, kutevedzera, nezvimwe
- Uye ikozvino pakupedzisira, iwe unogona kushandisa account pane yedu FTP server, uye kurodha chero faira rine malware, izvo zvinokutendera iwe kuti uwane ABSOLUTE uye TOTAL kutonga kwe server yedu.
Zvakanaka ... iwe unofungei? … 🙂
Iwe unoona zvese zvinogona kuitika nekusagadzira vanozvimiririra vashandisi pane yega dhatabhesi yatinayo?
Iyi HAIYO shamwari yekuwedzeredza, izvi zvinogona kuitika nekureruka kunoshamisa ... hazvo, zvese izvo zvinodiwa kuti utange njodzi iyi ingori bhudhi mune mamwe maapplication ewebhu awakaisa.
Zvino…
Nzira yekugadzira vakaparadzanisa veMySQL vashandisi pane yega webhu kunyorera
Kutanga isu tinofanirwa kuisa iyo MySQL server nemudzi mushandisi, nekuti ndiye iye ane rombo rekugadzira dhatabhesi, kumisikidza mvumo, kugadzira vashandisi, nezvimwe.
mysql -u root -p
Kana vachinyora zviri pamusoro uye dzvanya [Pinda] Ivo vanozobvunzwa iyo password yeiyo MySQL midzi mushandisi, ivo vanonyora iyo uye vanodzvanya [Pinda] zvakare, iwe unozoratidzwa pakarepo chinhu chakadai.
Iye zvino tichagadzira dhatabhesi inonzi «webchatdb":
CREATE DATABASE webchatdb;
Wakagadzirira, iwe watogadzira iyo database, ikozvino ngatienderere mberi nekugadzira mushandisi «webchatuser«Ine password«passworddelputowebchat":
CREATE USER 'webchatuser'@'localhost' IDENTIFIED BY 'passworddelputowebchat';
Zvino mashiripiti ... isu tichapa ese maropafadzo (kuverenga nekunyora) ku webchatuser CHETE muDB webchatdb:
GRANT ALL PRIVILEGES ON webchatdb.* TO 'webchatuser'@'localhost' WITH GRANT OPTION;
Uye voila, mushandisi atove nemvumo mudhatabhesi iyoyo ... ikozvino zvinongoramba zvichizorodza zvibvumirano zveMySQL, ndiko kuti, udza MySQL kuti iverenge zvekare rombo rakanaka revashandisi nekuti isu tangoita shanduko mavari:
FLUSH PRIVILEGES ;
Ini ndinokusiira skrini:
Uye izvi zvave zvese. Nekuita izvi kune yega webhu application yatinoshandisa, isu tinovimbisa kuti kana vakwanisa kutyora imwe yeaya maapplication ewebhu, mamwe acho anenge akachengeteka (zvirinani kubva paMySQL maonero)
Ndeipi tsika yakanaka? 😉
Ndinovimba yave ichikubatsirai sezvazviri kwandiri, nekuti ndakaedza kuzvitsanangura zvakapusa nepandaikwanisa.
Reply with quote
Yakanaka post KZKG, dai yaive muforum ini ndaibvunza inonamira!
Thanks 😀
Iyo password yawakaisa yewebhu webhu yakanaka, chimwe chinhu chine chekuita ne mysql iko kushandisa kwayo ndangariro
Hehehe, ndatenda nekundirangaridza iwo maMySQL mirairo.Zvino ngatione kana "ini ndaisa chengetedzo" pane iyo World yeWarcraft server dhatabhesi yandinayo paLAN yangu.
ruzivo rwangu pane izvi hakuna, asi rwunenge rwakafanana kana uchishandisa MySQL yeAmarok?
Gadzira Dhatabhesi amarokdb;
IPAI ZVESE ZVAKAITWA PA amarokdb. * KUTI 'amarokuser' IDENTIFIED NE 'password'; FLUSH RUDZIDZO;
Ini handina kushandisa Amarok kwenguva yakareba, yakareba, asi kana iwe ukashandisa DB iri MySQL, mune dzidziso inofanira kushanda nenzira iyoyo futi.
Mhoroi, zvingave zvakanaka kana iwe ukagadzira mukana wechengetedzo kumaseva ewebhu muLinux, mazhinji acho haana kuchengetedzeka kwakakodzera uye manejimendi iwoyo haazi nyanzvi, vanongogonesa zvinhu, semuenzaniso kushandiswa kwe symlink mumaseva anotendera kuverenga ekumisikidza mafaera emamwe maakaunti pane imwechete server vatariri vazhinji havazive izvi uye ndosaka webhusaiti inoshatisa ichiwanda
Reply with quote
Hi iwe uri kuenda sei
Kugamuchirwa kunzvimbo ino
Ini handizvione semunhu ari nyanzvi panyaya iyi nekure, asi ndichaedza kupa ruzivo rudiki rwandakawana mumakore apfuura 🙂
Chimwe chinhu chisina kuitwa nevatungamiriri vepamhepo, kupa rombo kumasaiti ane apache rimwe nerimwe, ndiko kuti, mushandisi uye boka www-data (kana zvakafanana), rinova rakasiyana kune yega yega saiti, uyezve iri cage yega yega .
Reply with quote
Zano rakanaka
Reply with quote
Ndinokutendai
NDINOVENGA kutaridzika kwetemu yako, mavara ekumashure anondiburitsa mukati meyangu pfungwa. Iwe uri kupenga unopenga xD
Kunze kweizvozvo, zvinonakidza nekuti ini ndaona zvinosiririsa zviitiko zvekushomeka kwebasa kubva kune izvo zvinhu.
Zvino, hazvisi izvo chete zvinoenderana neizvozvo, chengetedzo iri mukuvakwa kwedatabhesi, mudzidzisi akanditsanangurira, asi handisati ndanyudzwa zvakanyanya muDB ... tinofanirwa kunetsana neMongoDB = D imwe yeiyi mazuva
izvo zvakaitika kwandiri nhasi neseva yangu yerendi
Ini ndakatevera nhanho dzako, ndakapinda cpanel ndikatsvaga dhatabhesi reMySQL uye rinondiudza kuti raive risiri rehurongwa.
Ini handizive maitiro ekupinda izvozvi pasi pemudzi mushandisi
Ini ndiri neophyte mune izvi, asi kuverenga pano iwe unodzidza zvakawanda, ndinovimba unonditungamira kuti ndiwane
Mhoro 🙂
Izvo zvaunazvo ndeyeKubata (SharedHosting) kana iyo VPS (chaiyo server)?
Kana iwe uine Hosting uye kwete VPS, saka iwe unofanirwa kuona kana yako Kugamuchira ine SSH kuwana (Bata rutsigiro rwehunyanzvi hwekambani yakakutengesa iwe kuitisa uye uvabvunze maitiro ekuwana neSSH), Ukangopinda neSSH, mushandisi HAAZVI mudzi, asi iwe unofanirwa kushandisa mushandisi wawakanyora pawakaisa iyo webhu kunyorera.
Chaizvoizvo yako inyaya yakaoma, nekuti misiyano uye mikana iri sooooo yakawanda, ini ndinokurudzira kuti uvhure musoro mutsva muforamu yedu, ipapo zvichave zvakasununguka kukubatsira - » http://foro.desdelinux.net
Kwaziso 😀
Zvakanaka,
Ini ndinonzwisisa kuti itsika yakanaka kusapa mikana yese kune chero mushandisi kunze kwemidzi. Nekudaro, kubvira pandakaisa phpmyadmin mushandisi mutsva "phpmyadmin" akagadzirwa neropafadzo dzese. Zvinotaridza zvine musoro kuti izvi ndizvo zvazvinofanira kuva, nekuti ingori graphical vhezheni yekugadzirisa dhatabhesi muMySQL. Zvisinei, ndinoda kuve nechokwadi kana zvakanaka sezvazviri kana ndichifanira kumisikidza mune rombo rakanaka remushandisi "phpmyadmin".
Kwazisai uye ndinokutendai!
Zvakanaka…
Ndiri mumwe wevanoita zvese nemidzi, asi wandivhurira maziso shamwari ..
Ndotenda zvikuru…