*Problemă:Am schimbat parola mysql de N ori,si tot nu ma pot conecta la navicat.
Tipologie server:PvP
*Resursă folosita: -
*ServerFiles utilizat: http://just4metin.ro/serverfiles/server ... 70670.html
*Syserr: Nu cred ca are legatura,daca are revin cu edit.
Poză:
*Detalii suplimentare: Ma chinui de la ora 20:30 sa fac chestia asta.

up

Synse scrie:up

user: !@#ath2!@#
pw: vT38JCjwNHpwm74C

/usr/local/etc/rc.d/mysql-server stop
mysqld_safe --skip-grant-tables &
mysql -u !@#ath2!@#
use mysql;
update user set password=PASSWORD("parolatanoua") where User='!@#ath2!@#';
flush privileges;
quit

BeauDeCiuda scrie:

Synse scrie:up

user: !@#ath2!@#
pw: vT38JCjwNHpwm74C

/usr/local/etc/rc.d/mysql-server stop
mysqld_safe --skip-grant-tables &
mysql -u !@#ath2!@#
use mysql;
update user set password=PASSWORD("parolatanoua") where User='!@#ath2!@#';
flush privileges;
quit

Tot nu merge

Synse scrie:

BeauDeCiuda scrie:

Synse scrie:up

user: !@#ath2!@#
pw: vT38JCjwNHpwm74C

/usr/local/etc/rc.d/mysql-server stop
mysqld_safe --skip-grant-tables &
mysql -u !@#ath2!@#
use mysql;
update user set password=PASSWORD("parolatanoua") where User='!@#ath2!@#';
flush privileges;
quit

Tot nu merge

Dupa ce ai schimbat parola la db in putty ti-a dat warring ?

mysql -u !@#ath2!@# - cand am bagat comanda asta mi-a dat error

Up

BeauDeCiuda scrie:

Synse scrie:up

user: !@#ath2!@#
pw: vT38JCjwNHpwm74C

/usr/local/etc/rc.d/mysql-server stop
mysqld_safe --skip-grant-tables &
mysql -u !@#ath2!@#
use mysql;
update user set password=PASSWORD("parolatanoua") where User='!@#ath2!@#';
flush privileges;
quit

Bravo tata, mare helper.

Synse scrie:up

1. use mysql -u root
2. scrii parola pe care ai resetat-o si dai enter
3. CREATE USER 'nume'@'%' IDENTIFIED BY 'parola';
4. GRANT ALL PRIVILEGES ON *.* TO 'nume'@'%';
5. flush privileges;
6. exit;

Daca nu merge dai reply .

[ Postat de pe Android ]

mysql -u root -> Command not found...

sTrix. scrie:

BeauDeCiuda scrie:

Synse scrie:up

user: !@#ath2!@#
pw: vT38JCjwNHpwm74C

/usr/local/etc/rc.d/mysql-server stop
mysqld_safe --skip-grant-tables &
mysql -u !@#ath2!@#
use mysql;
update user set password=PASSWORD("parolatanoua") where User='!@#ath2!@#';
flush privileges;
quit

Bravo tata, mare helper.

Synse scrie:up

1. use mysql -u root
2. scrii parola pe care ai resetat-o si dai enter
3. CREATE USER 'nume'@'%' IDENTIFIED BY 'parola';
4. GRANT ALL PRIVILEGES ON *.* TO 'nume'@'%';
5. flush privileges;
6. exit;

Daca nu merge dai reply .

[ Postat de pe Android ]

use mysql -u root -> command not found