Imiyalelo eli-10 yokulawula iziseko zedatha nge-MySQLAdmin

Iminyaka ndihlala ndiphatha indawo yam yolwazi lwe-MySQL ngokungena kwiserver ye-MySQL kwaye ndenze imiyalelo, oko kukuthi:

mysql -u root -p

Kwaye apha ndibhala iphasiwedi kwaye ndingenza le nto ndiyifunayo, nangona kunjalo ndisandula ukufumanisa: mysqladmin

Inguqulelo ye-MySQL kunye nenqanaba?

Okokuqala, makhe sijonge uhlobo lwe-MySQL efakiweyo:

mysqladmin -u root -p ping

Kulungile:

sudo service mysql status

Kwimeko yam ndifumana oku:

Okwangoku, banokuxela uhlobo lwe-MySQL obaleka nayo

mysqladmin -u root -p version

Indlela yokusetha okanye ukutshintsha iphasiwedi kwi-MySQL

Kwi-distros ezininzi xa iserver ye-MySQL ifakiwe ayisoloko iqwalaselwa ngegama elinegama eligqithisiweyo lengcambu ye-MySQL, ukuseka iphasiwedi yengcambu xa ingenayo ilula ngolu hlobo:

mysqladmin -u root password PASSWORD-QUE-QUIERAN

Ukuba oku akunjalo kwaye banegama eligqithisiweyo lengcambu kodwa banqwenela ukutshintsha, is syntax imi ngolu hlobo lulandelayo:

mysqladmin -u root -pPASSWORD-QUE-TIENEN password 'NUEVO-PASSWORD'

/ Uyenza njani isiseko sedatha kwi-MySQL?

Ilula njengokusebenza:

mysqladmin -u root -p create NOMBRE-DE-DB

Ungasicima njani isiseko sedatha kwi-MySQL?

Ifana kakhulu nomyalelo wangaphambili:

mysqladmin -u root -p drop NOMBRE-DE-DB

Uyazi njani ukuba loluphi unxibelelwano olukhoyo kwiseva ye-MySQL?

mysqladmin -u root -p status

Okwangoku ndibhala eli nqaku kwilaptop yam indibonisa oku kulandelayo:

Ixesha lokulala: 19381 Imisonto: Imibuzo eyi-1: 9518 Imibuzo ecothayo: 0 Ivula: 431 iitafile ezigungxulwayo: 1 Iitafile ezivulekileyo: I-106 Imibuzo nge-avg yesibini: 0.491

Ngokunjalo, ukuba ufuna ukwazi onke amaxabiso kunye neemeko eziguquguqukayo, beka nje:

mysqladmin -u root -p extended-status

Iziphumo ziya kubanzi kakhulu ngeli xesha.

Okanye ukuba oku akuxeleli ulwazi oludingayo, zama:

mysqladmin -u root -p variables

Kwimeko apho ufuna ukuphinda ulayishe amalungelo, oko kukuthi, yenza flush lo myalelo uya kuba:

mysqladmin -u root -p reload;
mysqladmin -u root -p refresh

Yonke le miyalelo isebenza kunye neseva ye-MySQL ekwindawo ekufutshane nayo, ukuba ufuna ukwenza imiyalelo kwiseva ekude kufuneka wongeze:

-h IP-DE-SERVIDOR

Ngapha koko, ndiyazi ukuba abaninzi bakhetha i-PHPMyAdmin kwaye abanye bakhetha i-terminal, apha sineengcebiso malunga nesiphelo sendlela 😉

Ukuba ufuna ukwazi ngakumbi nge-MySQLAdmin sele uyazi - » mysqladmin -oncedo

Phendula nge quote