Kei te mohio au ki etahi atu kaiwhakahaere kua wareware i te kupuhipa o te putake o MySQL, he tino awangawanga tenei, na?
Whakaarohia me hanga e koe he papaarangi hou, mahia nga mea katoa kaore e taea e koe na te mea kaore koe e maumahara ki te kupuhipa a te kaiwhakahaere (pakiaka) o te kaiwhakarato MySQL, he raru tino.
Maaku e whakaatu ki a koe me pehea te uru atu ki te kaituku MySQL ma te taatai KORE te tautuhi i te kupu huna pakiaka, kia taea ai e koe te huri i te kupu huna pakiaka.
Ko te mea tuatahi ka aukati i te ratonga MySQL:
service mysql stop
Na tenei i aukati te ratonga, inaianei ka tiimata taatau engari he rereke te ahua, he huarahi e kore e pa mai ki a maatau mo tetahi kupuhipa a muri ake nei:
mysqld_safe --skip-grant-tables &
Kua rite, inaianei kia uru atu ki te tauranga MySQL:
mysql -u root
Ka kite ratau kaore i tono mo te kupuhipa, ka kite kua uru atu ratau ki te papatohu MySQL te tauranga ranei ka taea nga mea katoa e hiahia ana ratau, me huri ke i te kupuhipa pakiaka MySQL.
Tuatahi ka uru atu maatau ki te papaarangi MySQL penei:
use mysql;
Na, me huri te kupuhipa:
update user set password=PASSWORD("ElNuevoPassword") where user='root';
Na, kia whakahoutia nga painga:
flush privileges;
Ka mutu ka puta atu taatau:
quit;
Kua rite, kua hurihia e maatau te kupuhipa a te kaiwhakamahi pakiaka o MySQL, inaianei ka mutu taatau mahi ka tiimata kia rite ki te tikanga:
service mysql stop
service mysql start
mutunga
Ko tenei, kua hoki mai i a raatau te mana whakahaere mo ta raatau ake kaituku MySQL
15 korero, waiho maau
Tino pai te tohu, whakawhetai
Tino pai, rawe!
kia tatari kia pa ana ki ahau kia whakamatauria, kaore he tohutohu pai
Excelente
tuhinga tino pai, he awhi !!
He tino whaihua, i whakaputaina mai ahau e koe i te jam. Mauruuru.
He tino whaihua, i whakaputaina ahau e koe i tetahi wahi kuiti, whakawhetai!
He maha nga wa i mahi ai tenei otinga ki ahau, engari inaianei he miihini miihini ano ahau kua whakauruhia ka whakamatau ki te tautuhi i te kupuhipa, heoi kei te kii mai ki ahau kaore te waahi "kupuhipa" i te waahi, tirohia te angaanga kaore ano hoki te papa. He whakaaro me pehea te whakatika?
Mauruuru, kua whakaorangia ahau e koe ma te kaha ki te whakahoki mai i taku mana ...
I mahi ahau i roto i te tekau mano nga mihi.
Ana, kua whakaotihia e koe taku raru. Mauruuru!
Ko nga mahi whakamutunga e 4 ka rereke te mihi
Mauruuru i pai te mahi maau engari he hapa taku i muri o te whakahau tuatahi me nga korero e whai ake nei:
mysqld_safe Whaiaronga '/ var / run / MySQL' mo te konae kopae UNIX
Ko te hanga i te whaiaronga kua whakaotihia te raru a ka taea e au te whakakapi i te panoni kupuhipa, ka toha e au nga whakahau mena ka pa ki tetahi.
mkdir -p / var / run / MySQL
chown MySQL: MySQL / var / Rere / MySQL
Pai rawa
Nga mihi nui mo te tuhinga.
I awhinahia ahau ki te whakahoki mai i nga papaunga whakamatautau o te pi raspberry i te wa e roa ana taku whakauru i tetahi kaitoha Rama.