bug-linux-win(java.sql.SQLException: null, message from server: “Host ‘192.168.1.66‘ is not allowe)

查看进程，经常使用ps axu|grep 应用或者项目名

kill -9 端口号----9强制杀死某进程

确保yml配置了sql所在的电脑ip，linux,win的防火墙关闭了

[root@localhost myproject]# ps axu|grep boot01

root     10385  0.4 17.1 2306596 173868 pts/1  Sl   16:41   0:22 java -jar -Dlogging.file=yyy.log boot01-0.0.1-SNAPSHOT.jar

root     10485  0.0  0.0 112808   968 pts/1    R+   18:06   0:00 grep --color=auto boot01

[root@localhost myproject]# kill -9 10385

[root@localhost myproject]# ps axu|grep boot01

root     10487  0.0  0.0 112808   968 pts/1    R+   18:07   0:00 grep --color=auto boot01

[1]+  Killed                  nohup java -jar -Dlogging.file=yyy.log boot01-0.0.1-SNAPSHOT.jar

nohup java -jar -Dlogging.file=yyy.log boot01-0.0.1-SNAPSHOT.jar &

&必须要

nohup java -jar -Dserver.port=yyy -Dlogging.file=/xx/xx/yyy.log yyy.jar &

nohup java -jar -Dlogging.file=yyy.log boot01-0.0.1-SNAPSHOT.jar &

[root@localhost myproject]# ll

total 29992

-rw-r--r--. 1 root root 30708526 Apr  1 18:00 boot01-0.0.1-SNAPSHOT.jar

[root@localhost myproject]# nohup java -jar -Dlogging.file=yyy.log boot01-0.0.1-SNAPSHOT.jar &

[1] 10491

[root@localhost myproject]# nohup: ignoring input and appending output to ‘nohup.out’

ll

total 29996

-rw-r--r--. 1 root root 30708526 Apr  1 18:00 boot01-0.0.1-SNAPSHOT.jar

-rw-------. 1 root root     1987 Apr  1 18:16 nohup.out

查看日志输出（可以查错）

[root@localhost myproject]# cat nohup.out

  .   ____          _            __ _ _

/\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \

( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \

\\/  ___)| |_)| | | | | || (_| |  ) ) ) )

  '  |____| .__|_| |_|_| |_\__, | / / / /

=========|_|==============|___/=/_/_/_/

:: Spring Boot ::                (v2.6.5)

2022-04-01 18:15:54.824  INFO 10491 --- [           main] com.hzit.boot01.Boot01Application        : Starting Boot01Application v0.0.1-SNAPSHOT using Java 1.8.0_144 on localhost.localdomain with PID 10491 (/usr/local/myproject/boot01-0.0.1-SNAPSHOT.jar started by root in /usr/local/myproject)

2022-04-01 18:15:54.827  INFO 10491 --- [           main] com.hzit.boot01.Boot01Application        : No active profile set, falling back to 1 default profile: "default"

2022-04-01 18:15:59.484  INFO 10491 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8001 (http)

2022-04-01 18:15:59.515  INFO 10491 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]

2022-04-01 18:15:59.529  INFO 10491 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.60]

2022-04-01 18:15:59.939  INFO 10491 --- [           main] o.a.c.c.C.[.[localhost].[/boot01]        : Initializing Spring embedded WebApplicationContext

2022-04-01 18:15:59.940  INFO 10491 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 4930 ms

2022-04-01 18:16:03.841  INFO 10491 --- [           main] o.s.b.a.e.web.EndpointLinksResolver      : Exposing 1 endpoint(s) beneath base path '/actuator'

2022-04-01 18:16:04.104  INFO 10491 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8001 (http) with context path '/boot01'

2022-04-01 18:16:04.186  INFO 10491 --- [           main] com.hzit.boot01.Boot01Application        : Started Boot01Application in 10.739 seconds (JVM running for 12.07)

-------------------------------------------------

cat nohup.out

看到一段报错（linux端）

java.sql.SQLException: null,  message from server: "Host '192.168.1.66' is not allowed to connect to this MySQL server"

test还是报错（删除了一些之前无用用户，请忽略）

改

测试成功！

yml改win的ip了（应该是mysql用户原因）

http://localhost:8001/boot01/login.html=http://192.168.1.75:8001/boot01/login.html效果报错（win端）

小结：

先在win(server)测试过了，再发到Linux

还是新增用户比较好，不然本地ip变化后会出现

误删MySQL mysql.infoschema 用户。The user specified as a definer (‘mysql.infoschema‘@‘localhost‘) does no_starxg的博客-CSDN博客1. 控制台连接MySQLmysql -uroot -proot2. 创建用户CREATE USER 'mysql.infoschema'@'localhost' IDENTIFIED BY 'password';3. 赋权GRANT SELECT ON *.* TO `mysql.infoschema`@`localhost`;4. 完工。https://blog.csdn.net/qq_38132283/article/details/109727195?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522164940918916780357214742%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=164940918916780357214742&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v1~rank_v31_ecpm-1-109727195.142^v7^pc_search_result_cache,157^v4^control&utm_term=The+user+specified+as+a+definer+%28mysql.infoschema%40localhost%29+does+not+exist&spm=1018.2226.3001.4187

The user specified as a definer ('mysql.infoschema'@'localhost') does not exist