Problema user mysql!

Strumful · 23 Noi 2016, 18:34

Salut am vrut sa pun un serverfiles pe vdi si cand am bagat comanda:

A aparut eroare .
Am cautat pe forum cum ca cica trebuie ca parolele din navicat de la user sa coincida cu cea din chanel le-am pus la fel dar acum imi da o gramada de erori am restetat parola la baza de date in root si am pus peste tot root si degeaba da eroarea asa:

Nu stiu cum sa o mai rezolv

[FacePalm] · 23 Noi 2016, 18:39

Strumful scrie:Salut am vrut sa pun un serverfiles pe vdi si cand am bagat comanda:

GRANT ALL PRIVILEGES ON *.* TO 'mt2'@'localhost'
IDENTIFIED BY 'root' WITH GRANT OPTION;

A aparut eroare .
Am cautat pe forum cum ca cica trebuie ca parolele din navicat de la user sa coincida cu cea din chanel le-am pus la fel dar acum imi da o gramada de erori am restetat parola la baza de date in root si am pus peste tot root si degeaba da eroarea asa:

nection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
Success ACCOUNT
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
Success COMMON
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: YES)
failed, retrying in 5 secondsconnect: Connection refused
connect: Connection refused
Success HOTBACKUP
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
connect: Connection refused
Nu stiu cum sa o mai rezolv

Ok fii atent fa in felul urmator
Intai fii sigur ca este utilizatorul "root" bun

Cod: Selectaţi tot

select * from mysql.user;

Cauta userul care in dreapta are % si dupa reseteaza parola dupa tutorialul acesta

Cod: Selectaţi tot

/usr/local/etc/rc.d/mysql-server stop
apo
chown -R mysql /var/db/mysql && chgrp -R mysql /var/db/mysql
apo
/usr/local/etc/rc.d/mysql-server start
/usr/local/etc/rc.d/mysql-server stop
Apoi
mysqld_safe --skip-grant-tables &
Apoi
mysql -u root
apoi
use mysql;
apoi
update user set password=PASSWORD("Parola aleasa intre ghilimele") where User='root';
apoi
flush privileges;
apoi
quit

Sper ca te-am ajutat

Strumful · 23 Noi 2016, 18:49

Intrebare:
Problema poate fi din cauza ca am dezarhivat baza de date direct in filezila?
Adica eu nu am bagat arhiva.tar.gz am dezarhivat-o si am bagat-o direct acolo.

[FacePalm] · 23 Noi 2016, 18:54

Strumful scrie:Intrebare:
Problema poate fi din cauza ca am dezarhivat baza de date direct in filezila?
Adica eu nu am bagat arhiva.tar.gz am dezarhivat-o si am bagat-o direct acolo.

Nu are nici o legatura,

Cod: Selectaţi tot

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

chown -R mysql /var/db/mysql && chgrp -R mysql /var/db/mysql

/usr/local/etc/rc.d/mysql-server start
/usr/local/etc/rc.d/mysql-server stop
Apoi
mysqld_safe --skip-grant-tables &
Apoi
mysql -u root
apoi
use mysql;

dupa ce ai scris asta in putty scrii asta

Cod: Selectaţi tot

select * from mysql.user;

cauti utilizatorul care are % in dreapta langa user si schimbi parola asa:

Cod: Selectaţi tot

update user set password=PASSWORD("Parola aleasa intre ghilimele") where User='utilizatorul gasit acolo';
apoi
flush privileges;
apoi
quit

Si dupa mergi in fiecare ch la server si game99 si ch1 si toate coreurile care le ai in auth in config si in db in conf.txt modifici cu userul si parola care ai resetat mai sus si gata sper ca te-am ajutat ^_^

Ene · 23 Noi 2016, 18:55

normal o bagi tar.gz in filezila si o instalezi din puty sau virtual box ce folosesti

comanda instalare
mysql : tar -xzvf mysql.tar.gz

game: tar -xzvf game.tar.gz

[FacePalm] · 23 Noi 2016, 19:00

Ene scrie:normal o bagi tar.gz in filezila si o instalezi din puty sau virtual box ce folosesti

comanda instalare
mysql : tar -xzvf mysql.tar.gz

game: tar -xzvf game.tar.gz

Degeaba face asa daca nu are userul si pas la navicat sa puna in config din ch / auth / game99 in config db in conf.txt

Strumful · 23 Noi 2016, 19:23

Cand bag comanda:
mysql -u root da asa:

mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[1] + Done mysqld_safe --skip-grant-tables

Problema user mysql!

Problema user mysql

problema user/parola mysql

Problema schimbare parola/user mysql

Problema mysql.user column count in navicat

Cine este conectat