Esi gbanwee paswọọdụ njirimara MySQL site na ọnụ

Amaara m onye nchịkwa oge ụfọdụ nke echefuru paswọọdụ MySQL, nke a nwere ike ịbụ ezigbo nsogbu, nri?

Were ya na ịchọrọ ịmepụta nchekwa data ọhụrụ, mee ihe ọ bụla na ịnweghị ike n'ihi na ịnweghị ike icheta paswọọdụ nke onye nchịkwa (mgbọrọgwụ) nke ihe nkesa MySQL, ezigbo nsogbu.

N'ebe a, m ga-egosi gị otu esi enweta ihe nkesa MySQL site na njedebe N'AGBT ịtọ ntọala paswọọdụ, yabụ ozugbo ị nwere ike ịgbanwe paswọọdụ mgbọrọgwụ.

Ihe gbasara ya:
Lelee MySQL ọdụ data tebụl na Mmezi Nrụrụ Aka

Ihe mbu gha akwusi oru mysql ahụ:

Iwu abụọ a ga - emerịrị site na ikike nchịkwa, ma site na ịtọ sudo na mmalite nke iwu ma ọ bụ na-eme ha ozugbo dị ka mgbọrọgwụ

service mysql stop

Nke a kwụsịrị ọrụ ahụ, ugbu a anyị ga-amalite ya mana n'ụzọ dị iche, ụzọ nke na-agaghị ajụ anyị maka paswọọdụ ma emechaa:

mysqld_safe --skip-grant-tables &

Njikere, ugbu a ka anyị nweta ọnụ ọnụ MySQL:

mysql -u root

Ha ga-ahụ na ọ rịaghị maka okwuntughe, ha ga-ahụ na ha abanyelarị na MySQL njikwa ma ọ bụ ọnụ ma nwee ike ịme ihe ọ bụla ha chọrọ, ka anyị gbanwee ịgbanwe paswọọdụ MySQL.

Mbụ anyị ga-abanye MySQL nchekwa data dị ka ndị a:

use mysql;

Mgbe ahụ, ka anyị gbanwee paswọọdụ:

update user set password=PASSWORD("ElNuevoPassword") where user='root';

Ugbu a ka anyị mee ka ihe ùgwù ndị a rụkwuo

flush privileges;

N'ikpeazụ, anyị ga-apụ:

quit;

Njikere, anyị agbanweela paswọọdụ nke onye ọrụ mgbọrọgwụ nke MySQL, ugbu a anyị ga-akwụsị ọrụ ahụ wee bido ya dịka o kwesiri:

service mysql stop

service mysql start

ọgwụgwụ

Nke a bụ ya, ha nwetaghachiri njikwa nke MySQL nke ha


Ọdịnaya nke isiokwu agbaso ụkpụrụ anyị nke ụkpụrụ nduzi. Kpesa mmejọ pịa ebe a.

Ihe 15 kwuru, hapụ nke gị

Hapu okwu gi

Adreesị email gị agaghị bipụtara. Chọrọ ubi na-akara na *

*

*

  1. Rụ ọrụ maka data: Miguel Ángel Gatón
  2. Nzube nke data: Nchịkwa SPAM, njikwa okwu.
  3. Ikike: Nkwenye gị
  4. Nkwurịta okwu nke data: Agaghị agwa ndị ọzọ data ahụ ma ọ bụghị site na iwu.
  5. Nchekwa data: Ebe nchekwa data nke Occentus Networks (EU) kwadoro
  6. Ikike: Oge obula inwere ike igbachi, weghachite ma hichapụ ihe omuma gi.

  1.   ọkụ dijo

    Ezigbo mma, ekele

  2.   Oke dijo

    Ọmarịcha, magburu onwe ya!

  3.   FIXOCONN dijo

    ichere ka o mee m ka m nwaa ya, o nweghi ezigbo ndụmọdụ

  4.   Chika Ibe dijo

    Excelente

  5.   Gustavo Londono L dijo

    ezigbo ederede, imakọ !!

  6.   Ricardo dijo

    Ọ bara ezigbo uru, ị kpọpụtara m na agbụ. Daalụ.

  7.   pepe dijo

    Ọ bara ezigbo uru, ị mepụtara m ọsọ ọsọ, daalụ!

  8.   Jose dijo

    Ihe ngwọta a arụọla ọrụ nye m ọtụtụ oge, mana ugbu a enwere m engine mysql ọhụrụ arụnyere ma m gbalịrị ịtọ paswọọdụ, agbanyeghị ọ na-agwa m na mpaghara "paswọọdụ" adịghị adị, lelee nhazi ahụ na ubi adịghị adị n'ezie . Echiche ọ bụla otu esi edozi ya?

  9.   Ignacio ogbara dijo

    Daalụ, ị zọpụta m site n'inwe ike nwetaghachi mysql m ...

  10.   Devid dijo

    Arụrụ m ọrụ n'ime iri puku ekele.

  11.   javierfdez dijo

    Odo, unu edoziwo nsogbu m. Daalụ!

  12.   freval dijo

    Ikpeazụ 4 nzọụkwụ na-eme ka ihe dị iche na-ekele gị nke ukwuu

  13.   FuzzJS dijo

    Daalụ na ọ rụrụ ọrụ nke ọma maka m mana enwere m njehie mgbe m nyechara iwu mbụ na ozi na-esonụ:

    mysqld_safe Directory '/ var / run / mysqld' maka faili oghere UNIX adighi

    Mepụta ndekọ ahụ edozi nsogbu ahụ ma enwere m ike mezue mgbanwe nke okwuntughe, ana m ekekọrịta iwu ọ bụrụ na ọ mere mmadụ.

    mkdir -p / var / run / mysqld
    chown mysql: mysql / var / run / mysqld

  14.   ANA JULIA dijo

    Ezigbo mma

  15.   Giusseppe dijo

    Ana m ekele gị nke ukwuu maka edemede a.
    O nyeere m aka iweghachite ọdụ data ule site na pipụ pi nke m wụnye sava LAMP ogologo oge.