MySQL add remote user or allow remote access

Log in with the root user:

Using the GRANT statement:

1. Add a user admin and authorize access via local machine (localhost), password "something"

Mysql>grant all privileges on * * to [e-mail protected] identified by ' something ' with GRANT option;

2. Add a user admin and authorize access from any other host (wildcard%)

Mysql>grant all privileges on * * to [e-mail protected] "%" identified by ' something ' with GRANT option;

3. Refresh the Permissions list

Mysql>flush privileges;

MySQL add remote user or allow remote access