Dotaz: Mysql po restartu > Access denied for user

[bluewave65]

Ahoj lidi resim nasledujici problem s mysql. Omylem jsem smazal vsechny users a tak jsem za pomoci tohoto sledu prikazu vlozil roota a debian usera, do restartu se do databaze dostanu ale pak uz ne ..

hlasi :

/usr/bin/mysqlcheck: Got error: 1045: Access denied for user: 'debian-sys-maint@localhost'

---------------

killnu demona,

/usr/bin/mysqld_safe --skip-grant-tables&

mysql

use mysql;

update user set password = password('blablabla') where user = 'root' and host='localhost';

update user set password = password('blablabla') where user = 'debian-sys-maint' and host='localhost';

flush privileges;

a samozrejmne jsou hesla stejna jako v /etc/myslq/debian.cnf

-------------- jak predpokladam delam neco spatne...

diky za kazdy nakopnuti dave

Odpovědi

[blondak]

zkusit

grant all on *.* for root@"localhost" identified by "blablabla" with GRANT OPTION;
grant all on *.* for debian-sys-maint@"localhost" identified by "blablabla" with GRANT OPTION;
flush privileges;

[bluewave65]

ses si jisty touhle syntaxi ?

dave

[AloneInTheDark]

grant all on *.* for 'root'@'localhost' identified by 'blablabla' with GRANT OPTION;

grant all on *.* for 'root'@'localhost.localdomain' identified by 'blablabla' with GRANT OPTION;

grant all on *.* for 'debian-sys-maint'@'localhost' identified by 'blablabla' with GRANT OPTION;

flush privileges;

tohle mam vyzkouseno, nevim jestli by mysql zkousnula i ""

localhost.localdomain je tusim debiani specialita

[bluewave65]

tohle vsechno jsem zkusil s malou upravou misto "for" > "to", proslo to ale po restartu mysqld je vse pri starem :(((

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

[blondak]

jo jasně tam má být "to" sorry. Co se týče popsané chyby, tak se snažíš připojit k mysql jako root bez hesla, i když má heslo nastavené (blablabla).

[bluewave65]

ses si jisty touhle syntaxi ?

dave