Good afternoon.
Next, I had to release remote access so one server can access the mysql database from another. I followed the steps of this link: link
When I ran this command:
GRANT ALL PRIVILEGES ON *.* TO usuario@HOST IDENTIFIED BY 'senha';
He returned this error to me
Can not load from mysql.user. The table is probably corrupted
So I ran this command
mysql_upgrade --force -uroot -p
Then I tried to run GRANT ALL PRIVILEGES again and I had this error
You must reset your password using ALTER USER statement before executing this statement.
Then I reset the password with this command
SET PASSWORD = PASSWORD('admin@next');
In doing so, he returned this to me
Column count of mysql.user is wrong. Found Expected 45, found 46. The table is probably corrupted
Now the best part, I'm practically in an infinite loop of life. Because I was running "mysql_upgrade" again and it returned me this.
mysql_upgrade: Got error: 1862: Your password has expired. Log in you must change it using a client that supports expired passwords. while connecting to the MySQL server
And now I can not do anything else, because when I try to connect to mysql it says that the password has expired, then I try to reset the password and it says that mysql.user is corrupted, then I give "mysql_upgrade" to adjust and it says the password has expired hahaha.
Can anyone help me, please?
Thank you.