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

For an ordinary mysql account, if a connection is established on navicat12, double-click the execution function on the interface and report that the parameters are incorrect.

It is normal to use the root account to connect to this function.

The error is as follows:

Procedure execution failed

Incorrect number of arguments for FUNCTION we_newrs.func_nextval; expected 1, got 0

The English meaning is that the number of calling function parameters is wrong. One is needed and 0 is needed.

At first, I thought that this account did not execute execute permissions, authorized several times, and flush several times, but it was useless.

Later, under the command line, execute: select fun_xxxx ('xxx'); belongs to ok, only to know that this turns out to be a navicat problem.

Navicat12 executes sql/ to save function/procedure. When there is an error, the message returned indicates the error code and does not indicate the error location. Make your job 10 times more difficult. Not as good as the command line.

In addition, the change of authority, two things to be done.

3.1 remember on the server that flush privileges; asked you to change the write permission table

3.2 to restart the application, permission changes will not take effect for applications that are already connected to the database.

For example, if you authorize execute permissions, the application still reports to execute command denied to user xxx.

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.