Problemă/Întrebare:Nu ma pot conecta la Mysql
Tipologie server:
*Resursă folosită:
*ServerFiles utilizat: Cartof
*Syserr:
Poză:
*Detalii suplimentare: salut nu ma pot conecta la mysql imi arata asa cum se vede sus in poza si nu pot schimba gen nici parola
Problema Mysql
- Sader2321
-

- Mesaje: 26
- Membru din: 22 Mar 2020, 17:32
- Server: Metin2 Boom
- Regat: Jinno
- Aprecieri: 82
- Mulţumiri: 0
- Discord: Copiază ID
failed, retrying in 5 secondsSuccess HOTBACKUP
root@metin2:~ # PUBLIC_IP: 188.214.88.227 interface em0
PUBLIC_IP:: Too many arguments.
root@metin2:~ # HOSTNAME: dev99_1
HOSTNAME:: Too many arguments.
root@metin2:~ # mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mys ql.sock' (2)
Unmatched '.
root@metin2:~ # cannot open direct sql connection to host: localhost user: ezio db: common
cannot: Command not found.
root@metin2:~ # cannot start server while no common sql connected
cannot: Command not found.
root@metin2:~ # Wonder-Core.
Wonder-Core.: Command not found.
root@metin2:~ # root@metin2:~ # mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Unmatched '.
root@metin2:~ # failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL serve r through socket '/tmp/mysql.sock' (2)
Unmatched '.
root@metin2:~ # failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Unmatched '.
root@metin2:~ # failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Unmatched '.
root@metin2:~ # failed, retrying in 5 secondsSuccess PLAYER
failed,: Command not found.
root@metin2:~ # mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Unmatched '.
root@metin2:~ # failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Unmatched '.
root@metin2:~ # failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Unmatched '.
root@metin2:~ # failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Unmatched '.
root@metin2:~ # failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Unmatched '.
root@metin2:~ # failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Unmatched '.
root@metin2:~ # failed, retrying in 5 secondsSuccess ACCOUNT
failed,: Command not found.
root@metin2:~ # mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Unmatched '.
root@metin2:~ # failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Unmatched '.
root@metin2:~ # failed, retrying in 5 secondsmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Unmatched '.
root@metin2:~ #
- KingTitan
-

- Mesaje: 101
- Membru din: 15 Iul 2020, 10:43
- Server: Tonorus2
- Regat: Jinno
- Aprecieri: 2
- Mulţumiri: 207
- Discord: Copiază ID
Dupa ce instalezi svf-ul, dai reboot apoi resetezi parola mysql
Ai grija la user, daca userul este root si tu pui metin2 atunci nu o sa iti mearga sa te conectezi
[ Postat de pe iPhone ]
Ai grija la user, daca userul este root si tu pui metin2 atunci nu o sa iti mearga sa te conectezi
[ Postat de pe iPhone ]

Cod: Selectaţi tot
/usr/local/etc/rc.d/mysql-server stop
mysqld_safe --skip-grant-tables &
mysql -u root
use mysql;
update user set password=PASSWORD('paroladorita') where user='root';
flush privileges;
quit
/usr/local/etc/rc.d/mysql-server stop
/usr/local/etc/rc.d/mysql-server start- Sader2321
-

- Mesaje: 26
- Membru din: 22 Mar 2020, 17:32
- Server: Metin2 Boom
- Regat: Jinno
- Aprecieri: 82
- Mulţumiri: 0
- Discord: Copiază ID
nu ma lasa sa resetez parola am incercat toate modelele de pe ytKingTitan scrie: ↑29 Iul 2020, 13:25 Dupa ce instalezi svf-ul, dai reboot apoi resetezi parola mysql
Ai grija la user, daca userul este root si tu pui metin2 atunci nu o sa iti mearga sa te conectezi
[ Postat de pe iPhone ]
Cod: Selectaţi tot
/usr/local/etc/rc.d/mysql-server stop mysqld_safe --skip-grant-tables & mysql -u root use mysql; update user set password=PASSWORD('paroladorita') where user='root'; flush privileges; quit /usr/local/etc/rc.d/mysql-server stop /usr/local/etc/rc.d/mysql-server start
- Sader2321
-

