Unlock mysql remote access. Problems with mysql.user and password expired

0

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.

    
asked by anonymous 08.03.2018 / 18:51

0 answers