Paetukutuku
Te Hononga Ki To Paetukutuku I Runga i te SSH Tunnel
Your site's MySQL server only listens on the server's own loopback address, so a desktop tool such as TablePlus, Sequel Ace, DBeaver or MySQL Workbench cannot dial it directly. An SSH tunnel gives…
Ka Hono Atu Ki Te Pūtaiao Raraunga Ma Roto I Te SSH Tunnel
Ko te MySQL server o tou paetukutuku ka whakarongo noa ki te tuarongo loopback a te tūmau, nō reira ka kore te rauemi pūtaiao i te Tukutuku pēnei i a TablePlus, Sequel Ace, DBeaver, MySQL Workbench rānei e taea te whakatū tika. Ka hoatu te SSH tunnel ki aua rauemi te pokapū rohe kua tohatoha ki te pūtaiao raraunga, tēnā te huarahi e ahu ai i te GUI tika ki ō ō raraunga kaore anō te MySQL e tuwhera ki te ipurangi.
He Aha Te Pono o te Tunnel
Whakatuwhera Websites, pīkau ki te paetukutuku, kātahi Files, kātahi Database. E whakaatua ana te Connection details card i te host hei 127.0.0.1 me te pokapū hei 3306. Ehara i te whakatakiwā: ko te pūtaiao raraunga e whakae ana noa ki ngā hononga mai i te miihini e rere ana i runga. Kaore he mea i te pokapū 3306 o te internet tūmatanui, me te tango i te akomanga katoa o te whakatūkino.
E tutaki ana te SSH tunnel i tēnei āputa i te pokapū. Ka tuwhera te SSH client i te pokapū i runga i tō pāhikohiko, ka whakamunatanga i te katoa e tukuna ana ki a ia, ā ka tukuna ki te pūtaiao raraunga mai i roto i te tūmau, pērā tonu me he mahi noa i honohono.
He Aha e Hiahia Ai Koe I Mua
He hononga SSH te tunnel, nō reira me āta whakarēhita he SSH key ki te paetukutuku i mua i te whakatutuki o ēnei mea. Whakatamaki i Te Tāpiri SSH Keys Ki te Paetukutuku tuatahi, kātahi hoki mai ki konei.
Whāngai i ngā mea e whā:
- SSH host, pokapū me te ingoa kaiwhakamahi, mai i Files, kātahi SSH Keys, i te Connection details card.
- Ingoa pūtaiao raraunga, ingoa kaiwhakamahi me te kupuhipuhi, mai i Files, kātahi Database. Pīkau ki te koka kanohi kia whāngaingai i te kupuhipuhi me te koka kape kia tukuna ki tō papakaata.
Ki te kī te Database tab i No database provisioned for this site type, kaore tēnei paetukutuku i tīni rawa. Ka hangaia ngā paetukutuku tūāki me ētahi paetukutuku Node.js kaore i te pūtaiao raraunga.
Te Tuwhera o te Tunnel Mai i te Terminal
Ko te āhua whanui: te tohatoha pokapū noa ki 127.0.0.1:3306 ki tērā taha o te hononga SSH.
ssh -N -L 3307:127.0.0.1:3306 <ssh-username>@<ssh-host> -p <ssh-port>
-L 3307:127.0.0.1:3306e tuwhera ana i te pokapū 3307 i runga i tō miihini me te tohatoha ki te pokapū 3306 i te tuarongo loopback a te tūmau.-Ne kī ana kāore e whakatakoto i te anga, kia pupuri noa i te tunnel i te tuwhera.- Tāpiri
-i /path/to/keymēnā ko te key mō tēnei paetukutuku kaore i tō tuatahi.
Waiho i tēnei window terminal e rere tonu. I a ia e tuwhera ana, 127.0.0.1:3307 i runga i tō pāhikohiko ko te pūtaiao raraunga a te paetukutuku.
Whakamahi i te 3307 i te noa kauaka i te 3306. Mēnā kua whakaritea e koe a MySQL, MariaDB rānei i runga i tō miihini e whakamahi kore anō i te 3306, ā ka kore te tunnel e taea te here me te hapa "address already in use". Koia anō te pokapū noa e wātea ana.
Te Tiki i tō Database Client ki te Tunnel
I roto i tō GUI client, hangaia te hononga MySQL māmā me ēnei uara:
| Āpure | Uara |
|---|---|
| Host | 127.0.0.1 |
| Pokapū | 3307 (he pokapū noa koe i tohatoha ai) |
| Kaiwhakamahi | Ko te Username mai i te Database tab |
| Kupuhipuhi | Ko te Password mai i te Database tab |
| Pūtaiao raraunga | Ko te Database ingoa mai i te Database tab |
Kāore e tukuna ki te SSH host i te Host field. I ā te client e whakaaro ana he pūkorero i runga i tō miihini ake.
Clients me te SSH Tab Hangaia-a-roto
Ka taea e TablePlus, Sequel Ace, DBeaver me MySQL Workbench te whakahaere i te tunnel ake, me te tiaki i te terminal i te tuwhera. Whānuitia ngā rōpū kaupapa e rua:
- SSH section: host, pokapū, ingoa kaiwhakamahi me te private key file mai i te SSH Keys page.
- Database section: host
127.0.0.1, pokapū3306, me te ingoa pūtaiao raraunga, kaiwhakamahi me te kupuhipuhi mai i te Database tab.
I a te client e hanga ana i te tunnel, whakamahi 3306 i te database section kauaka i tō pokapū tohatoha noa. Ko te client e honohono ana mai i te tirohanga a te tūmau, nō reira e kite ana i te pokapū pono.
Te Whakamahi o te phpMyAdmin Engari
Mēnā ka hiahia noa koe i te tiro tere i te tēpu, kaore e hiahia ai koe i te tunnel. Ko te Database tab he phpMyAdmin card me te Open phpMyAdmin pūtona. Ka whakauru ia i a koe ma roto i te KPanel, nō reira kaore he kupuhipuhi motuhake kia maharatia, me te tuwhera i te tab hou kua aro pū ki te pūtaiao raraunga a tēnei paetukutuku.
Ko te phpMyAdmin te aukati tere mō te tirotiro, te kawe i te kaupapa kotahi, rānei te tirotiro i te uara. Ko te client tūmau ma runga i te tunnel he pai ake mō ngā kakahuakore nui, te mahi hoahoa, me te mea katoa e hiahia ai koe ki te whakapaipai. Tīkina Te Whakamahi o te phpMyAdmin mō te huarahi pūmau.
Te Kawe i ngā Kaupapa me ngā Dumps Ma Roto i te Tunnel
Me te tunnel e tuwhera ana, e mahi noa ai ngā rauemi raina pokapū, e tohu atu ana ki tō pokapū tohatoha noa:
mysql -h 127.0.0.1 -P 3307 -u <db-user> -p <db-name>
mysqldump -h 127.0.0.1 -P 3307 -u <db-user> -p <db-name> > backup.sql
Ko te dump a ringa he kopikopi whakarauhī, ehara i te rautaki taumaha. Ko ia he hou noa i te wā kua haere ai koe, me te noho i te pāhikohiko koe e haere ai. E ahu kore ana a Kapsule i ngā taumaha aunoa i ia ra i te 30 ra. Tīkina Te Tango i te Taumaha i mua tonu koe e whakawhirinaki ki te .sql file noa.
Te Whakaoti i ngā Raru
"Address already in use" i a koe e tuwhera ana i te tunnel. He mea atu i runga i tō miihini e noho kore anō i tēnei pokapū noa. Tīpakohia te atu, hei tauira -L 3399:127.0.0.1:3306, me te huri i te pokapū i tō client kia ōrite.
"Connection refused" mai i te database client. Kaore i te ihu te tunnel. Tirotiro kia noho tonu te SSH terminal me te kore i tā he hapa, me te ōrite o te pokapū i tō client me te pokapū noa i te -L tohe.
SSH e honohono ana engari te client e whakamate noa tonu. Whakatupu koe i tohatoha ki 127.0.0.1:3306 me te kore i tohatoha ki te ingoa pokapū tūmatanui. Ko te tohatoha ki te ingoa tūmatanui e ui ai ki te tūmau kia ahu i te pūtaiao raraunga i runga i te ipurangi, tēnā tonu e pare ana.
"Access denied for user". I a SSH honohono ai engari he hē ngā kaiwhakarato MySQL. Kape anō i te kaiwhakamahi me te kupuhipuhi mai i te Database tab me ngā koka kape kauaka i te tīpako, me te tirotiro e honohono ana koe ki te ingoa pūtaiao raraunga tika.
Permission denied (publickey) i mua tonu i te ahu ki MySQL. Koia te SSH layer, ehara i te pūtaiao raraunga. Hāpainga i te wāhanga whakaoti raru i Te Tāpiri SSH Keys Ki te Paetukutuku.
Kei Hea Koe e Haere Ai
- Te Tukuake Kōnae Me SFTP e whakamahi i ngā kaiwhakarato SSH e pē ake nei mō te tuku kōnae.
- Te Whakamahi o te phpMyAdmin mō te mahi pūtaiao raraunga i te pūmau.
- Te Whakatuhurangi I Te Taumaha mēnā ka haere te kaupapa i kē atu i tō whakaaro.