Problema resetare parola mysql

YTxMinato. · 14 Feb 2016, 21:10

Salut,
Am FreeBSD 9.2 64 bit, si am instalat un sf cu sursa...
iar cand vreau sa schimb parola mysql imi da eroarea:

/usr/local/etc/rc.d/mysql-server: Command not found.

ce pot sa fac? cum rezolv?
pe FreeBSD 10.1 imi merge, dar nu pot compila sursa

Cod: Selectaţi tot

BAZA DE DATE
Real Server
Log Offmysql_real_connect: Can't connect to local MySQL server through socket '/                                tmp/mysql.sock' (2)
   failed, retrying in 5 seconds

 LOGIN
PUBLIC_IP: 5.154.174.157 interface re0
HOSTNAME: dev_0
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: ezio db: common
cannot start server while no common sql connected

 CORE2
PUBLIC_IP: 5.154.174.157 interface re0
HOSTNAME: dev1_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: 5.154.174.157 interface re0
HOSTNAME: dev1_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

 GAME99
PUBLIC_IP: 5.154.174.157 interface re0
HOSTNAME: dev99_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

Rezolvare?
Multumesc

dragoialex2014 · 14 Feb 2016, 21:12

Te ajut eu sa resetezi parola
PM IN PRIVAT CU SKYPE-UL

YTxMinato. · 14 Feb 2016, 21:23

fb : Ionut Daniel (Official)
daca stie cineva sa ma ajute.

NU FOLOSESC Skype ca imi da crash de la windows
doar pe fb , cu team viewer.

YTxMinato. · 15 Feb 2016, 12:31

up.

Stie cineva ? va rog

17 Feb 2016, 12:16

mysql-server [stop/start]

Uite aici comandă bună de restat parola mysql .. deci dai rm -rf mysql şi pe urmă instalezi iar şi urmăreşti tutorialul care ţi l-am dat şi după ce dai service mysql-server restart aştepţi să se termine şi pe urmă REBOOT ! şi pe urmă dai start

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;
apoi
update user set password=PASSWORD("parola") where User='root';
apoi
flush privileges;
apoi
quit

Şi şterge fişierele cu extensia .err şi .pid din var/db/mysql

20 Feb 2016, 22:22

Dacă în 3 zile autorul subiectului nu va da niciun semn de viata în topic, subiectul va fi mutat în Arhivă Probleme şi Întrebări.