Ululungisa njani uqwalaselo lwephpMyAdmin ukusombulula ingxaki yokuba akukho fayile yesiseko sedata elayishwayo yeMySQL?

💻🔧【Isifundo esilula kakhulu】Ukukufundisa uhlengahlengiso lwenyathelo nenyathelophpMyAdminqwalasela, lungisaMySQLIngxaki yokungaphumeleli kwamanye amazwe❗️

Uyivavanye ngokwam ukuba iyasebenza✅, kuthatha kuphela imizuzu emithathu⏰ ukusombulula ingxaki ngokupheleleyoMySQLIngxaki yokungakwazi ukufikelela kwifolda yokulayisha📂.

Azisekho iintloko ezibuhlungu malunga nemiba yokungenisa💡, phatha ngokulula ulawulo lwedatha📊, vumela eyakhoLinuxInkqubo iqhuba ngokutyibilikayo🌟.

Ukuthathwa kweLinuxMySQL databaseYintoni omawuyenze ukuba uyasilela? Guqula indlela yephpMyAdmin yoqwalaselo, yiza kwaye ujonge!

Ukufumana indlela yokufaka yephpMyAdmin, ungasebenzisa lo myalelo ulandelayo:

find / -name pma

Okanye

find / -name phpMyAdmin

Ukuba ufumana indlela efana nale:

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

phpMyAdmin indlela yokufaka

Ke, sivuyisana nawe, uyitshixile indawo yofakelo yephpMyAdmin!

Ezinye iiprogram zephaneli yolawulo ziya kuyifaka kwi `pma` ifolda, ngelixa ezinye zithanda ukuyibeka kwifolda ethi `phpMyAdmin`.

Ungazifumana ezi ndlela:

/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

Emva kovavanyo, ekugqibeleni kwaqinisekiswaI-HestiaCPphpMyAdmin indlela yokufaka:/etc/phpmyadmin

Okulandelayo, ungangena kwiphpMyAdmin, khetha isiseko sedatha yakho, kwaye ucofe u "Ngenisa." Nangona kunjalo, umsebenzi wokungenisa elizweni unokuthintelwa ngokungagqibekanga.

Nangona kunjalo, sinokuyiguqula ifayile yoqwalaselo yephpMyAdmin ukuxhasa ukungenisa iifayile zedatha ye-MySQL kwiseva. Amanyathelo athile ngala alandelayo:

Guqula ifayile yoqwalaselo yephpMyAdmin

Fumana kwaye uhlele ifayile `config.inc.php`. Ukuba une `config.sample.inc.php` kuphela, yenza ikopi kwaye uyinike igama kwakhona ku `config.inc.php`.

1. Fumana ubumbeko lulandelayo:

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

2. Guqula ku:

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

Izilumkiso

Nceda qaphela ukuba `/tmp` incwadi eneenkcukacha apha ikuluhlu lweengcambu zomncedisi.

Unako ke ukulayisha iifayile zeMySQL kule `/tmp` directory. Sebenzisa iSFTP ukubeka ifayile ku `/tmp`, uze ukhethe Ngenisa kulawulo lwedatha yephpMyAdmin (kunokufuneka ungene kwakhona ukuze ubone utshintsho).

Ukuba usebenzisa i-HestiaCP, ngamanye amaxesha i-phpMyAdmin isenokungayixhasi indlela engagqibekanga. Kule meko, nceda uguqule ifayile yoqwalaselo yephpMyAdmin kwaye utshintshe indlela eya `tmp` ulawulo lomsebenzisi wewebhusayithi:

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

Ukuba udibana "Layisha ifolda kwiseva yewebhusayithi`/home/admin/tmp/`Khetha "Ibonisa" Akukho zifayile zokulayisha! ” imeko ibonisa ukuba iimvume zefolda azanelanga.

Nje buyisela `/home/admin/tmp`Seta iimvume zolawulo ku `755`:

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

Ngoku, ungangenisa ngovuyo iifayile zakho ze-MySQL kule ndlela! 🚀

Ukuba uzama le ndlela ingentla, iphpMyAdmin ingenisa ngaphandle isiseko sedatha seMySQLayikasebenzi, okanye ibonakala500 impazamo xa ungenisa isiseko sedatha yeMySQL, ungazama ezi ndlela zilandelayo▼

🔗phpMyAdmin 500 impazamo xa ungenisa idatabase? Thumela i-MySQL enkulu yomgca womyalelo wefayile