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

Rau cov neeg siv WordPress , thaum sim kaw cov lus tawm tswv yim ntawm WordPress cov vev xaib hauv ntau qhov siv phpMyAdmin , ib pawg lus Askiv yuav 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 ▼

Qhov tsis muaj peev xwm nkag mus rau lub vev xaib e-commerce lub sijhawm no yuav ua rau muaj kev poob loj heev ...

Puas muaj leej twg siv VestaCP panel tau ntsib teeb meem 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 SSH software los ntaus cov lus txib hauv 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 lub database ntawd.

Kauj Ruam 3: Xaiv lub rooj ntaub ntawv hauv "Siv Tau".

Kauj Ruam 4: Nyem "Kho Rooj" 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 Weiliang hais tias:

• 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!

Yog xav paub ntxiv txog MySQL database tej teeb meem thiab kev daws teeb meem, thov nias qhov link hauv qab no ▼

🔗 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