is_basics_mixed.result

来自「这个文件是windows mysql源码」· RESULT 代码 · 共 603 行 · 第 1/3 页

RESULT
603 行
字号
123
SHOW DATABASES LIKE 'information_schema';Database (information_schema)information_schema######################################################################## Testcase 3.2.1.20: USE INFORMATION_SCHEMA is supported######################################################################## Switch to connection defaultUSE test;SELECT DATABASE();DATABASE()testUSE information_schema;SELECT DATABASE();DATABASE()information_schemaDROP   USER 'testuser1'@'localhost';CREATE USER 'testuser1'@'localhost';# Establish connection testuser1 (user=testuser1)SELECT DATABASE();DATABASE()testUSE information_schema;SELECT DATABASE();DATABASE()information_schema# Switch to connection default and close connection testuser1DROP   USER 'testuser1'@'localhost';######################################################################## Testcase TBD1: The INFORMATION_SCHEMA cannot be dropped.#######################################################################DROP DATABASE information_schema;ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'######################################################################## Testcase TBD2: There cannot be a second database INFORMATION_SCHEMA.#######################################################################CREATE DATABASE information_schema;ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'################################################################################### Testcase 3.2.1.6+3.2.1.7: No user may create an INFORMATION_SCHEMA table or view################################################################################### Switch to connection default (user=root)USE information_schema;CREATE TABLE schemata                              ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE tables                                ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE columns                               ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE character_sets                        ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE collations                            ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE collation_character_set_applicability ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE routines                              ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE statistics                            ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE views                                 ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE user_privileges                       ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE schema_privileges                     ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE table_privileges                      ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE column_privileges                     ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE table_constraints                     ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE key_column_usage                      ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE triggers                              ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE t1 (f1 INT, f2 INT, f3 INT);ERROR 42S02: Unknown table 't1' in information_schemaCREATE VIEW tables AS SELECT 'garbage';ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE VIEW tables AS SELECT * FROM information_schema.tables;ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE VIEW v1 AS SELECT 'garbage';ERROR 42S02: Unknown table 'v1' in information_schemaUSE test;CREATE TABLE information_schema. schemata                              ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE information_schema. tables                                ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE information_schema. columns                               ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE information_schema. character_sets                        ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE information_schema. collations                            ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE information_schema. collation_character_set_applicability ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE information_schema. routines                              ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE information_schema. statistics                            ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE information_schema. views                                 ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE information_schema. user_privileges                       ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE information_schema. schema_privileges                     ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE information_schema. table_privileges                      ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE information_schema. column_privileges                     ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE information_schema. table_constraints                     ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE information_schema. key_column_usage                      ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE information_schema. triggers                              ( c1 INT );ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE TABLE information_schema.t1 (f1 INT, f2 INT, f3 INT);ERROR 42S02: Unknown table 't1' in information_schemaCREATE VIEW information_schema.tables AS SELECT 'garbage';ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE VIEW information_schema.tables ASSELECT * FROM information_schema.tables;ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'CREATE VIEW information_schema.v1 AS SELECT 'garbage';ERROR 42S02: Unknown table 'v1' in information_schemaDROP   USER 'testuser1'@'localhost';CREATE USER 'testuser1'@'localhost';GRANT ALL ON *.* TO testuser1@localhost;SHOW GRANTS FOR testuser1@localhost;Grants for testuser1@localhostGRANT ALL PRIVILEGES ON *.* TO 'testuser1'@'localhost'# Establish connection testuser1 (user=testuser1)USE information_schema;CREATE TABLE schemata                              ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE tables                                ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE columns                               ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE character_sets                        ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE collations                            ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE collation_character_set_applicability ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE routines                              ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE statistics                            ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE views                                 ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE user_privileges                       ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE schema_privileges                     ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE table_privileges                      ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE column_privileges                     ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE table_constraints                     ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE key_column_usage                      ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE triggers                              ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE t1 (f1 INT, f2 INT, f3 INT);ERROR 42S02: Unknown table 't1' in information_schemaCREATE VIEW tables AS SELECT 'garbage';ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE VIEW tables AS SELECT * FROM information_schema.tables;ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE VIEW v1 AS SELECT 'garbage';ERROR 42S02: Unknown table 'v1' in information_schemaUSE test;CREATE TABLE information_schema. schemata                              ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE information_schema. tables                                ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE information_schema. columns                               ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE information_schema. character_sets                        ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE information_schema. collations                            ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE information_schema. collation_character_set_applicability ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE information_schema. routines                              ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE information_schema. statistics                            ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE information_schema. views                                 ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE information_schema. user_privileges                       ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE information_schema. schema_privileges                     ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE information_schema. table_privileges                      ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE information_schema. column_privileges                     ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'CREATE TABLE information_schema. table_constraints                     ( c1 INT );ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'information_schema'
123

is_basics_mixed.result - 源码说明

本页面展示了「这个文件是windows mysql源码」中的 is_basics_mixed.result 源码文件，采用 RESULT 编程语言编写，共 603 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与windows相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?