[KintaRoyala69]

*Problemă/Întrebare:

*Resursă folosită (sistem/funcție/modificare):

*Syserr:

*Fișier(e) cu problema (link pastebin / code):

*Poze / Video: Salut baietii. vreau sa schimb parola la navicat si userul si cand dau sa salvez imi apare eroarea asta

Show Spoiler

column count of mysql.user is wrong. expected 42, found 43. created with mysql 50173, now running 50560. please use mysql_upgrade to fix this error.

Am mysql 5.6, ce trebuie sa fac sa rezolv?

[SCOOB]

Ai vers de mysql mai mica pe freebsd decat cea pe care serverfiles-ul o foloseste.

Scrie comenzile astea in putty

Code:

mysql_upgrade --force -u root -p

Code:

service mysqld restart

[KintaRoyala69]

Ai vers de mysql mai mica pe freebsd decat cea pe care serverfiles-ul o foloseste.

Scrie comenzile astea in putty

Code:

mysql_upgrade --force -u root -p

Code:

service mysqld restart

Cand rulez comanda

Code:

mysql_upgrade --force -u root -p

imi da

Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Error: Failed while fetching Server version! Could be due to unauthorized access.
FATAL ERROR: Upgrade failed

ce trebuie sa fac?

[KintaRoyala69]

Ai vers de mysql mai mica pe freebsd decat cea pe care serverfiles-ul o foloseste.

Scrie comenzile astea in putty

Code:

mysql_upgrade --force -u root -p

Code:

service mysqld restart

Cand rulez comanda

Code:

mysql_upgrade --force -u root -p

imi da

Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Error: Failed while fetching Server version! Could be due to unauthorized access.
FATAL ERROR: Upgrade failed

ce trebuie sa fac?

upp

[SCOOB]

created with mysql 50173, now running 50560.

trebuie sa scrii asta:

Code:

grant all privileges on *.* to 'root'@'%' identified by 'parola la root aici' with grant option; flush privileges;

[KintaRoyala69]

es;

ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 50553, now running 50647. Please use mysql_upgrade to fix this error.

[ZuZuR]

es;

ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 50553, now running 50647. Please use mysql_upgrade to fix this error.

Ai facut update la mysql? sau ce ai facut inainte sa apara problema?
Incearca totusi un Repair:

Show Spoiler

Show Spoiler

mysql -u root -p

Show Spoiler

USE mysql;
REPAIR TABLE user;