E faʻafefea ona suia le phpMyAdmin configuration e foia ai le faʻafitauli e leai se faila faila database MySQL e mafai ona faʻapipiʻiina?

💻🔧【Aʻoaʻoga sili ona faigofie】Aʻoaʻo oe suiga i lea laasaga ma lea laasagaphpMyAdminconfigure, fofoMySQLFa'afitauli le fa'aulufale mai❗️

Na fa'ata'ita'iina e le tagata lava ia e aoga✅, e na'o le tolu minute⏰ e fa'ato'a uma ai le fa'afitauliMySQLO le fa'alavelave o le le mafai ona maua le faila o le upload📂.

Leai se fa'atiga ulu e uiga i mataupu fa'aulufale mai💡, faigofie ona taulimaina fa'amaumauga fa'amaumauga📊, tu'u lauLinuxE sili atu le sologa lelei o le faiga🌟.

Linux faaulufale maiMySQL databaseO le a le mea e fai pe a e toilalo? Suia le phpMyAdmin configuration method, sau e matamata!

Ina ia maua le auala faʻapipiʻi o phpMyAdmin, e mafai ona e faʻaogaina le poloaiga lenei:

find / -name pma

或

find / -name phpMyAdmin

Afai e te mauaina se auala e pei o:

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

phpMyAdmin auala faʻapipiʻi

O lea la, faʻafetai, ua e lokaina le nofoaga faʻapipiʻi o phpMyAdmin!

E fa'apipi'i e nisi polokalame fa'atonu i totonu o le 'pma' folder, ae o isi e manana'o e tu'u i totonu o le 'phpMyAdmin' folder.

E mafai ona e mauaina auala nei:

/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

Ina ua uma le suʻega, na faʻamaonia mulimuli aneHestiaCPphpMyAdmin auala faʻapipiʻi:/etc/phpmyadmin

Le isi, e mafai ona e ulufale i totonu phpMyAdmin, filifili lau database, ma kiliki "Auina mai." Peita'i, e mafai ona fa'atapula'aina galuega fa'aulufale mai ona o le fa'aletonu.

Ae ui i lea, e mafai ona matou suia le faila o le phpMyAdmin e lagolago ai le faʻaulufaleina mai o faila database MySQL mai le server. Laasaga fa'apitoa e fa'apea:

Suia le faila faatulagaina o le phpMyAdmin

Su'e ma fa'asa'o le faila `config.inc.php`. Afai e na'o lau `config.sample.inc.php`, fai sau kopi ma toe faaigoa i le `config.inc.php`.

1. Su'e le fa'atulagaina lea:

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

2. Suia i:

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

Lapataiga

Faamolemole ia matau o le `/tmp` faila iinei o loo i totonu o le root directory o le server.

Ona mafai lea ona e lafoina faila MySQL i lenei `/tmp` directory. Fa'aaoga le SFTP e tu'u ai le faila i le `/tmp`, ona filifili lea o le Fa'aulufale mai i le fa'atonuga o fa'amaumauga a le phpMyAdmin (atonu e te mana'omia le toe saini e va'ai i suiga).

Afai o lo'o e fa'aogaina le HestiaCP, o nisi taimi e le lagolagoina e phpMyAdmin le ala fa'aletonu. I lenei tulaga, fa'amolemole sui le faila o le phpMyAdmin ma sui le ala i le 'tmp' directory a le tagata fa'aoga upega tafa'ilagi:

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

Afai e te feagai ma le "Upload folder from website server`/home/admin/tmp/`Filifili "E faʻaalia" E leai ni faila e faʻapipiʻi! ” tulaga e faailoa mai ai e le lava le faatagaga o faila.

Na'o le sui '/home/admin/tmp'Se'i le fa'atagaga o fa'atonuga ile `755':

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

I le taimi nei, e mafai ona e faʻaulufale mai ma le fiafia au faila MySQL mai lenei ala! 🚀

Afai e te faʻataʻitaʻiina le auala o loʻo i luga, phpMyAdmin faʻaulufale mai le MySQL databasee le aoga pea, pe aliali mai500 sese pe a faʻaulufale mai MySQL database, e mafai ona e faʻataʻitaʻiina auala nei▼

🔗phpMyAdmin import database 500 sese? Fa'atau atu i fafo MySQL laina tele faila faila