Log Offmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 seconds
PORNESC BAZA DE DATE ..
PUBLIC_IP: 188.241.14.153 interface em0
HOSTNAME: ch_auth
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
cannot open direct sql connection to host: localhost user: ezio db: common
cannot start server while no common sql connected

PORNESC CHANNEL1_2CORE ..
PUBLIC_IP: 188.241.14.153 interface em0
HOSTNAME: ch1_1
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
cannot open direct sql connection to host: localhost user: ezio db: common
cannot start server while no common sql connected
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsPUBLIC_IP: 188.241.14.153 interface em0
HOSTNAME: ch1_2
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
cannot open direct sql connection to host: localhost user: ezio db: common
cannot start server while no common sql connected

PORNESC CHANNEL99_1CORE ..
PUBLIC_IP: 188.241.14.153 interface em0
HOSTNAME: ch99_1
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
cannot open direct sql connection to host: localhost user: ezio db: common
cannot start server while no common sql connected
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 seconds
root@metin2:/usr/home/game # mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsSuccess PLAYER
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsSuccess ACCOUNT
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 seconds


de ce apare ?

up

nu ai instalat bine server files reinstaleaza game si mysql de la capat (Y) si ai grija sa fie corect instalate.

Ok !

Nu bosulică .... n-are treabă sv file cu asta..e legat de pw de la mysql..doamne fereşte..ce gândire..trb resetată pw..dacă ai nevoie de ajutor..lasă-mi mesaj privat că te ajut cu cea mai mare plăcere .

Șterge logurile, posibil din acest motiv să îți dăuneze serverului.

Poftim:
Cum resetez parola mysql
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';

Rezolvare eroare Mysql.sock
Aceasta eroare apare din cauza faptului ca nu aveti spatiu suficient pe vds sau dedicat. Pentru a evita aceasta eroare si pentru rezolvarea ei trebuie sa stergeti frecvent urmatoarele fisiere :

sysser
syslog
PTS
game.core din channele
fisierul .err din /var/db/mysql
recomandam sa goliti si tabelele din log zilnic sau macar odata la 2 zile

[ Mesaj scris via Android ]

Pentru a rezolva mysql.sock reseteaza parola mysql si o sa-ti mearga sigur.

Arhivat ! ! Subiect inactiv !