Connection refused

america23 · 03 Sep 2017, 15:01

MihaiAdrian1999 scrie:

[RaffaeL] scrie:

MihaiAdrian1999 scrie:

SYSERR: Sep  3 15:12:32 :: pid_init: 
Start of pid: 869

SYSERR: Sep  3 15:12:32 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Sep  3 15:15:58 :: pid_init: 
Start of pid: 848

SYSERR: Sep  3 15:15:58 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Sep  3 15:51:02 :: pid_init: 
Start of pid: 848

SYSERR: Sep  3 15:51:02 :: Start: TABLE_POSTFIX not configured use default

In conf.txt din "db" cauta

Cod: Selectaţi tot

TABLE_POSTFIX = ""

si modifica in

Cod: Selectaţi tot

TABLE_POSTFIX = " "

Aceeasi problema iar in putty apare asa:

Cod: Selectaţi tot

mysql_real_connect: Access denied for user 'akn'@'localhost' (using password: YES)
   failed, retrying in 5 secondsconnect: Connection refused

http://just4metin.ro/topicuri-sterse/re ... t8154.html

SnNaCk · 03 Sep 2017, 15:08

america23 scrie:
MihaiAdrian1999 scrie:
[RaffaeL] scrie:
In conf.txt din "db" cauta
Cod: Selectaţi tot
TABLE_POSTFIX = ""
si modifica in
Cod: Selectaţi tot
TABLE_POSTFIX = " "
Aceeasi problema iar in putty apare asa:
Cod: Selectaţi tot
mysql_real_connect: Access denied for user 'akn'@'localhost' (using password: YES)
   failed, retrying in 5 secondsconnect: Connection refused
http://just4metin.ro/topicuri-sterse/re ... t8154.html

Pai merge sa ma conectez la navicat... ce rost are sa o resetez iar?

[Tupeu] · 03 Sep 2017, 15:13

Reseteaza parola mysql pt user akn.

SnNaCk · 03 Sep 2017, 15:15

[Tupeu] scrie:Reseteaza parola mysql pt user akn.

Cum adica sa fac asta mai exact? acolo cand pun comanda "update user set password=PASSWORD("PAROLA_NOUA") where User='root';" , in loc de root sa pun akn sau cum?

EDIT: daca asta trebuia sa fac, am incercat sa fac asta dar nimic.... xD tot la fel face.

[Tupeu] · 03 Sep 2017, 15:24

Intra in putty si scrie urmatoarele comenzi:

Cod: Selectaţi tot

mysql -u root -p

Cod: Selectaţi tot

GRANT ALL PRIVILEGES ON *.* to 'akn'@'IP SERVER' identified by 'Parola MYSQL' with grant option;

Cod: Selectaţi tot

GRANT ALL PRIVILEGES ON *.* to 'root'@'%' identified by 'Parola MYSQL' with grant option;

Cod: Selectaţi tot

quit

Dupa dai start iar si vezi daca iti merge.

03 Sep 2017, 15:28

DROP database mysql;--

SnNaCk · 03 Sep 2017, 15:38

[Tupeu] scrie:Intra in putty si scrie urmatoarele comenzi:
Cod: Selectaţi tot
mysql -u root -p
Cod: Selectaţi tot
GRANT ALL PRIVILEGES ON *.* to 'akn'@'IP SERVER' identified by 'Parola MYSQL' with grant option;
Cod: Selectaţi tot
GRANT ALL PRIVILEGES ON *.* to 'root'@'%' identified by 'Parola MYSQL' with grant option;
Cod: Selectaţi tot
quit
Dupa dai start iar si vezi daca iti merge.

La ambele comenzi imi da asta:

Cod: Selectaţi tot

Query OK, 0 rows affected (0.00 sec)

Am dat reboot si tot asa face....

Iar Impulsive, ce trebuie sa fac cu " DROP database mysql;-- " ? sa scriu in putty?

YouTube · 03 Sep 2017, 16:22

MihaiAdrian1999 scrie:Aceeasi problema iar in putty apare asa:
Cod: Selectaţi tot
mysql_real_connect: Access denied for user 'akn'@'localhost' (using password: YES)
   failed, retrying in 5 secondsconnect: Connection refused

Modifica userul in root si parola cu parola setata de tine la mysql, atat in CONFIG din fiecare ch/core, cat si in conf.txt(sau "database.txt", asa parca era la akn)din db.

SnNaCk · 03 Sep 2017, 16:37

Gata am reusit in sfarsit.... Mersi mult Rafael. T/C

YouTube · 03 Sep 2017, 16:39

MihaiAdrian1999 scrie:Gata am reusit in sfarsit.... Mersi mult Rafael. T/C

Cu placere.

Topic mutat in probleme rezolvate.

Connection refused

Problema connect: Connection refused connect: Connection refused connect: Connection refused

Connection Refused

Connection refused

Connection refused !

Cine este conectat