Ukudala umsebenzisi onokufinyelela kude ku-SQL kungomunye wemisebenzi ebalulekile okumele unjiniyela wasemuva avame ukuwenza. Lokhu akunikezeli ukufinyelela kubasebenzisi abathile kuphela futhi kugcine ubuqotho nokuphepha kwesistimu, kodwa futhi kusiza ukusungula uhlelo lokuphatha lwedathabhesi esabalalisiwe olungafinyelelwa ezindaweni ezikude nezihlukene, okwengeza ukuguquguquka nokusebenziseka kalula emisebenzini ehlukahlukene. Lokhu kusebenza kuvame ukunconywa ezindaweni lapho amaqembu asatshalaliswa khona emhlabeni wonke, futhi ukufinyelela kusizindalwazi esimaphakathi kuyisidingo esiqhubekayo.
Isixazululo: SQL CREATE USER
Ku-SQL, ukudala umsebenzisi onokufinyelela kwesilawuli kude kungase kuhilele ukudala i-akhawunti yomsebenzisi kanye nokumnika amalungelo alungile. Isitatimende esithi “DALA UMSEBENZISI” sisetshenziselwa ukwakha umsebenzisi ku-MySQL. I-syntax ingase ibukeke kanje:
CREATE USER 'user'@'hostname';
Ngaphezu kwalokho, ngenkathi silungiselela ukufinyelela kwesilawuli kude, kufanele sigxile 'egameni lomethuleli'. 'Igama lomethuleli' livumela umsebenzisi ukuthi angene esuka kubasingathi abathile. Uma 'igama lomethuleli' lisethelwe ku-'%', umsebenzisi angangena kunoma yimuphi umsingathi.
Umqondo oshiwo ngenhla ubaluleke kakhulu konjiniyela nakubasebenzisi ngokufanayo. Ilawula ukuthi ubani ongaxhuma kuseva ye-MySQL nokuthi yini abangayenza uma sebelapho.
Isinyathelo ngesinyathelo nge-SQL Code
Ake sixoxe ngezinyathelo zokudala umsebenzisi onokufinyelela kude:
1.
- Qala ngokuxhuma kuseva yakho ye-SQL usebenzisa impande noma i-akhawunti enamalungelo abasebenzisi abakhulu.
mysql -u root -p
2.
- Manje, sebenzisa isitatimende se-CREATE USER ukuze udale umsebenzisi omusha.
CREATE USER 'new_user'@'%' IDENTIFIED BY 'password';
3.
- Uma umsebenzisi esedaliwe, udinga ukumnika amalungelo. Kulesi sibonelo, sizonikeza umsebenzisi wonke amalungelo.
GRANT ALL PRIVILEGES ON *.* TO 'new_user'@'%';
4.
- Ukuqinisekisa ukuthi izinguquko zenziwe ngempumelelo, layisha kabusha wonke Amalungelo.
FLUSH PRIVILEGES;
Uma usuqedele lezi zinyathelo, kuzokwakhiwa umsebenzisi omusha ongakwazi ukufinyelela iseva ye-SQL kunoma yimuphi umsingathi.
Imisebenzi Ehlobene Nemitapo yolwazi
Lapho kuxoxwa ngabasebenzisi be-SQL namalungelo abo, imiyalo ye-GRANT ne-REVOKE iqinisekisa ukuthi kukhulunywe ngaye. Le miyalo isetshenziselwa ukunikeza nokuhoxisa amalungelo avela kumsebenzisi ngokulandelanayo.
Le miyalo inikeza ukulawula okubalulekile kokuphatha ukuphepha kwesizindalwazi kanye nokuphatha izindima zabasebenzisi kanye nezibopho. Isibonelo, umyalo we-GRANT kumtapo wolwazi usetshenziselwa ukunikeza amalungelo.
Umyalo we-GRANT uhlinzeka ngezinga lokuphepha ngokulawula ukufinyelela, ngalokho, uqinisekise ubuqotho nokuphepha kwedatha yakho. Sicela uqaphele ukuthi lonke ithebula lesibonelelo kusizindalwazi se-MySQL ligcina imininingwane yelungelo lomsebenzisi. Baze banqume ukuthi hlobo luni lwemisebenzi umsebenzisi angayenza, kusukela ekukhetheni ukuya kokufaka, ukuvuselela, ukususa, nokuningi.
Ngenkathi ukudala abasebenzisi abanokufinyelela kude ku-SQL kungase kubonakale kuyinkimbinkimbi ekuqaleni, ukuhlehlisa inqubo ibe izinyathelo kwenza umsebenzi ube lula kakhulu. Ukwazi ukuthi ungayenza kanjani le miyalo ngempumelelo - kusukela ekudaleni umsebenzisi kuye ekunikezeni noma ekuhoxiseni ukufinyelela - kuyithuluzi elinamandla lonjiniyela, elibenza bakwazi ukuphatha ukuphepha kwesizindalwazi kuyilapho kuqinisekiswa ukufinyelela okuguquguqukayo nokulula okudingwa izinhlangano namuhla.
