info about MySQL Shell

Question

I'm using the MySQL shell for the first time. I ran the following commands:

    \connect --mysql root@localhost:3306
    \use myschema

But, when I try to follow this instruction:

    myColl = db.createCollection('my_coll')

I get the error:

    TypeError: Cannot read property 'createCollection' of null

The error obviously is due to the fact that db object is null, but I don't know the syntax to instantiate it.

Is the `db` part in something else other than the `mysql>` shell? Is that Python? — tadman, Dec 17 '20 at 11:10
You can only issue mysql commands from mysql shell and myColl = db.createCollection('my_coll') isn't a sql statement..and that error is not a mysql error. so what do you mean by mysql shell? — P.Salmon, Dec 17 '20 at 12:01
@P.Salmon [MySQL Shell](https://dev.mysql.com/doc/mysql-shell/8.0/en//) — Álvaro González, Dec 18 '20 at 12:36
I can run the command without any issue. Are you sure 1. your server supports the mysqlx protocol? (>=8.0 I think?) 2. you have started a mysqlx session? (use `mysqlx://xxxx` URI or `--sqlx` — Frederick Zhang, Dec 18 '20 at 14:16

score 1 · Answer 1 · answered Dec 29 '20 at 13:38

Commands like createCollection() are part of the X DevAPI which is a client-side interface for the MySQL X Protocol. You are using --mysql which creates a connection to the server using the MySQL Classic Protocol, which only supports SQL. To create an X Protocol connection, and assuming the X Plugin is enabled in the default server port, you should use --mysqlx instead:

\connect --mysqlx root@localhost:33060

Disclaimer: I'm the lead developer of the MySQL X DevAPI Connector for Node.js

info about MySQL Shell

1 Answers1