Ahoj, viem, ze o danom problem sa tu uz popislao kopec ale nepozem si pomoct s mysql. Problem je nasledovny: nemozem sa prihlasit do mysql ako root pod userom sa tam bezproblemov dostanem a pokusal som sa zmenit heslo na roota cez usera skusal so to cez prikaz
mysql> UPDATE user SET Password=PASSWORD('moje_heslo') WHERE user='root';
nasledne mi vypise danu hlasku
ERROR 1046 (3D000): No database selected
Vie mi niekto poradit co to ma stym spolocne???
mysql
Pre pridávanie komentárov sa musíte prihlásiť.
mysql> USE mysql; mysql> SELECT User,Password FROM user; +------------------+-------------------------------------------+ | User | Password | +------------------+-------------------------------------------+ | root | *aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa | +------------------+-------------------------------------------+ 5 rows in set (0.01 sec) mysql> UPDATE user SET Password=PASSWORD("123456") WHERE User='root';