Yadda ake kirkirar Sabon Mai amfani da Izinin Izini a cikin MySQL

MySQL sanannen sanannen sanannen tsarin sarrafa bayanai ne wanda yake adanawa da tsara bayanai kuma yana bawa masu amfani damar dawo dasu. Ya zo tare da ɗimbin zaɓuɓɓuka waɗanda ke ba masu amfani wasu izini ga tebur da bayanai.

A cikin wannan jagorar, zaku koyi yadda ake kirkirar sabon mai amfani da bayar da izini a cikin rumbun adana bayanan MySQL.

Yadda ake Kirkiri Sabon Mai amfani a MySQL

Don ƙirƙirar sabon mai amfani da farko shiga cikin harsashin MySQL.

$ sudo mysql -u root -p

Bayar da kalmar wucewa ta sudo tare da kalmar sirri da aka bayar lokacin saita bayanan MySQL kuma buga ENTER. Bayan haka, zaku sami wannan saurin.

Don ƙirƙirar sabon mai amfani, yi amfani da rubutun da aka nuna a ƙasa:

MariaDB [none]> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

Misali, don kirkirar sabon mai amfani da ake kira 'tecmint' a cikin rumbun adana bayanai, kira ga umarnin:

MariaDB [none]> CREATE USER 'tecmint'@'localhost' IDENTIFIED BY 'QkYKmw$5tec';

Lokacin ƙara mai amfani a cikin gida watau, a kan tsarin da kuka sanya MySQL, an ƙayyade masaukin mai amfani azaman localhost, kuma ba adireshin IP ba. Mahimmin kalmar 'localhost' ana fassara shi zuwa 'wannan kwamfutar' kuma MySQL tana kula da ita ta musamman. Hakanan, mai amfani da mysql yana amfani da localhost don ƙirƙirar haɗi zuwa uwar garken bayanan MySQL na gida.

Ya zuwa yanzu, mai amfani da tecmint ba shi da wani izinin yin hulɗa da bayanan bayanan. A takaice, mai amfani ba zai iya samun damar maƙullin MySQL ba.

Don bawa mai amfani cikakken damar zuwa duk bayanan bayanan, gami da teburin, gudana.

MariaDB [none]> GRANT ALL PRIVILEGES ON * . * TO 'tecmint'@'localhost';

A cikin umarnin da ke sama, alamun tauraron suna nuna mahimman bayanai da tebur daidai yadda mai amfani zai iya samun dama. Yana ba mai amfani duk haƙƙoƙin bayanan - karanta, rubuta, gyara, da aiwatarwa gami da aiwatar da duk ayyukan a ƙetaren sauran rumbunan adana bayanai da teburin kuma.

Zuwa yanzu, mun baiwa mai amfani cikakken damar shiga rumbun adana bayanan. Duk da yake wannan yana da sauƙin bayyana ra'ayoyin MySQL, galibi ba a ba da shawarar ba saboda yana iya haifar da haɗarin tsaro ga ɗakunan bayanan ku. Kawai tunanin abin da zai iya faruwa idan dan gwanin kwamfuta ya riƙe kalmar sirrin mai amfani. Zamu ci gaba da tattauna yadda za'a sanya takamaiman izini a cikin sashe na gaba.

Lokacin da kuka gama sanya izini ga mai amfani, sake shigar da duk gata kamar yadda aka nuna don canje-canje suyi tasiri.

MariaDB [none]> FLUSH PRIVILEGES

Yadda zaka bayar da Izinin Mai amfani daban-daban

Ga raunin yiwuwar izinin da zaku iya bawa masu amfani:

  • DUKKAN GASKIYA - Kamar yadda aka gani a baya, wannan yana ba mai amfani da MySQL cikakken damar zuwa takamaiman bayanai.
  • KIRKIRA - Yana bawa masu amfani damar kirkirar sabbin rumbunan adana bayanai ko tebur.
  • DROP - Ba masu amfani damar share rumbunan adana bayanai ko masu amfani da su.
  • Saka - Bada masu amfani damar saka layuka a cikin tebur.
  • KASHE - Yana ba masu amfani damar share layuka daga tebur.
  • Zaɓi - tare da izinin 'zaɓi', masu amfani suna iya karanta abubuwan cikin tebur.
  • UPDATE - Yana bawa masu amfani damar sabunta layuka a cikin tebur.
  • ZABE NA BAYA - Masu amfani na iya ba da ko cire gatan wasu masu amfani.

Don ba takamaiman izinin mai amfani, yi amfani da rubutun:

MariaDB [none]> GRANT permission_type ON database_name.table_name TO 'username'@'localhost';

Allyari, za ku iya ba da izini ga dukkan teburin da ke cikin tarin bayanai tare da alamar alama guda kamar yadda aka nuna:

MariaDB [none]> GRANT permission_type ON database_name.* TO 'username'@'localhost';

Misali, don sanya izinin izini ga 'tecmint' mai amfani a kan dukkan teburin bayanan gwajin, gudanar da umarnin.

MariaDB [none]> GRANT SELECT ON testdb.* TO 'tecmint'@'localhost';

Sannan zubar da gata don canje-canje ya fara aiki.

MariaDB [none]> FLUSH PRIVILEGES;

Allyari, za ku iya ba da izini da yawa a tafi ta hanyar raba su da wakafi kamar yadda aka nuna.

MariaDB [none]> GRANT INSERT, UPDATE ON testdb.* TO 'tecmint'@'localhost';

Yadda zaka soke izinin MySQL

Don soke izini daga mai amfani, yi amfani da rubutun:

MariaDB [none]> REVOKE permission_type ON database_name.table_name FROM 'username'@'localhost';

Misali, don soke izinin INSERT daga mai amfani 'tecmint', gudanar da umarnin.

MariaDB [none]> REVOKE INSERT ON testdb.* FROM tecmint'@'localhost';
MariaDB [none]> FLUSH PRIVILEGES

Don samun leke a izini na mai amfani a halin yanzu, aiwatar da:

MariaDB [none]> SHOW GRANTS FOR 'username'@'localhost';

Daga cikin kayan da ke kasa, zamu iya ganin cewa an kori izinin INSERT daga mai amfani da 'tecmint' wanda ya bar kawai 'yancin Zabi da KAYAN KYAUTA akan masarrafar gwajin.

Don gwada shiga shiga cikin harsashi na MySQL ta amfani da sabon mai amfani, fara fita.

MariaDB [none]> quit;

Sannan a sake dawowa.

$ sudo mysql -u tecmint -p

Bayar da kalmar sirri ta mai amfani kuma buga ENTER don samun damar harsashi.

Don sauke mai amfani, yi amfani da umarnin DROP, kamar yadda za ku yi yayin share bayanan bayanai.

MariaDB [none]> DROP USER 'username'@'localhost';

Kuna iya son karanta abubuwan da suka shafi MySQL masu zuwa:

  • Amfani mai Amfani don magance Matsalolin da ke Ciki a cikin MySQL
  • Mytop - Kayan aiki mai Amfani don Kula da MySQL/MariaDB Ayyuka a cikin Linux
  • Yadda za a Canza Tsoffin MySQL/MariaDB Port a cikin Linux
  • Yadda za a Sake saita MySQL ko MariaDB Akidar Kalmar wucewa a cikin Linux

Da fatan, zuwa yanzu, zaku iya ƙirƙirar masu amfani a cikin sabar bayanan MySQL ɗinku kuma cikin sauƙi sanya ko soke izini.