I heard that function password() is isolated in mysql 8
Posted by:
wu ryan
Date: March 09, 2020 07:26AM
Thanks everyone!
So now the method to change password of root are:
1. echo "skip-grant-tables" >> /etc/my.cnf
2. systemctl restart mysqld
3. mysql
mysql>use mysql
mysql>update user set authentication_string = '' where user = 'root';
mysql>flush privileges;
4. sed '/skip-grant-tables/d' /etc/my.cnf
5. systemctl restart mysqld
6. mysql -u root -p
mysql>alter user 'root'@'localhost' identified by 'yourpassword';
mysql>flush privileges; [do we need this one?]
Subject
Written By
Posted
I heard that function password() is isolated in mysql 8
March 09, 2020 07:26AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.