Shulou(Shulou.com)06/01 Report--

During today's project optimization, mysql has a problem The user specified as a definer ('wx_root'@'%') does not exist

Check it out, which means that you don't have permission to execute sql. Take a look at the database user is quoters and sql does not have ownership. Then find out why. It was found that a stored procedure was called during the execution of sql

The creator of this stored procedure is wx_root. So during execution, quoters does not have permission

Solutions and actions:

1. View the object to which the stored procedure belongs: right-click the stored procedure function-> Select object Properties-- > check whether the function is created and belongs to the user who is currently logged in.

2. If not, back up the original stored procedure function, copy everything in the stored procedure function, create a new stored procedure, and name it as before.

3. In this way, the creator belongs to the currently logged in user. The original function can be deleted or retained (if you are not sure, it is best to keep it first)

There are other reasons that may cause this error, such as no permission to execute the mysql view

The solution for view without permission is as follows

The user specified as a definer ('root'@'%') does not exist.

This is generally because the root user does not have access to the global host. So just add an access right to the root user.

Solution:

Log in to mysql and execute mysql-u root-pPasswdmysql > grant all privileges on *. * to root@ "%" identified by "Passwd" mysql > flush privileges

Summary

The above is the whole content of this article. I hope the content of this article has a certain reference and learning value for everyone's study or work. Thank you for your support. If you want to know more about it, please see the relevant links below.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.