Maitiro ekugadzirisa iyo phpMyAdmin kumisikidza kugadzirisa dambudziko rekuti hapana inokwirisa MySQL dhatabhesi faira?

💻🔧【Chidzidzo Chiri Nyore】Nzira yedanho nedanho yekugadzirisa magadzirirwo ephpMyAdmin nekugadzirisa zvikanganiso zvekupinza zveMySQL❗️

Yakaedzwa uye yakaratidzwa kuti inoshanda! ✅ Zvinongotora maminetsi matatu chete ⏰ kugadzirisa zvachose dambudziko rekuti MySQL haikwanise kuwana folda yakakwidzwa 📂.

Hapasisina matambudziko ekuisa madhatabhesi💡, gadzirisa dhatabhesi rako zviri nyore📊 uye ita kuti sisitimu yako yeLinux ishande zvakanaka🌟.

Chii chekuita kana kupinza database yeMySQL kukakundikana paLinux ? Heino maitiro ekugadzirisa phpMyAdmin configuration!

Kuti uwane nzira yekuisa ye phpMyAdmin, unogona kushandisa murairo unotevera:

find / -name pma

Kana

find / -name phpMyAdmin

Kana iwe ukawana nzira yakafanana ne:

/usr/local/cwpsrv/var/services/pma
/usr/local/apache/htdocs/phpmyadmin

phpMyAdmin yekuisa nzira

Saka, makorokoto, wakakiya nzvimbo yekuisa yephpMyAdmin!

Mamwe mapurogiramu epaneru ekutonga anoiisa mu `pma` folda, nepo vamwe vachida kuiisa mu `phpMyAdmin` folda.

Unogona kuwana nzira idzi:

/usr/share/phpmyadmin
/usr/share/phpmyadmin/vendor/phpmyadmin
/usr/local/hestia/install/rpm/phpmyadmin
/usr/local/hestia/install/deb/phpmyadmin
/var/lib/mysql/phpmyadmin
/var/lib/phpmyadmin
/etc/phpmyadmin

Mushure mekuedzwa, zvakazosimbiswaHestiaCPphpMyAdmin yekuisa nzira:/etc/phpmyadmin

Tevere, unogona kupinda mu phpMyAdmin, sarudza dhatabhesi yako, uye tinya "Import." Zvakadaro, mashandiro ekunze anogona kuganhurwa nekukasira.

Nekudaro, isu tinokwanisa kugadzirisa iyo faira yekumisikidza yephpMyAdmin kutsigira kupinza MySQL dhatabhesi mafaera kubva kuseva. Matanho chaiwo ndeaya anotevera:

Shandura iyo faira yekumisikidza ye phpMyAdmin

Tsvaga uye gadzirisa iyo `config.inc.php` faira. Kana uine chete `config.sample.inc.php`, ita kopi uye uipe zita rekuti `config.inc.php`.

1. Tsvaga gadziriro inotevera:

$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

2. Shandura ku:

$cfg['UploadDir'] = '/tmp';
$cfg['SaveDir'] = '/tmp';

Kuchenjerera

Ndokumbira utarise kuti `/tmp` folda iri pano iri mumudzi wedhairekitori reseva.

Unogona kurodha mafaera eMySQL kune iyi `/tmp` dhairekitori. Shandisa SFTP kuisa faira mu `/ tmp`, uye wozosarudza Ngenisa mune dhatabhesi manejimendi yephpMyAdmin (ungangoda kupinda zvakare kuti uone shanduko).

Kana iwe uri kushandisa HestiaCP, dzimwe nguva phpMyAdmin inogona kusatsigira nzira yakasarudzika. Mune ino kesi, ndapota shandura iyo faira yekumisikidza ye phpMyAdmin uye shandura nzira kuenda kune `tmp` dhairekitori rewebhu mushandisi:

$cfg['UploadDir'] = '/home/admin/tmp';
$cfg['SaveDir'] = '/home/admin/tmp';

Kana ukasangana ne "Isa folda kubva kune webhusaiti server'/home/admin/tmp/`Sarudza "Inoratidza" Iko hakuna mafaera ekuisa! ” mamiriro anoratidza kuti mvumo yeforodha haina kukwana.

Ingotsiva `/home/admin/tmp`Seta mvumo yedhairekitori ku `755`:

sudo chown www-data:www-data /home/admin/ -R
sudo chmod 755 /home/admin/ -R

Iye zvino, unogona kupinza nemufaro mafaera ako eMySQL kubva munzira iyi! 🚀

Kana wakamboedza nzira dziri pamusoro apa uye ukapinza dhatabhesi reMySQL uchishandisa phpMyAdmin zvichiri kutadza, kana kuti ukambosangana ne500 error paunopinza dhatabhesi reMySQL, unogona kuedza nzira dzinotevera ▼

🔗phpMyAdmin pinza dhatabhesi 500 kukanganisa? Export MySQL hombe faira rekuraira mutsara