Erroare mysql

Totalitatea subiectelor care nu respectă regulamentul impus in sectiunea "Probleme şi Întrebări" vor fi stocate aici.
Închis
Avatar utilizator
felixutzu
Nivel 2

Nivel 2
Mesaje: 171
Membru din: 31 Iul 2014, 06:44
Server: www.metin2bacau.com
Regat: Chunjo
Aprecieri: 38  
Mulţumiri: 2  
 Contact:
Medalii

HOSTNAME: game99
HOSTNAME: auth
HOSTNAME: channel1
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mys ql.sock' (2)
cannot open direct sql connection to host: localhost user: m2user db: common
cannot start server while no common sql connected
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mys ql.sock' (2)
cannot open direct sql connection to host: localhost user: m2user db: common
cannot start server while no common sql connected
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mys ql.sock' (2)
cannot open direct sql connection to host: localhost user: m2user db: common
cannot start server while no common sql connected
Server started successfully!

Introduceti CANAL EX: 1 apoi ENTER
==============================


==============================
Serverul dvs a pornit
metin2# 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 secondsSuccess PLAYER
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mys ql.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/mys ql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL s erver through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL s erver through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL s erver through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 seconds
metin2# mysql_real_connect: Can't connect to local MySQL server through socket '/t mp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL s erver through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsSuccess COMMON
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 s erver through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL s erver through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL s erver through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL s erver through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL s erver through socket '/tmp/mysql.sock' (2)
failed, retrying in 5 secondsSuccess HOTBACKUP
Nus ce naiba are :'( Rasplatesc pe cel care ma rezolva!
Onanana
Afișează semnătura
Avatar utilizator
Helios
Membru Club

Membru Club
Mesaje: 1950
Membru din: 09 Apr 2014, 21:02
Aprecieri: 2  
Mulţumiri: 208  
 Contact:
Medalii

Reinstalează mysql și vezi dacă dă aceeași eroare.
Imagine
Afișează semnătura
Avatar utilizator
felixutzu
Nivel 2

Nivel 2
Mesaje: 171
Membru din: 31 Iul 2014, 06:44
Server: www.metin2bacau.com
Regat: Chunjo
Aprecieri: 38  
Mulţumiri: 2  
 Contact:
Medalii

Si cum fac asta? :-j
Onanana
Afișează semnătura
Avatar utilizator
Cryptex
Utilizator interzis !

Utilizator interzis !
Mesaje: 838
Membru din: 12 Mar 2014, 22:53
Server: SF CryptexV2 comming
Regat: Shinsoo
Aprecieri: 131  
Mulţumiri: 535  
Discord: Copiază ID
 Contact:
Medalii

Tutorial resetare baza de date !
1. Se opreste serverul MySQL

Cod: Selectaţi tot

/usr/local/etc/rc.d/mysql-server stop
E posibil sa difere calea si numele scriptului de pornire. In Linux se foloseste de obicei

Cod: Selectaţi tot

/etc/rc.d/init.d/mysql stop
2. Se porneste serverul mysql fara parola de root

Cod: Selectaţi tot

mysqld_safe --skip-grant-tables &
3. Ne conectam ca root la serverul mysql

Cod: Selectaţi tot

mysql -u root
4. Rulam urmatoarele comenzi, care vor reseta parola de 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;
5. Oprim serverul mysql:

Cod: Selectaţi tot

/usr/local/etc/rc.d/mysql-server stop
6. Il pornim normal:

Cod: Selectaţi tot

/usr/local/etc/rc.d/mysql-server star
De aici inainte totul ar trebui sa functioneze normal. Pentru siguranta putem testa daca parola s-a schimbat intr-adevar folosind clientul mysql:

Cod: Selectaţi tot

mysql -u root -p
Daca ni se cere o parola si parola introdusa e cea care am pus-o la pasul 4, totul a functionat corect si parola e schimbata.

Dupa toate aceste procese este nevoie de un reboot , intram in putty si tastam pur si simplu :

Cod: Selectaţi tot

reboot
Imagine
Afișează semnătura
Avatar utilizator
.Deb
Fost Administrator

Fost Administrator
Mesaje: 4585
Membru din: 25 Iul 2013, 21:37
Aprecieri: 10  
Mulţumiri: 7  
 Contact:
Medalii

Subiect arhivat.
Autorul nu a mai răspuns.
Imagine
Afișează semnătura
Închis
Răspunsuri
4
Vizualizări
211
Răspunsuri
7
Vizualizări
391
Răspunsuri
4
Vizualizări
173

Înapoi la “Arhivă Probleme şi Întrebări”

  • Informaţie
  • Cine este conectat

    Utilizatori ce ce navighează pe acest forum: Google [Bot] și 13 vizitatori