Mysql 8.0 Allow Root Remote Login

When setting up mysql with mysql_secure_installation, Disallow root login remotely set to no,

but login with root user from remote is still blcoked, try the other methods, such as blow.

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
mysql> UPDATE mysql.user SET host='%' WHERE user='root';

and then restart msyql service.

Leave a Reply

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