MySQL Remote connection permission opening statement

MySQL Remote connection permissions open to execute the following statement:

#视自己情况修改, user name and password

The code is as follows	Copy Code
GRANT all on *.* to root@ "%" identified by "your own password"; Flush privileges; Exit

Reminder, if the remote function is turned on the server security may be unsafe, so we should pay attention to small oh, of course, we can specify that IP can be remotely connected

The code is as follows	Copy Code
Grant all privileges in *.* to ' root ' @ ' 192.168.0.1 ' identified by ' Root-password '; Flush privileges; Exit

192.168.0.1 is the client IP that connects the MySQL server