Momwe mungasinthire kasinthidwe ka phpMyAdmin kuti muthane ndi vuto loti palibe fayilo ya database ya MySQL yomwe ingakweze?

💻🔧【Phunziro Losavuta Kwambiri】Chitsogozo cha sitepe ndi sitepe chosinthira kasinthidwe ka phpMyAdmin ndikuthetsa zolephera zolowetsa za MySQL❗️

Yayesedwa ndipo yatsimikizika kuti ndi yothandiza! ✅ Zimangotenga mphindi zitatu zokha ⏰ kuti vuto la MySQL lisathe kulowa mufoda yomwe yakwezedwa 📂 lithe.

Palibenso vuto lokhudza kulowetsa ma database💡, sungani mosavuta database yanu📊 ndikupangitsa kuti dongosolo lanu la Linux lizigwira ntchito bwino🌟.

Kodi mungachite chiyani ngati kutumiza deta ya MySQL kwalephera pa Linux ? Umu ndi momwe mungasinthire kasinthidwe ka phpMyAdmin!

Kuti mupeze njira yoyika phpMyAdmin, mutha kugwiritsa ntchito lamulo ili:

find / -name pma

Kapena

find / -name phpMyAdmin

Ngati mupeza njira yofanana ndi:

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

phpMyAdmin kukhazikitsa njira

Chifukwa chake, zikomo, mwatseka malo oyika phpMyAdmin!

Mapulogalamu ena owongolera adzayiyika mufoda ya `pma`, pomwe ena amakonda kuyiyika mufoda ya `phpMyAdmin`.

Mutha kupeza njira izi:

/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

Pambuyo poyesedwa, pamapeto pake zidatsimikiziridwaHestiaCPphpMyAdmin kukhazikitsa njira:/etc/phpmyadmin

Kenako, mutha kulowa mu phpMyAdmin, sankhani database yanu, ndikudina "Import." Komabe, magwiridwe antchito olowetsa akhoza kuchepetsedwa ndi kusakhazikika.

Komabe, titha kusintha fayilo yosinthira ya phpMyAdmin kuti ithandizire kutumiza mafayilo a database a MySQL kuchokera pa seva. Masitepe enieni ndi awa:

Sinthani fayilo yosinthira ya phpMyAdmin

Pezani ndikusintha fayilo ya `config.inc.php`. Ngati muli ndi `config.sample.inc.php`, pangani kope ndikulitchanso kuti `config.inc.php`.

1. Pezani masinthidwe awa:

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

2. Sinthani kukhala:

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

Njira zopewera

Chonde dziwani kuti chikwatu cha `/tmp` pano chili m'mizu ya seva.

Mutha kukweza mafayilo a MySQL ku `/tmp` directory. Gwiritsani ntchito SFTP kuti muyike fayilo mu `/tmp`, ndiyeno sankhani Lowani mu database ya phpMyAdmin (mungafunike kulowanso kuti muwone zosintha).

Ngati mukugwiritsa ntchito HestiaCP, nthawi zina phpMyAdmin sangagwirizane ndi njira yokhazikika. Pankhaniyi, chonde sinthani fayilo yosinthira ya phpMyAdmin ndikusintha njira yopita ku `tmp` chikwatu cha wogwiritsa ntchito webusayiti:

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

Mukakumana ndi "Kwezani chikwatu kuchokera pa seva ya webusayiti`/home/admin/tmp/`Sankhani "Zikuwonetsa" Palibe mafayilo oti mukweze! ” zomwe zikuwonetsa kuti zilolezo za chikwatu ndizosakwanira.

Ingosinthani `/home/admin/tmp`Khalani zilolezo za chikwatu ku `755`:

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

Tsopano, mutha kulowetsa mosangalala mafayilo anu a MySQL kuchokera panjira iyi! 🚀

Ngati mwayesa njira zomwe zili pamwambapa ndipo kutumiza database ya MySQL pogwiritsa ntchito phpMyAdmin sikulepherabe, kapena mukukumana ndi vuto la 500 mukatumiza database ya MySQL, mutha kuyesa njira zotsatirazi▼

🔗phpMyAdmin 500 cholakwika pakulowetsa nkhokwe? Tumizani fayilo yayikulu ya MySQL mzere wamafayilo