Ungakushintsha kanjani ukucushwa kwe-phpMyAdmin ukuxazulula inkinga yokuthi alikho ifayela lesizindalwazi se-MySQL elilayishekayo?

💻🔧【Isifundo esilula kakhulu】Ikufundisa ukuguqulwa kwesinyathelo nesinyathelophpMyAdminlungisa, xazululaMySQLInkinga yokuhluleka kokungenisa❗️

Uzihlolele mathupha ukuthi uyasebenza✅, kuthatha imizuzu emithathu kuphela⏰ ukuxazulula inkinga ngokupheleleMySQLInkinga yokungakwazi ukufinyelela ifolda yokulayisha📂.

Akusekho ubuhlungu bekhanda mayelana nokungenisa💡, phatha kalula ukuphathwa kwesizindalwazi📊, vumela eyakhoLinuxIsistimu isebenza ngokushelela kakhulu🌟.

Ukungenisa kwe-LinuxMySQL databaseYini okufanele uyenze uma wehluleka? Shintsha indlela yokumisa ye-phpMyAdmin, woza uzobheka!

Ukuthola indlela yokufaka ye-phpMyAdmin, ungasebenzisa umyalo olandelayo:

find / -name pma

Noma

find / -name phpMyAdmin

Uma uthola indlela efana nale:

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

phpMyAdmin indlela yokufaka

Ngakho-ke, siyakuhalalisela, ukhiye indawo yokufaka ye-phpMyAdmin!

Ezinye izinhlelo zephaneli yokulawula zizoyifaka kufolda ethi `pma`, kuyilapho ezinye zithanda ukuyibeka kufolda ethi `phpMyAdmin`.

Ungathola lezi zindlela:

/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

Ngemva kokuhlola, ekugcineni kwaqinisekiswaI-HestiaCPphpMyAdmin indlela yokufaka:/etc/phpmyadmin

Okulandelayo, ungangena ku-phpMyAdmin, ukhethe isizindalwazi sakho, bese uchofoza okuthi "Ngenisa." Nokho, ukusebenza kokungenisa kungase kukhawulwe ngokuzenzakalelayo.

Nokho, singakwazi ukuguqula ifayela lokumisa le-phpMyAdmin ukuze lisekele ukungenisa amafayela esizindalwazi se-MySQL kuseva. Izinyathelo ezithile zimi kanje:

Shintsha ifayela lokucushwa le-phpMyAdmin

Thola futhi uhlele ifayela elithi `config.inc.php`. Uma `config.sample.inc.php` kuphela, yenza ikhophi futhi uyiqambe kabusha ukuze ithi `config.inc.php`.

1. Thola ukucushwa okulandelayo:

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

2. Lungisa ukuze:

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

Ukuqapha

Sicela uqaphele ukuthi `/tmp` ifolda lapha ikuhlu lwemibhalo oluyimpande yeseva.

Ungabe usulayisha amafayela e-MySQL kulolu hlu lwemibhalo `/tmp`. Sebenzisa i-SFTP ukuze ufake ifayela kokuthi `/tmp`, bese ukhetha Ngenisa ekuphathweni kwedathabhethi ye-phpMyAdmin (ungahle udinge ukungena futhi ukuze ubone izinguquko).

Uma usebenzisa i-HestiaCP, ngezinye izikhathi i-phpMyAdmin ingase ingasekeli indlela ezenzakalelayo. Kulokhu, sicela uguqule ifayela lokucushwa le-phpMyAdmin futhi ushintshe indlela eya kuhla lwemibhalo `tmp` lomsebenzisi wewebhusayithi:

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

Uma uhlangana "Layisha ifolda kusuka kuseva yewebhusayithi`/home/admin/tmp/`Khetha okuthi "Kuyabonisa" Awekho amafayela ongawalayisha! ” isimo sibonisa ukuthi izimvume zefolda azanele.

Vele ufake esikhundleni `/home/admin/tmp`Setha izimvume zohla lwemibhalo zibe `755`:

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

Manje, ungangenisa ngenjabulo amafayela akho e-MySQL kule ndlela! 🚀

Uma uzama le ndlela engenhla, i-phpMyAdmin ingenisa isizindalwazi se-MySQLayikasebenzi, noma iyavela500 lapho ungenisa i-database ye-MySQL, ungazama izindlela ezilandelayo▼

🔗phpMyAdmin yokungenisa database iphutha 500? Khipha umugqa womyalo wefayela elikhulu le-MySQL