How to allow remote MySQL user access

How to allow remote MySQL user access (successful experiment in Ubuntu) 1. after logging on as a root user, perform the following two steps (Note: [password] indicates the actual password of your root user): 1.1 usemysql; 1.2GRANTALLON *. * TO 'root' @ '%' IDENTIFIEDBY '[password]' WITHGRANTOPTION2. in Ubuntu

How to allow remote MySQL user access (successful test in Ubuntu)

1. Log On with the root user and perform the following two steps (Note: [password] indicates the actual password of your root user ):

1.1 use mysql;

1.2 grant all on *. * TO 'root' @ '%' identified by '[password]' WITH GRANT OPTION

2. in Ubuntu. you can find my. in the cnf configuration file, use sudo emacs or sudo vi to open it and find the following lines:

Bind-address = 127.0.0.1

Change bind-address = 127.0.0.1 to your local IP address. For example, if my IP address in a LAN is 192.168.1.93, change it:

Bind-address = 192.168.1.93

3. in the last step, restart your mysql instance and run "sudo/etc/ini" in the command line under ubuntu. d/mysql restart ". If it is found that it is successfully closed and restarted, it indicates OK. If it is found that it cannot be started, it may be the step 2 of my. when the cnf file is incorrect, it may be that you have added a bind-address or typed the wrong word. The bind-address port can be changed to only one and cannot have multiple.