Yuav ua li cas los daws phpMyAdmin tso saib MySQL/MariaDB cov ntaub ntawv hauv kev siv?

sivWordPressphooj ywg, inphpmyadminThaum kaw cov lus ntawm lub vev xaib WordPress hauv ntau, ib pawg lus Askiv tau tshwm sim…

Nws feem ntau txhais tau tias cia peb kho lub rooj, thiab tom qab ntawd tragedy strikes ...

Tom ntej no, xyuas cov qauv database qhia tau hais tias nws yog "siv" ...

Raws li pom nyob rau hauv lub screenshot hauv qab no ▼

lub sijhawm noE-kev lag luamLub vev xaib tsis tuaj yeem nkag mus, thiab nws yuav ua rau poob ntau ...

tsis paub sivVestaCPCov phooj ywg ntawm lub vaj huam sib luag puas tau ntsib qhov xwm txheej zoo sib xws?

• Thaum phpMyAdmin kuaj xyuas, kho kom zoo thiab kho cov ntaub ntawv rooj, nws tsis tuaj yeem daws ...
• Qhov teeb meem yog vim qhov kev tso cai tsis txaus, yog li peb yuav tsum rov tso cai dua.

yuav pub li casMySQL/MariaDB cov ntaub ntawv rooj tso cai?

Kauj Ruam 1:siv SSHSoftwareNkag mus rau cov lus txib nram qab no ▼

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

chown mysql:mysql -R /data/mysql/

• lub sijhawm no,MySQL/MariaDB cov ntaub ntawv rooj tso cai yuav raug muab rov qab.

Kauj Ruam 2:Qhib phpMyAdmin thiab hloov mus rau cov ntaub ntawv ntawd.

Kauj Ruam 3:Xaiv lub rooj ntaub ntawv uas yog "hauv kev siv".

Kauj Ruam 4:Nyem "Repair Table" hauv qab no.

• Thaum kawg koj tuaj yeem pom tias cov ntaub ntawv cov ntaub ntawv rov qab mus rau qhov qub.

Ceev faj

Chen WeiliangMuab tswv yim:

• Koj yuav tsum tsim kom muaj tus cwj pwm zoo ntawm kev niaj hnub thaub qab koj lub vev xaib database, thiab koj yuav tsum nkag siab qhov no.
• Txwv tsis pub, ib zaug MySQL / MariaDB cov ntaub ntawv rooj sib tsoo dua, koj tsis muaj thaub qab, yog li tsis txhob khuv xim nws!

更多MySQL databaseRau cov teeb meem thiab kev daws teeb meem, thov nyem qhov txuas hauv qab no mus saib ▼

🔗 daws kev ceeb toom: Database yuam kev Kem suav ntawm mysql.proc tsis raug.

🔗 Kev daws rau ERROR 1045 (28000): Kev nkag tsis tau rau tus neeg siv 'root'@'localhost' (siv tus password: YOG)

🔗 Yuav siv ConnectBot li cas? ConnectBot cov lus qhia ntxaws txog kev teeb tsa thiab cov txheej txheem qhia