在jdbc连接java中设置mysql用户主机

Question

我试图连接到javahtml" target="_blank">远程mysql服务器，从ip111.111.111.111到ip111.111.111.222JDBC连接器：

conn = DriverManager.getConnection("jdbc:mysql://"+serverAddress+":3306/" + this.dBName + "?" + "user=" + this.userName + "&password=" + this.password + "");

• user@111.111.111.111在数据库中创建，GRANTS工作正常。
• 数据库中不存在user@localhost，因为我认为没有必要。
• 防火墙允许连接。

由于某种原因，当我尝试启动连接时，会生成一个异常：

java.sql.SQLException: The user specified as a definer ('user'@'localhost') does not exist

但我请求IP111.111.111.111连接

注意：当我在用户名中写入@时，会显示正确的主机ip，但会附加@，如下所示：

java.sql.SQLException: Access denied for user 'user@'@'111.111.111.111' (using password: YES)

那么，我做错了什么？或者如何设置mysql用户名的主机？

编辑：

此外，我已经通过终端测试了mysql连接，它可以正常工作：（so@SSSip是111.111.111.111）

so@SSS:~$ mysql -h 111.111.111.222 -u user -p dbname
Enter password: 
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 85
Server version: 5.7.17 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show tables;
+---------------------+
| Tables_in_dbname |
+---------------------+
| wh_with_customer    |
+---------------------+
10 rows in set (0,00 sec)

Answer 1

从我的角度来看，您没有向用户授予权限

GRANT ALL PRIVILEGES ON *.* TO 'user'@'111.111.111.111' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;

执行它并将PASSWORD替换为您的真实密码。

或者，尝试使用DriverManager。getConnection（字符串url、字符串用户、字符串密码）除

DriverManager.getConnection("jdbc:mysql://"+serverAddress+":3306/" + this.dBName + "?" + "user=" + this.userName + "&password=" + this.password + "");

驾驶员管理器。getConnection（字符串url）要求url采用jdbc:subtocol:subname格式，getConnection（url、用户名、密码）更精确