Yadda za a warware phpMyAdmin yana nuna teburin bayanan MySQL/MariaDB a amfani?

amfaniWordPresskawa, inphpMyAdminLokacin rufe tsokaci akan rukunin yanar gizon WordPress a cikin yawa, gungun turancin turanci ya tashi…

Yawanci yana nufin mu gyara teburi, sannan musiba ta afku...

Bayan haka, duba tsarin bayanan yana nuna cewa ana amfani da shi...

Kamar yadda aka nuna a hoton da ke ƙasa▼

a wannan lokacinE-kasuwanciBa za a iya shiga gidan yanar gizon ba, kuma tabbas zai haifar da asara mai yawa...

ban san yadda ake amfani baVestaCPShin abokan kwamitin sun fuskanci irin wannan yanayin?

• Lokacin da phpMyAdmin ya bincika, ingantawa da kuma gyara teburin bayanai, ba zai iya warwarewa ba...
• Matsalar ita ce saboda izini bai isa ba, don haka muna buƙatar sake ba da izini.

yadda ake bayarwaMySQL/MariaDB izinin tebur bayanai?

shafi na 1:amfani da SSH软件Shigar da umarni mai zuwa▼

chown mysql:mysql -R /usr/local/mysql/

chown mysql:mysql -R /data/mysql/

• a wannan lokacin,MySQL/MariaDB izinin tebur bayanai za a sake sanyawa.

shafi na 2:Bude phpMyAdmin kuma canza zuwa waccan bayanan.

shafi na 3:Zaɓi teburin bayanan da ke "aiki".

shafi na 4:Danna "Table Gyara" a kasa.

• A ƙarshe za ku ga cewa teburin bayanai ya dawo daidai.

Kariya

Chen WeiliangBa da shawara:

• Dole ne ku haɓaka ɗabi'a mai kyau na tallafawa bayanan gidan yanar gizon ku akai-akai, kuma dole ne ku fahimci wannan sosai.
• In ba haka ba, da zarar teburin bayanan MySQL/MariaDB ya sake faɗuwa, ba ku da madadin, don haka kar ku yi nadama!

.AriMySQL databaseDon matsaloli da mafita, da fatan za a danna hanyar haɗin da ke ƙasa don dubawa▼

🔗Maganin gargaɗi: Kuskuren Database Ƙididdiga na mysql.proc ba daidai ba ne.

🔗 warware ERROR 1045 (28000): An hana samun dama ga mai amfani 'tushen'@'localhost' (ta amfani da kalmar sirri: YES)

🔗Yaya ake amfani da ConnectBot? ConnectBot cikakken bayanin umarni da koyawa dabaru