[Solved] mysql 2003 remote access failed mysql8 configure remote access

# 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


Read More:

Leave a Reply

Your email address will not be published. Required fields are marked *