Bug #81082 | MySQL X console on Windows?? | ||
---|---|---|---|
Submitted: | 14 Apr 2016 13:37 | Modified: | 19 May 2016 22:53 |
Reporter: | Peter Laursen (Basic Quality Contributor) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Documentation | Severity: | S2 (Serious) |
Version: | 5.7.12 | OS: | Windows |
Assigned to: | CPU Architecture: | Any |
[14 Apr 2016 13:37]
Peter Laursen
[14 Apr 2016 15:11]
MySQL Verification Team
the mysql shell is a separate download, available here: http://dev.mysql.com/downloads/shell/
[14 Apr 2016 15:12]
Peter Laursen
OK.. but what is the 'mysqlxtest.exe' then?
[14 Apr 2016 15:13]
MySQL Verification Team
I do see a place for windows specific improvement in the docs here: http://dev.mysql.com/doc/refman/5.7/en/document-store-setting-up.html they talk about the serverside plugin but not mysql shell client on windows..
[14 Apr 2016 15:14]
Peter Laursen
.. and is it planned to have it offered by the MySQL Installer for Windows?
[14 Apr 2016 15:17]
Peter Laursen
"but not mysql shell client on windows". Actually it should also be clarifed if it can be run in "Windows Powershell" or not. I could imagine some oddities happening here (with loops, conditions etc.) in some cases.
[14 Apr 2016 15:31]
Peter Laursen
and what is this: .. and what is this: C:\Program Files\MySQL\MySQL Shell 1.0\bin>mysqlsh -uroot pltest --port=3310 Creating an X Session to root@localhost:3310/pltest Enter password: ******** MySQL Error (2027): Unknown message received from server 10 .. and C:\Program Files\MySQL\MySQL Shell 1.0\bin>mysqlsh -uroot pltest Creating an X Session to root@localhost:33060/pltest Enter password: ******** MySQL Error (2002): Der kunne ikke oprettes forbindelse, fordi destinationscomputeren aktivt nĀµgtede det connecting to localhost:33060 (now - this as not supposed to work as the server on port 3306 is a MariaDB 10.1 server. but why doesit print the prot as "33060" and not "3306" in the error message. I still hve to ask if mysqlsh works on Windows at all.
[14 Apr 2016 16:00]
MySQL Verification Team
it does work on windows. the port is 33060 by default. check if server has the mysqlx plugin loaded by running "show plugins;" ... | ngram | ACTIVE | FTPARSER | null | GPL | | mysqlx | ACTIVE | DAEMON | mysqlx.dll | GPL | +----------------------------+----------+--------------------+------------+---------+ In mysql error log it also says a few lines: [Note] Plugin mysqlx reported: 'X plugin tcp connection enable at port 33060.' [Note] Plugin mysqlx reported: 'Scheduler "work" started.' [Note] Plugin mysqlx reported: 'X plugin initialization successes' Then you should be able to login: E:\mysql-shell-1.0.3-winx64\bin>mysqlsh.exe -uroot --classic Creating a Classic Session to root@localhost:3306 Enter password: No default schema selected. Welcome to MySQL Shell 1.0.3 Development Preview Copyright (c) 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type '\help', '\h' or '\?' for help. Currently in JavaScript mode. Use \sql to switch to SQL mode and execute queries. mysql-js>
[19 May 2016 22:53]
Christine Cole
Posted by developer: MySQL Shell is downloaded separately from MySQL 5.7.12 -- The original documentation now includes download/installation instructions for MySQL Shell on Windows. http://dev.mysql.com/doc/refman/5.7/en/installing-mysql-shell-windows-quick.html