![]() This reply was modified 1 year, 4 months ago by OllieJones. When Query Monitor isn’t active, the failing query should be invisible.) ![]() (Detail: If the failing query involves the information_schema.INNODB_METRICS system table, that is a benign situation - it simply means the plugin has access to slightly less information about your server. If the plugin fails, would you be kind enough to reply to this thread and paste in the failing query? Query Monitor shows it in red The grant seems to work, but when I log on as the user and try to 'create view.', I get ERROR 1142 (42000): create view. (Different configurations of php and MySQL handle these errors differently, and I’d like to know which precise configurations you have, to add to my test suite.) 21:42 Sharon Banting I am having the same problem granting the create view privilege to a user. If it does display its Tools page, could you please go to the About tab (Tools > Index MySQL > About) and push the button to upload your metadata? If you tag your uploaded metadata “sim183” I’ll find it. If the plugin displays its Tools page in the dashboard it’s working correctly. Description: login mysql with a new connection,dont use 'use database' syntax,and create a view containing a from subquery by dbname. ![]() But Query Monitor also catches it and logs it. The plugin is programmed to catch the query error and do the right thing. It probably means that your MySQL user - DB_USER in wp-config.php - lacks the PROCESS privilege in the database. doesn't this mean this user should have all privileges for this database). Mysql 5.7 > CREATE OR REPLACE VIEW tmp.tmp AS SELECT n FROM (SELECT n FROM tmp.Thank you for the defect report. create view testview as select from transactions ERROR 1142 (42000): CREATE VIEW command denied to user 'callagga''localhost' for table 'testview'mysql> Any ideas why Note below in select from db, all the fields are 'Y' (i.e. Mysql 5.7 > CREATE OR REPLACE VIEW tmp.tmp AS SELECT n FROM (SELECT n FROM tmp.t1) t ĮRROR 1142 (42000): ANY command denied to user for table '' Mysql 5.7 > CREATE TABLE tmp.t1 (n INTEGER PRIMARY KEY) Type '\c' to clear the current input statement. Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. Server version: 5.7.21-log Source distribution 2017-SEP-06Ĭopyright (c) 2000, 2017, Oracle and/or its affiliates. ![]() > c:\dbs\5.7\bin\mysql -uroot -port=3570 -p -local-infile -prompt="mysql 5.7 > " mysql> show create table vwtest\G ERROR 1142 (42000): SHOW VIEW command denied to user 'baron''localhost' for table 'vwtest' mysql> show create view vwtest\G ERROR 1142 (42000): SHOW VIEW command denied to user 'baron''localhost' for table 'vwtest' Suggested fix: The error message should clarify the differen. Stored routines (stored procedures and functions) and views can include an SQL SECURITY clause with a value of DEFINER or INVOKER : CREATE DEFINERuser. MySQL Verification Team see looks like a partial C:\dbs ERROR 1142 (42000): ANY command denied to user for table '*' ![]() The commands have been tested on the official docker image version 5.7.7 and 5.7.19:ĭocker run -name some-mysql -e MYSQL_ROOT_PASSWORD=1234 -d mysql:5.7.19ĭocker run -it -link some-mysql:mysql -rm mysql:5.7.19 sh -c 'exec mysql -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -uroot -p"$MYSQL_ENV_MYSQL_ROOT_PASSWORD"'ĬREATE TABLE tmp.t1 (n INTEGER PRIMARY KEY) ĬREATE OR REPLACE VIEW tmp.tmp AS SELECT n FROM (SELECT n FROM tmp.t1) t While trying to come up with a minimal example exposing that error I ended up with this instead. At first the problem I encountered was a "No database selected" error while doing a select from a view that had a subquery as part of its definition. Without specifying a default schema it is not possible to create a view containing a subquery: ![]()
0 Comments
Leave a Reply. |