Dotaz: MySQL + změna hesla uživatele root

[Pavel]

Co dělám špatně ?

root@mojmir ~# /usr/bin/mysqladmin -u root password 'mojeheslo'
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
root@mojmir ~#

u "mojeheslo" maji byt dve ostre zavorky,ale odmitl mi to zformatovat.

Odpovědi

[Michal Žila]

mysql -uroot -p

[KLFMANiK]

prečo sa nepozriete do dokumentácie MySQL???

http://dev.mysql.com/doc/mysql/en/resetting-permissions.html

#

Restart the MySQL server with the special --skip-grant-tables option:

shell> mysqld_safe --skip-grant-tables &

#

Set a new password for the root@localhost MySQL account:

shell> mysqladmin -u root flush-privileges password "newpwd"

Replace ``newpwd'' with the actual root password that you want to use