connect: Connection refused

holahola · 18 Mai 2018, 10:38

SERVERUL A FOST PORNIT CU SUCCES!
root@DesireWorldPvp:/usr/home/game # connect: Connection refused
mysql_real_connect: Unknown database 'hotbackup'
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
Success HOTBACKUP
connect: Connection refused

root@DesireWorldPvp:/usr/home/game # connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused

PLEASE ANY FIX?

nytro123 · 18 Mai 2018, 10:50

Poate postezi si toate fisierele "syserr".

YouTube · 18 Mai 2018, 11:11

holahola scrie:SERVERUL A FOST PORNIT CU SUCCES!
root@DesireWorldPvp:/usr/home/game # connect: Connection refused
mysql_real_connect: Unknown database 'hotbackup'
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
Success HOTBACKUP
connect: Connection refused

root@DesireWorldPvp:/usr/home/game # connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused

PLEASE ANY FIX?

Sterge/modifica tot ce ai adaugat recent, daca ai adaugat ceva.
Porneste o sesiune noua in putty/consola si introdu comenzile de schimbare parola mysql;

Cod: Selectaţi tot

/usr/local/etc/rc.d/mysql-server stop

Cod: Selectaţi tot

mysqld_safe --skip-grant-tables &

Cod: Selectaţi tot

mysql -u root

Cod: Selectaţi tot

use mysql;

Cod: Selectaţi tot

update user set password=PASSWORD("PAROLA_NOUA") where User='root';

Cod: Selectaţi tot

flush privileges;

Cod: Selectaţi tot

quit

Schimba in fisierele CONFIG, din fiecare ch/core inclusiv ch99, si in conf.txt din db, parola existenta, cu cea noua setata de tine, pentru user root(daca in config ai alt user diferit de root, modifica acel user cu root).
Start server.(nu este nevoie de reboot, insa pentru siguranta ar trebui sa reboot-ezi serverul)

Aditional, reintrodu primele doua comenzi de mai sus, dupa care conecteaza-te in Navicat(se va conecta fara parola);
In baza de date mysql, cauta tabelul user, si asigura-te ca ai acolo doar 3 inregistrari ale userului root, si anume:
-localhost; 127.0.0.1; % (sterge orice este in plus fata de acestea 3).

Succes.