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

The first:

Assign all privileges to root: note the action below the command character.

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

flush privileges;

But after this restart, it won't work for a while.

Second:

Copy the view creation statement, directly change create to alter, definer to related, such as root@localhost For example:

Alter view to modify the definer value, alter ALGORITHM=UNDEFINED DEFINER=`public`@`192.168.0.%` SQL SECURITY DEFINER VIEW `view_product` AS View selection statement.

By executing use information_schema; and select TABLE_SCHEMA,TABLE_NAME,DEFINER from views;, you can query whether the definer has been successfully changed.

cause analysis

Because the view was created using xff@% user (no longer exists), and then the login user used xff@localhost user, mysql thinks that the current user has no permission to access the view, the solution is to rebuild the view under the current user.

Another way is if you are an operation and maintenance person, this problem is directly handled by the program, and it is checked to create triggers, views, stored procedures, etc. sql. If root@% is included, replace it. Recreate. I haven't tried it, but I can try it later.

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.