eroare resetare parola mysql

Totalitatea subiectelor care nu respectă regulamentul impus in sectiunea "Probleme şi Întrebări" vor fi stocate aici.
Închis
Avatar utilizator
KeonSeep
Utilizator interzis !

Utilizator interzis !
Mesaje: 358
Membru din: 14 Apr 2014, 10:44
Server: Metin2RO
Regat: Jinno
Aprecieri: 0
Mulţumiri: 0
Medalii

eroare resetare parola mysql .. ce pot face ??

Cod: Selectaţi tot

root@metin2:/usr/home/game/share/locale/germany/quest # /usr/local/etc/rc.d/mysql-server stop
Stopping mysql.
Waiting for PIDS: 799.
root@metin2:/usr/home/game/share/locale/germany/quest # chown -R mysql /var/db/mysql && chgrp -R mysql /var/db/mysql
root@metin2:/usr/home/game/share/locale/germany/quest # /usr/local/etc/rc.d/mysql-server start
Starting mysql.
root@metin2:/usr/home/game/share/locale/germany/quest # /usr/local/etc/rc.d/mysql-server stop
Stopping mysql.
Waiting for PIDS: 1208.
root@metin2:/usr/home/game/share/locale/germany/quest # mysqld_safe --skip-grant-tables &
[1] 1224
root@metin2:/usr/home/game/share/locale/germany/quest # 141117 20:21:27 mysqld_safe Logging to '/var/db/mysql/metin2.cehost.ro.err'.
141117 20:21:27 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql

root@metin2:/usr/home/game/share/locale/germany/quest #
root@metin2:/usr/home/game/share/locale/germany/quest #
root@metin2:/usr/home/game/share/locale/germany/quest # /usr/local/etc/rc.d/mysql-server stop
Stopping mysql.
Waiting for PIDS: 1299141117 20:22:23 mysqld_safe mysqld from pid file /var/db/mysql/metin2.cehost.ro.pid ended
.
[1]  + Done                          mysqld_safe --skip-grant-tables
root@metin2:/usr/home/game/share/locale/germany/quest # mysqld_safe --skip-grant-tables &
[1] 1325
root@metin2:/usr/home/game/share/locale/germany/quest # 141117 20:22:33 mysqld_safe Logging to '/var/db/mysql/metin2.cehost.ro.err'.

root@metin2:/usr/home/game/share/locale/germany/quest # 141117 20:22:39 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
/usr/local/etc/rc.d/mysql-server stop
Stopping mysql.
Waiting for PIDS: 1400141117 20:22:46 mysqld_safe mysqld from pid file /var/db/mysql/metin2.cehost.ro.pid ended
.
[1]  + Done                          mysqld_safe --skip-grant-tables
root@metin2:/usr/home/game/share/locale/germany/quest # mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Avatar utilizator
[Chuli-Gaara]
Nivel 10

Nivel 10
Mesaje: 2285
Membru din: 27 Oct 2014, 22:34
Server: Al meu
Regat: Chunjo
Aprecieri: 0
Mulţumiri: 17  
 Contact:
Medalii

http://just4metin.ro/ghiduri-tutoriale/ ... t3855.html

Sau:

Cod: Selectaţi tot

COD: SELECTATI TOT
/usr/local/etc/rc.d/mysql-server stop

apoi
COD: SELECTATI TOT
chown -R mysql /var/db/mysql && chgrp -R mysql /var/db/mysql

apoi
COD: SELECTATI TOT
/usr/local/etc/rc.d/mysql-server start

apoi
COD: SELECTATI TOT
/usr/local/etc/rc.d/mysql-server stop

apoi
COD: SELECTATI TOT
mysqld_safe --skip-grant-tables &

apoi
COD: SELECTATI TOT
mysql -u root

apoi
COD: SELECTATI TOT
use mysql;

apoi
COD: SELECTATI TOT
update user set password=PASSWORD("Parola ta") where User='root';

apoi
COD: SELECTATI TOT
flush privileges;

apoi
COD: SELECTATI TOT
quit

apoi
COD: SELECTATI TOT
service mysql-server restart
Închis
Răspunsuri
3
Vizualizări
197
Răspunsuri
5
Vizualizări
225
Răspunsuri
2
Vizualizări
75020

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

  • Informaţie
  • Cine este conectat

    Utilizatori ce ce navighează pe acest forum: Niciun utilizator înregistrat și 45 vizitatori