E faʻafefea ona foia phpMyAdmin faʻaalia MySQL / MariaDB laulau faʻamaumauga o loʻo faʻaaogaina?

Mo tagata faʻaoga WordPress , pe a taumafai e faʻagata faʻamatalaga i luga o uepisaite WordPress i le tele o taimi e faʻaaoga ai le phpMyAdmin , o le a aliali mai ni faʻamatalaga faʻa-Peretania...

E masani lava o lona uiga se'i toe teuteu le laulau, ona tupu ai lea o faalavelave...

O le isi, siaki le fausaga o faʻamaumauga o loʻo faʻaalia ai o loʻo "faʻaaogaina" ...

E pei ona fa'aalia i le fa'amalama i lalo▼

O le lē mafai ona maua le upega tafaʻilagi o fefaʻatauaʻiga i luga o le initaneti i le taimi nei o le a iʻu ai i ni gau tele...

Pe ua iai ni tagata faʻaoga o le VestaCP panel ua feagai ma se tulaga faapena?

• Pe a siaki e le phpMyAdmin, faʻamalieina ma toe faʻaleleia laulau faʻamaumauga, e le mafai ona foia...
• O le fa'afitauli ona e le lava fa'atagaga, o lea e mana'omia ai le toe tu'uina atu o fa'atagaga.

pe faapefea ona tuuina atuMySQL/ MariaDB fa'atagaga laulau fa'amaumauga?

Laasaga 1: Faaaoga le polokalama SSH e ulufale ai i le poloaiga lenei ▼

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

chown mysql:mysql -R /data/mysql/

• i le taimi nei,MySQL/MariaDB fa'atagaga laulau fa'amaumauga o le a toe tofia.

Laasaga 2: Tatala le phpMyAdmin ma sui i le faʻamaumauga.

Laasaga 3: Filifili le laulau faʻamaumauga i le "O loʻo Faʻaaogaina".

Laasaga 4: Kiliki le "Table Repair" o loʻo i lalo.

• Mulimuli ane e mafai ona e vaʻaia o le laulau faʻamaumauga ua toe foʻi i le masani.

Lapataiga

Ua fautua mai Chen Weiliang :

• E tatau ona e atiaʻe se masani lelei o le lagolagoina e le aunoa o lau 'upega tafaʻilagi database, ma e tatau ona e malamalama loloto i lenei mea.
• A leai, o le taimi lava e toe pa'u ai le laulau fa'amaumauga MySQL/MariaDB, e leai sau fa'amaumauga, aua ne'i e salamō!

Mo nisi faʻafitauli ma fofo i le faʻamaumauga a le MySQL , faʻamolemole kiliki le soʻotaga i lalo ▼

🔗Foia le lapataiga: Fa'amatalaga sese E sese le numera o koluma o mysql.proc.

🔗Foia ERROR 1045 (28000): Ua le maua le avanoa mo le tagata fa'aoga 'a'a'@'localhost' (fa'aoga upu fa'aoga: IOE)

🔗E faʻafefea ona faʻaoga ConnectBot? ConnectBot faʻamatalaga faʻatonuga faʻatonuga ma faʻamatalaga aʻoaʻoga