Hubi miisaska keydka xogta MySQL oo dayactir musuqmaasuq ah

Anigu waxaan ahay mid ka mid ah kuwa jecel inay ka feejignaadaan server-yada aan maareeyo, in kasta oo ay aad u deggan yihiin, weligood dhib malahan in markasta isha lagu hayo iyaga, sida loo yiri:

Isha sayidku waxay daashaa faraska

Waqti ka waqti way wanaagsan tahay in dhowr baaritaan lagu sameeyo serverka iyo adeegyadiisa, kiiskan waxaan ka hadli doonaa sida loo hubiyo miisaska keydka macluumaadka oo haddii midkood musuqmaasuqo, sida loo dayactiro.

Hubi miisaska MySQL DB

Sida wax walba (ama ku dhowaad wax walba), waxaa jira amar fudud oo fudud oo noo oggolaanaya inaan hubino dhammaan miisaska ku jira xogta MySQL:

mysqlcheck --check BASE_DE_DATOS --user="USUARIO" --password="PASSWORD"

Tusaale ahaan, ka soo qaad in aan haysto xog ururin la yiraahdo: project thesis

Isticmaalahayga MySQL ee maamulka waa: xididka

Iyo erayga sirta ah ee isticmaalahaasi waa: misuperpassword

Marka khadku wuxuu noqon lahaa:

mysqlcheck --check proyectotesis --user="root" --password="misuperpassword"

Waxay muujin lahayd wax sida:

dfirefoxos.wp_commentmeta OK dfirefoxos.wp_comments dfirefoxos.wp_links OK OK dfirefoxos.wp_options dfirefoxos.wp_postmeta OK OK dfirefoxos.wp_posts dfirefoxos.wp_term_relationships OK OK OK dfirefoxos.wp_termtermsfirefox dfirefoxos.wp_term_term_firefoxfirefox_wp_termfireosfirefoxonwpfoxosponomy_term_postsfirefox_wp_term_relationshipsfirefox_wpfoxospfoxonwp_term_relationshipsfirefox OK_wp_term_fireosfirefoxonwpfoxospfoxonwp_term_relationshipsfirefox_wp_term_relationshipsfirefox OK_wp_term_fireosfirefox_wpfoxospfoxfire

Si kale haddii loo dhigo, miisaska oo dhami waa hadda.

Sidee loo hagaajiyaa miiska haddii ay u muuqato mid musuqmaasuq ah?

Waxaan horeyba u sameeyay qoraal sharxaya tan oo faahfaahsan: Sida loo Dayactiro Miisaska Calaamadeysan inay xun yihiin ama Musuqmaasuqa ku jiraan MySQL

Si kastaba ha noqotee, waxaan ka tagi doonaa talaabooyinka halkan.

1. Marka hore waa inaan galno MySQL illaa terminal:

mysql -u root -p

Waxay na weydiin doontaa lambarka sirta ah, waan dhigey oo riix [Gali].

2. Kadibna waa inaan tilmaamnaa keydka macluumaadka aan adeegsan doono, taas oo ah, taas oo ah keydka keydka ee leh miiska khariban. Raacida tusaalaha bilowga, aan dhahno keydku waa: mashruuca mashruuca

use proyectotesis;

Haddana waxaan u sheegeynaa inay hagaajiso miiska musuqmaasuqa ah, tusaale ahaan aan dhahno miiska waxaa lagu magacaabaa: macluumaadka_ dadweynaha

Doonayso:

repair table public_information;

Iyo voila, tani waa inay ku filnaato dayactirka kiisaska badankood.

Waxaan rajaynayaa inay waxtar kuu leedahay ... iyo inaadan waligaa lahayn miisas musuqmaasuq 😀