# mysql -uroot -p
> use mysql;
> select host, user, authentication_string, plugin from user;
> GRANT ALL ON *.* TO 'root'@'%';
> flush privileges;
> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
> FLUSH PRIVILEGES;
> exit;
# service mysql restart
[Solved] mysql 2003 remote access failed mysql8 configure remote access
Leave a reply