[ dendic @ 06.11.2012. 14:44 ] @
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
[ nkrgovic @ 06.11.2012. 15:42 ] @
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 ?