Shulou(Shulou.com)06/02 Report--

MySQL8.0 in which operation command, many novices are not very clear, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

The encryption rules of MySQL8.0 are different from those of MySQL5.0, but many tools are not supported. We use the method of modifying the encryption rules of MySQL login to mysql_native_password to solve this problem.

Modify encryption rules

ALTER USER 'root'@'localhost' IDENTIFIED BY' password' PASSWORD EXPIRE NEVER

Update root user password

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY' new_password'

Refresh permissions

FLUSH PRIVILEGES

MySQL8.0 creates a new user

PS:'root'@'localhost' and 'root'@'%' are two different users, so you can do this in order to change to%

CREATE USER 'root'@'%' IDENTIFIED BY' password';GRANT ALL PRIVILEGES ON *. * TO 'root'@'%'WITH GRANT OPTION;FLUSH PRIVILEGES; is helpful to you after reading the above content? if you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.