Enable remote access in mysql

Mysql enables remote access to mysql-uroot-p and enters the password. Execute the following statement grantallprivilegeson *. * to 'user' @ '%' identifiedby 'Password' withgrantoption; user indicates the user name, mysql defaults to root, and password indicates the password. % Indicates any host. This way

Mysql enables remote access to mysql-uroot-p and enters the password. Run the following statement grant all privileges on *. * to 'user' @ '%' identified by 'Password' with grant option; user indicates the user name, mysql defaults to root, and password indicates the password. % Indicates any host. This way

Enable remote access for mysql

Mysql-uroot-p

Enter the password and execute the following statement:

Grant all privileges on *. * to 'user' @ '%' identified by 'Password' with grant option;

Here, user is the user name, mysql is the root by default, and password is set by yourself. % Indicates any host. This allows remote access from any host.