problema navicat

~ Un Băiat Diferit ~ · 10 Mar 2017, 00:59

salut am o problema cu navicatul

imediat dupa ce resetez parola nu mai pot intra pe server...

cand pornesc serverul

Real Server
Log Offmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 seconds^C
mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsroot@localhost:/usr/game/administrare_server # mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsSuccess PLAYER
mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)

merge sa intru in navicat cu parola cea noua.. am intrat la user sa pun parola actuala dau save si tot cea veche se salveaza..
cine imi explica si mie cum rezolv..

Cukycuky · 10 Mar 2017, 12:49

Mergi in putty , scrie asa mysql -u root -p , baga parola , apoi scrie

grant all on *.* to root@'%' identified by 'paroladorita';

La parola dorita iti pui parola din navicat , ar trebuii sa mearga dupa

Pongo A.K.A Titan · 10 Mar 2017, 13:31

1. Se intra in putty cu utilizatorul si cu parola de root

2. Se opreste serverul MySQL: /usr/local/etc/rc.d/mysql-server stop
3. Se porneste serverul mysql fara parola de root: mysqld_safe –skip-grant-tables &
4. Ne conectam ca root la serverul mysql: mysql -u root
5. Rulam urmatoarele comenzi, care vor reseta parola de root:
use mysql;
update user set password=PASSWORD(‘paroladorita’) where user=’root’;
flush privileges;
quit
6. Oprim serverul mysql: /usr/local/etc/rc.d/mysql-server stop
7. Il pornim normal: /usr/local/etc/rc.d/mysql-server start

De aici inainte totul ar trebui sa functioneze normal. Pentru siguranta putem testa daca parola s-a schimbat intr-adevar folosind clientul mysql: mysql -u root -p

Nu merge parola navicat cu parola setata mai sus, ce ar trebui sa fac ?
Tot in putty rulam urmatoarea comanda : grant all on *.* to root@’%’ identified by ‘paroladorita’;

~ Un Băiat Diferit ~ · 10 Mar 2017, 13:53

Pongo scrie:1. Se intra in putty cu utilizatorul si cu parola de root

2. Se opreste serverul MySQL: /usr/local/etc/rc.d/mysql-server stop
3. Se porneste serverul mysql fara parola de root: mysqld_safe –skip-grant-tables &
4. Ne conectam ca root la serverul mysql: mysql -u root
5. Rulam urmatoarele comenzi, care vor reseta parola de root:
use mysql;
update user set password=PASSWORD(‘paroladorita’) where user=’root’;
flush privileges;
quit
6. Oprim serverul mysql: /usr/local/etc/rc.d/mysql-server stop
7. Il pornim normal: /usr/local/etc/rc.d/mysql-server start

De aici inainte totul ar trebui sa functioneze normal. Pentru siguranta putem testa daca parola s-a schimbat intr-adevar folosind clientul mysql: mysql -u root -p

Nu merge parola navicat cu parola setata mai sus, ce ar trebui sa fac ?
Tot in putty rulam urmatoarea comanda : grant all on *.* to root@’%’ identified by ‘paroladorita’;

Parola merge schimbata la server ma pot conecta la navicat tot...
dar cand dau drumu la server imi da err asta...

Cod: Selectaţi tot

mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsSuccess ACCOUNT
mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsSuccess COMMON
mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsSuccess HOTBACKUP

fiti mai explicizi...

[Tupeu] · 10 Mar 2017, 14:36

~ Un Băiat Diferit ~ scrie:salut am o problema cu navicatul

imediat dupa ce resetez parola nu mai pot intra pe server...

cand pornesc serverul

Cod: Selectaţi tot

Real Server
Log Offmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 seconds^C
mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsroot@localhost:/usr/game/administrare_server # mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsmysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)
   failed, retrying in 5 secondsSuccess PLAYER
mysql_real_connect: Access denied for user 'root'@'localhost' (using password: YES)

merge sa intru in navicat cu parola cea noua.. am intrat la user sa pun parola actuala dau save si tot cea veche se salveaza..
cine imi explica si mie cum rezolv..

Intra in config la ch1(oricare e bun) si o sa gasesti ceva de genul:

Cod: Selectaţi tot

PLAYER_SQL: localhost mt2 mt2!@#! player

Schimbi parola mysql pentru userul mt2 cum e in linie la mine. Tu poate ai altceva, nu mt2. Schimbi parola mysql pt user ala.

Pongo A.K.A Titan · 14 Mar 2017, 00:30

Subiect inactiv arhivat !

problema navicat

Navicat 12.1.27 (ultima versiune de navicat 12) cu keygen

Problema navicat.

Problema Navicat

Problema navicat 34k

Cine este conectat

!	Mesaj de la: Pongo A.K.A Titan
	Cand credeati ca am sa mor M-am ridicat ca un invingator