- Mesaje: 26
- Membru din: 22 Mar 2020, 17:32
- Server: Metin2 Boom
- Regat: Jinno
- Aprecieri: 82
- Mulţumiri: 0
- Discord: Copiază ID
KingTitan scrie: ↑29 Iul 2020, 13:25 Dupa ce instalezi svf-ul, dai reboot apoi resetezi parola mysql
Ai grija la user, daca userul este root si tu pui metin2 atunci nu o sa iti mearga sa te conectezi
[ Postat de pe iPhone ]
Cod: Selectaţi tot
/usr/local/etc/rc.d/mysql-server stop mysqld_safe --skip-grant-tables & mysql -u root use mysql; update user set password=PASSWORD('paroladorita') where user='root'; flush privileges; quit /usr/local/etc/rc.d/mysql-server stop /usr/local/etc/rc.d/mysql-server start
- Sader2321
-

- Mesaje: 26
- Membru din: 22 Mar 2020, 17:32
- Server: Metin2 Boom
- Regat: Jinno
- Aprecieri: 82
- Mulţumiri: 0
- Discord: Copiază ID
root@metin2:~ # /usr/local/etc/rc.d/mysql-server stop
/usr/local/etc/rc.d/mysql-server: Command not found.
root@metin2:~ # mysqld_safe --skip-grant-tables &
[1] 911
root@metin2:~ # mysql -u root
mysqld_safe: Command not found.
mysql: Command not found.
[1] + Exit 1 mysqld_safe --skip-grant-tables
root@metin2:~ # use mysql;
use: Command not found.
root@metin2:~ # update user set password=PASSWORD('razvanrzv') where user='root';
Badly placed ()'s.
root@metin2:~ # flush privileges;
flush: Command not found.
root@metin2:~ # quit
quit: Command not found.
root@metin2:~ # /usr/local/etc/rc.d/mysql-server stop
/usr/local/etc/rc.d/mysql-server: Command not found.
Ia legatura cu cei de la host, nu ai serverul mysql instalat pe mașina virtuală!Sader2321 scrie: ↑29 Iul 2020, 13:48
root@metin2:~ # /usr/local/etc/rc.d/mysql-server stop
/usr/local/etc/rc.d/mysql-server: Command not found.
root@metin2:~ # mysqld_safe --skip-grant-tables &
[1] 911
root@metin2:~ # mysql -u root
mysqld_safe: Command not found.
mysql: Command not found.
[1] + Exit 1 mysqld_safe --skip-grant-tables
root@metin2:~ # use mysql;
use: Command not found.
root@metin2:~ # update user set password=PASSWORD('razvanrzv') where user='root';
Badly placed ()'s.
root@metin2:~ # flush privileges;
flush: Command not found.
root@metin2:~ # quit
quit: Command not found.
root@metin2:~ # /usr/local/etc/rc.d/mysql-server stop
/usr/local/etc/rc.d/mysql-server: Command not found.
- Sader2321
-

- Mesaje: 26
- Membru din: 22 Mar 2020, 17:32
- Server: Metin2 Boom
- Regat: Jinno
- Aprecieri: 82
- Mulţumiri: 0
- Discord: Copiază ID
Este ca gen a mers da ma ajutat Kidro la o problema a schimbat Ip pe acolo si de atunci nu mai merge Mysql imi da aceasta errBroderHD scrie: ↑29 Iul 2020, 17:51Ia legatura cu cei de la host, nu ai serverul mysql instalat pe mașina virtuală!Sader2321 scrie: ↑29 Iul 2020, 13:48
root@metin2:~ # /usr/local/etc/rc.d/mysql-server stop
/usr/local/etc/rc.d/mysql-server: Command not found.
root@metin2:~ # mysqld_safe --skip-grant-tables &
[1] 911
root@metin2:~ # mysql -u root
mysqld_safe: Command not found.
mysql: Command not found.
[1] + Exit 1 mysqld_safe --skip-grant-tables
root@metin2:~ # use mysql;
use: Command not found.
root@metin2:~ # update user set password=PASSWORD('razvanrzv') where user='root';
Badly placed ()'s.
root@metin2:~ # flush privileges;
flush: Command not found.
root@metin2:~ # quit
quit: Command not found.
root@metin2:~ # /usr/local/etc/rc.d/mysql-server stop
/usr/local/etc/rc.d/mysql-server: Command not found.
uare
-
- Informaţie
-
Cine este conectat
Utilizatori ce ce navighează pe acest forum: Niciun utilizator înregistrat și 31 vizitatori