Paetukutuku
Te Whakatūpuranga i tō Pātengi Raraunga mā phpMyAdmin
Every Kapsule website with a database gets browser based database access through phpMyAdmin, opened with single sign-on so there is no second password to keep. This guide covers opening it, reading…
Kei ia Kapsule papaiti he pūtaiao, ka whai atu he huarahi ā-pūmau ki te whakatūpuranga kōnae pūtaiao mā phpMyAdmin, tae atu ki te tāuru kotahi kāore he tohu whakaū tuarua. Ko tēnei arahanga e whakaatu ana i te tuwhera, te pānui i ō tohu hononga, ngā mahi e āhei ana ki konei, me ngā mahi pūtaiao e rua kāore e tika kia mahia i phpMyAdmin i runga i tētahi papaiti WordPress.
Te Tuwhera i phpMyAdmin
- Whakatomo ki KPanel me te pāwhiri Websites i te pae taha maui.
- Pāwhiri i ō papaiti.
- I te wharangi ake o te papaiti, whakatuwhera Files, kātahi Database.
- Pāwhiri Open phpMyAdmin.
Ka tuwhera a phpMyAdmin i tētahi ripa hou, kua whakatomo āianei ā-ōmua i ō papaiti pūtaiao. Kaore he puka whakatomo me kaore he tohu ōtahi hei pupuri.
Mēnā e kī ana te whārangi kaore he pūtaiao kua whakarite mō tēnei āhuatanga papaiti, ko te ikeike tēnā. Ko ngā papaiti HTML tūturu me ētahi āhuatanga tono, kua hangaia kaore he tahi. Ko ngā āhuatanga papaiti e whakamahi ana i tētahi pūtaiao, tae atu ki a WordPress me WooCommerce, kei a rātou tonu.
Ō Tohu Hononga
Ko te wharangi ake nei e whakaatu ana i ngā tohu e whakamahi ana ō tono, e āpiti ana tētahi pūtao kape me te kupu whakaari i huna i muri i tētahi mana whakaatu:
| Mara | Uara |
|---|---|
| Host | 127.0.0.1 |
| Port | 3306 |
| Database | To ingoa pūtaiao |
| Username | To ingoa kaiwhakamahi pūtaiao |
| Password | Huna tae noa ki tō pāwhiri whakaatu |
Ko ēnei uara ngā mea e āhei ana i wp-config.php, tētahi kōnae .env, rānei i te whakaratonga pūtaiao o tētahi āhuatanga.
Ko 127.0.0.1 te kupu "tēnei pouaka". Kaore e taea te eke atu i tō rorohiko ipu, ā kaore he nui o te whakahaere ārai ka tika tēnei: kaore te pūtaiao e whakarongo ki tētahi wāhi tūmatanui, kia whakatika. Hei hononga i tētahi kaiwhakatupuranga tūmataiti pēnā i a TablePlus, Sequel Ace rānei, whakatīpako tonutanga SSH. Titiro ki Connecting to Your Database Over an SSH Tunnel.
He Aha Hei Whakamahi
Ko phpMyAdmin he āwhina mō tētahi huinga mahi tino:
- Te pānui kōnae. Te whakaū i te mea anoa i pupuri i tētahi pligin, te tirotiro mēnā kei reira tētahi rarangi, te tatau tauira.
- Te kawekawe i tētahi pūtaiao i te wā o te nekenekehanga, o te whakahoki.
- Te whakaputa i tētahi pūtaiao, ko tētahi taumahi āwhina anō rānei, ko te tuku ki tētahi kaihanga.
- Te whakatika i tētahi uara kua pakaru, pēnā i tētahi
siteurli tuhia he hē ā-ēnei kua pēhia ō whakatomo ki te wp-admin. - Te tirotiro rahi. Te whakaraupapa i ngā tēpu mā te rahi ka kitea e koe tonu a te wā ko tētahi tēpu paetae, paetae rānei, kua wera ke.
Te Kawekawe i tētahi Pūtaiao
- Tuwhera a phpMyAdmin mai i te Database tab.
- Pāwhiri i tō ingoa pūtaiao i te pae taha maui.
- Pāwhiri Import i runga.
- Kōhiti te kōnae
.sqlme te pāwhiri Go.
Ko te kawekawe e whakapenei i ngā tēpu e tūtohi. Kaore e hononga.
Ko te kawekawe i runga i tētahi pūtaiao ora he nui te āhuatanga ā-tūmatanui ā-tata. Ko ia rarangi i tētahi tēpu e tūtohi ana ka whakapenei e te mea kei te kōnae, ā kaore he whakahoki i roto i a phpMyAdmin. Tīkina tē atu mai i te tab Backups o te papaiti: Taking a Backup.
Mō tētahi pikinga nui, tapiri ki .sql.gz tuatahi, mā te phpMyAdmin e whakatangi me te nui o te kōnae i raro i te tepe kawekawe. Mēnā e roa tonu, wehewehe ki ngā kōnae maha mā te tēpu, rānei tuwhera tētahi tikiti ā mātou ka kawekawe server-side mō koe.
Te Whakaputa i tētahi Pūtaiao
- Pāwhiri i tō ingoa pūtaiao i te pae taha maui.
- Pāwhiri Export.
- Ko Quick me te āhuatanga SQL e tika mō tētahi kape tika. Kōhiti Custom mēnā e hiahia ana koe i ngā tēpu motuhake, rānei hiahia ana koe i te putanga gzipped.
- Pāwhiri Go.
Ko te whakaputa phpMyAdmin he kape āwhina anō, kaore he rautaki taumahi. Ka pā ki te pūtaiao anake, kaore ō kōnae, ā kei te wāhi i kope ai koe. Ko ō papaiti e taumaha ā-ōmua ia rā me ngā mea tonutanga, ā ka taea mu te tīkina tūturu i tetahi wā: Taking a Backup.
E Rua Mea Kāore e Tika ki Konei
Kāore e tika te mahia tētahi rapu me te whakakapi SQL
Ko WordPress e pupuri ana i ngā tautuhinga pligin me te kaupapa hei tohu PHP i whakaraupapahia, e tohu ana i te roa o ia uara i roto. Ko tētahi rapu REPLACE() e whakaputa ana i te kupu kaore i whakabagua te roa i tohua, ā kaore e taea e te PHP te pānui i te whiringa ka whakatīria ki te āiti. Ka pēhia ngā tautuhinga kaupapa, kaore he mea i ngā pūkoro, ka whakakorekore te whakaae.
Whakamahia te Search & Replace card i te WordPress tab o te papaiti, e whakatika tika ana i te whakaraupapahia ā-ōmua tē taumahi. Whakamarama noa: Running a Search and Replace.
Kāore e tika te tūwhakatē i te kupu whakaari mā te whakauru i te wp_users
Ko ngā arahanga tawhito e kī ana kia tautuhia user_pass mā te MD5 mahi mai i te kopae pokapū phpMyAdmin. Kaore a WordPress o naianei e whakamahi ana i ngā heke MD5, ā he pōhehe i konei ka pēhia tōu pūkoro kaore ki te tūwhakatē.
Kei a KPanel ngā taputapu tika mō tēnei i te WordPress tab o te papaiti, kātahi Users: whakatomo tika me te Login as, tukuna tētahi īmēra tūwhakatē, rānei kope tētahi hononga tūwhakatē kia tukuna ki a koe. Titiro ki Resetting a Lost WordPress Admin Password.
Ngā Taputapu Pūtaiao WordPress i a KPanel
Mō te mahi pūtaiao WordPress o ia rā, ko te WordPress tab, kātahi ko te Database wāhi kei te ārai ake me te tere ake i a phpMyAdmin. Ka hoatu atu ngā rahi tēpu, te whakaora me te whakatika me te taumahi kopae ā-ōmua i tonuhia, te hurihuri o ngā tēpu tawhito ki tētahi miihini whakamahinga hou, me tētahi pāwhiri kotahi hei tī i ngā koronga tūtangata, ngā tuhi ākonga, ngā whakatīria poto kua pau, me ngā tūpuranga whakatukua. Ko te rapu me te whakakapi kei tē wāhi i muri, i runga i Quick Actions.
Āpiti ā phpMyAdmin ka hiahia koe ki te titiro i ngā rarangi āmene. Āpiti ā te Database wāhi ka hiahia koe ki te whakaputa i tētahi mea.
Te Whakarutuhau
Kaore a phpMyAdmin e tuwhera. Ko te pūtao me te whānui tohu whakatupuranga ki te papaiti. Mēnā ko tō KPanel account role he pānui anake, paninui i tētahi kaiwhakatupuranga. Mēnā kei a koe te tohu whakatupuranga ā kaore e tika tonu, ko te papaiti pea e whakatupurangaranga tonu: tirotiro i te matapihi āhuatanga i runga i te papaiti.
Kaore e taea ka hononga mai i ōku rorohiko ipu me ngā tohu i te Database tab. Kaua, ā ā-nui. Ko te pūtaiao kaore e whakatuatahi tūmatanui. Whakamahia tētahi whakatīpako SSH: Connecting to Your Database Over an SSH Tunnel.
Ko te kawekawe e tū ana kaore he hē. Tata tonu te rahi kōnae. Tapiri ki gzip, rānei wehewehe.
Whakauru i tētahi uara ā ka pakaru te papaiti. Whakahoki mai i te taumahi kopae o mua: Restoring From a Backup. Ko tēnei te take kua ahu ā-mua te taumahi.
Kua nui harikoa ngā tēpu. Whakaraupapa mā te rahi i phpMyAdmin ki te kimi i te kaiwhakahe, kātahi ka tī i te WordPress tab, te Database wāhi kaore hei whakaiti rarangi ki a ringa.