![]() ![]() Mysql 5.7 > CREATE OR REPLACE VIEW tmp.tmp AS SELECT n FROM (SELECT n FROM tmp. 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. 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. You can then exit the MySQL console: exit. Most modern versions of MyQL replace the databasename with in the grant privileges command after you select the database that you want to use. TO rootlocalhost command may not work for modern versions of MySQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |