• java 执行mysql 8.0.11存储过程报错The user specified as a definer ('root'@'10.%.%.%') does not exist解决办法


    执行存储过程,报错

     

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

    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:127)

    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)

    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)

    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960)

    at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:388)

    at com.mysql.cj.jdbc.CallableStatement.execute(CallableStatement.java:809)

    at com.paxunke.smart.utils.MysqlUtils.execWriteReportProc(MysqlUtils.java:260)

    at com.paxunke.smart.testcase.Test.main(Test.java:125)

     

     执行 grant all privileges on *.* to root@"%" identified by "." 也报错

    mysql> grant all privileges on *.* to root@"%" identified by ".";

    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by "."' at line 1

     

     

    最终解决办法:

    执行sql语句:

      GRANT ALL PRIVILEGES ON database_name.* to 'root'@'localhost';

      FLUSH   PRIVILEGES; 

     

    存储过程中 definer修改为:root@localhost

      

     

     

  • 相关阅读:
    centos6.8 搭建nginx+uwsgi+Flask
    mysql root密码
    mysql查询最近一小时的数据
    linux-ssh远程后台执行脚本-放置后台执行问题(转)
    (转,有改动)测试网页响应时间的shell脚本[需要curl支持]
    shell将标准错误输出重定向到 其他地方
    CentOS6 Shell脚本/bin/bash^M: bad interpreter错误解决方法
    linux文件分发脚本
    Lucas定理及应用
    [SHOI2015]超能粒子炮·改
  • 原文地址:https://www.cnblogs.com/testway/p/9018893.html
Copyright © 2020-2023  润新知