MySQL allow remote access

MySQL allow remote access

Say you want to allow the user root with the password of password remote access to the database of test.

GRANT ALL PRIVILEGES ON test.* TO 'root'@'%' IDENTIFIED BY 'password';

FLUSH PRIVILEGES;
quit;