Daca adaugi serverfiles pe un VPS/VDI care are alta versiune de MySQL vei primi aceasta eroare:
COLUMN COUNT OF MYSQL.USER IS WRONG. EXPECTED 42, FOUND 39. CREATED WITH MYSQL 50173, NOW RUNNING 50560. PLEASE USE MYSQL_UPGRADE TO FIX THIS ERROR.
Pentru a rezolva deschidem putty si ne conectam, dupa care rulam comenzile:
Code:
mysql_upgrade --force -u root -p
service mysqld restart
Code:
grant all privileges on *.* to 'root'@'%' identified by 'parolamysqlaici' with grant option; flush privileges;