[es] - zaboravljena lozinka na MYSQL

dendic
servisi ,odrzavanje
Mostar

Član broj: 10678
Poruke: 1856

+10 Profil

^{06.11.2012. u 14:44 - pre 139 meseci}

ako ste zaboravili lozinku za root na MYSQL-pod Linuxom ovo mi je pomoglo da je promenim:
# dpkg -l mysql-server* | grep ii
ii mysql-server 5.0.51a-3 MySQL database server (meta package depending on the latest version)
ii mysql-server-5.0 5.0.51a-3 MySQL database server binaries

# dpkg-reconfigure mysql-server-5.0
Stopping MySQL database server: mysqld.
[debconf screen appears]

While not mandatory, it is highly
recommended that you set a password
for the MySQL administrative "root"
user.

If that field is left blank, the
password will not be changed.

New password for the MySQL "root"
user:
_______________________________________

<Ok>

Stopping MySQL database server: mysqld.
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..

Isprobat, startat sa:
#mysql -u root -p
#quit

Odgovor na temu

nkrgovic
Nikola Krgović
Beograd

Član broj: 3534
Poruke: 2807

ICQ: 49345867
Sajt: https://www.twinstarsyste..

+655 Profil

Re: zaboravljena lozinka na MYSQL

^{06.11.2012. u 15:42 - pre 139 meseci}

Debian ili ubuntu?

Prvo, ne vidim zasto bi koristio mysql server iz paketa. Nijedan razlog. Drugo, bitnije, sta ovo uradi sa mysql bazom? Obrise li i ostale usere? Trece, sta fali tome da samo uradis --skip-grant-tables ?

Please do not feed the Trolls!

Blasphemy? How can I blaspheme? I'm a god!'

Odgovor na temu