Mysql Enable remote connection

MySQL does not allow remote connections by default, because there is a large security risk, so you need to manually increase the number of users who can access the database remotely. Here's how to connect: # mysql-u Root-p >;grant select,insert,update,delete On * * to [e-mail protected] "192.168.100.216" identified by "Sookwire"; ----Allow the address 202.11.10.253 on the root user, password dboomysql to connect all MySQL database, pay Select,insert,update,delete permissions. Grant all on * * to [e-mail protected] "192.168.100.213" identified by "Sookwire" Allow the address 192.168.100.213 with root user, password sookwire to connect all MySQL database, pay all permissions. This allows MySQL to be accessed remotely using the database management software.

Mysql Enable remote connection