The user specified as a definer ('root'@'%') does not exist
The not 39 user root as specified
2023-09-27 14:23:17 时间
The user specified as a definer ('root'@'%') does not exist 此种报错主要是针对访问视图文件引起的(没有权限)
按照下图进行操作,
1.先看下mysql是否设置了环境变量,如果没设置,就需要切换到mysql的bin目录下执行命令(我的已经设置过了)
mysql -hlocalhost -uroot -p123456
2.给root用户添加权限
grant all privileges on *.* to root@"%" identified by ".";
3.刷新权限
flush privileges;
相关文章
- apache环境配置 | httpd Could not reliably determine the server's fully qualified domain name
- 笔记:Transcend the “Feature Factory” Mindset Using Modern Agile and OKR
- PL/SQL- ora-12154 '' TNS:could not resolve the connect identifier specified'
- uva331 - Mapping the Swaps
- HDU 2227 Find the nondecreasing subsequences (数状数组)
- could not insert: [com.trs.om.bean.UserLog] The user specified as a definer ('root'@'127.0.0.1') does not exist
- `pydot` failed to call GraphViz.Please install GraphViz (https://www.graphviz.org/) and ensure that its executables are in the $PATH.|dot" not found in path
- c-version:null]] could not deserialize the servlet-context scoped attribute with name: "MENU_LIST"
- php : Warning: strftime(): It is not safe to rely on the system's timezone settings.
- Jenkins 发布平台 MSB4064: The "Retries" parameter is not supported & error MSB4063: The "Copy" task could not be initialized
- JVM常用命令和性能调优建议 [Could not create the Java virtual machine]
- Access restriction: The type Resource is not accessible due to restriction on required library
- OpenCV reshape The Matrix is not continuous, thus its number of rows can not be changed
- spring boot The request was rejected because the URL was not normalized
- EMERGENCY! EUREKA MAY BE INCORRECTLY CLAIMING INSTANCES ARE UP WHEN THEY'RE NOT. RENEWALS ARE LESSER THAN THRESHOLD AND HENCE THE INSTANCES ARE NOT BEING EXPIRED JUST TO BE SAFE.
- 【人工智能】Responsible AI 负责任的人工智能:人工智能安全和隐私的未来 The Future of AI Security and Privacy
- The SDK directory '/home/wangju/gitProject/Automation/D:Android_SDK' does not exist.
- 安装nginx报错configure: error:the HTTP gzip module requires the zlib library.
- 安装J2EE的SDK报错:could not find the required version of the Java(TM)2 Runtime Environment in '(null)'的解决
- Plugin [id: 'org.jetbrains.kotlin.jvm'] was not found in any of the following sources。
- eclipse:报错信息The superclass "javax.servlet.http.HttpServlet" was not found on the Java Build Path
- STM32F4: Generating parallel signals with the FSMC
- Chapter 1: Creating the GUI Form and Adding Widgets
- Access restriction: The type JPEGImageEncoder is not accessible due to restriction
- 【ybt金牌导航3-6-3】【luogu P3007】奶牛议会 / The Continental Cowngress G(两种方法)
- tomcat 7 WARNING: A context path must either be an empty string or start with a '/' and do not end with a '/'. The path [/] does not meet these criteria and has been changed to []
- 2019-10-7-WPF-will-break-when-an-exception-be-throw-in-the-StylusPlugIn