MySQL root user is not allowed to connect remotely

Exception: Java.sql.SQLException:Access denied for user ' root ' @ ' rjb-z ' (using Passwrod).

　　String url = "jdbc:mysql://192.168.1.169:3306/test";  password Yes, the command-line window can be logged in. Surfing the internet to find out because the root user is not allowed to connect remotely,  I found a workaround on this site (http://xucons.javaeye.com/blog/278581): Change the table or empower. http://xucons.javaeye.com/blog/278581  This error occurs when you connect to MySQL:  SQL code     error 1130:host ' 192.168.1 .3 ' isn't allowed to connect to this MySQL server   [SQL] View plaincopy  The following is the reference:   ERROR 1130:host ' 192.168.1.3 ' isn't allowed to connect to this MySQL server    workaround:  1.　　Change the table method. It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer on the localhost, log in to MySQL, change the "MySQL" Database in the "User" table "host" item, from "localhost" to "%"   Java code mysql-u root-p &nbs　　P Mysql>use MySQL;   Mysql>update User Set host = '% ' where user = ' root ';   Mysql>select host, user from user;   [Java] view plaincopy mysql-u root-p   mysql>use MySQL;   Mysql>update User Set host = '% ' where user = ' root ';   Mysql>select host, user from user;   [Java] VIEW plaincopy    [Java] view plaincopy    2.　　Authorization law.　　For example, if you want to myuser use MyPassword to connect to a MySQL server from any host.　　SQL code GRANT all privileges on *. * to ' myuser ' @ '% ' identified by ' MyPassword ' with GRANT OPTION; [SQL] View plaincopy grant all privileges on * * to ' myuser ' @ '% ' identified by ' MyPassword ' with GRANT OPTION;     If you want to allow users to connect to the MySQL server from the IP myuser host, and use MyPassword as the password SQL code GRANT all privileges on *. * to ' myuser ' @ ' 192.168.1.3 ' identified by ' MyPassword ' with GRANT option;  himself is using the second method.  

Root user for MySQL does not allow remote connections